Let me preface the query with the fact that I am unable to send you the original source file as it contains sensitive and confidential data from a trading partner. Plus, if I save the file and sanitise it the issue disappears which leads me to believe it is a data formatting workbook formatting issue in the source file.
The scenario is
- receive an XLS file from a trading partner via email containing two sheets. The first is just a header/summary sheet, the second sheet contains rows and columns of data with a mixture of text, dates and numerics
If we drag and drop the message to a folder and then drag and drop the file to EM as a new Import Table only the numeric values and the occasional text value are brought across. There columns containing text are shown as place holders but they appear 'visually empty'. EM also is not able to identify the first row as containing headers. It is like all Text elements are ignored.
If we Open the source file in excel and save it in the same format (.XLS) and make no changes whatsoever, the file increases in size from 17K to 27K and will successfully import into EM.
I am unable to simulate the issue as creating and saving any excel file seems to always work. My guess is that this XLS file is generated at the Partner end by some type of report generation tool that is possibly pushing some type of formatting codes or even perhaps encoding the data some how that prevents EM from interpreting it correctly and that when we save the file from within Excel this is corrected and the file can then be interpreted.