Translate
I received a Japanese Excel file today from a client. I was not available but out of interest I tried to load it into Studio 2015 using the standard Excel xlsx file type. There were no obvious errors while it read but when I inspected the result in Studio, two problems became apparent.
1) It only read in the column A while the text in columns B and greater was ignored.
2) It only read the first worksheet.
Am I missing something obvious here? I had a look at the settings but couldn't see anything related to the number of worksheets to load or columns to read.
Thanks
Dan
