We are facing a problem in loading Excel files when we are trying to load from Excel File Format.
Here is a sample input which we are giving.
This is going through excel files. I have about 100 excel files to be loaded everyday. And this was working fine when my DS was installed on WINDOWS environment.
But when we shift to UNIX. The output of this file format comes as :
I have no clue currently why is it happening and how to correct it.
I cant change for everyfile so a standard solution is what i am looking for. If i change to .csv , this works fine, but i cant change my 100 files to CSV as there are some complications in it.
I am on Data Services 3.2.