Forum Discussion
rraghvani
12 months agoChampion Level 3
Your spreadsheet uses Custom XML formatting, and using Excel.Open() method will not read the data correctly, as it's used for older spreadsheets i.e. .xls files. However, you can use the Excel COM server Excel.Application to correctly read the data instead as shown below.
Related Content
Recent Discussions
- 4 hours agoJacobjacob44