Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading XLSX file without office
Message
From
22/09/2021 01:55:34
 
 
To
21/09/2021 14:14:54
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01682323
Message ID:
01682335
Views:
62
>>Hi, I was looking for a way to read an XLSX file, but without having office installed. I looked at the library of Greg Green, which I also use for exporting a cursor to XLSX, but I did not find a way for vice versa. I tried the method OpenXLSXWorkbook, but all created cursors are empty. So not sure if there is a way to accomplish this, or there is another solution?
>
>For XLSXWorkbook the format of the XLS must be rather simple - basically just the data. Have you tried to create a XLSX with XLSXWorkbook and open itlater, so you get an idea what the XLSXWorkbook can do? [...]

I expected this already, but got sidetracked by the complexity of OpenXLSXWorkbook. Since it creates all the cursors already, I thought it did not work, because they showed just empty. But thanks to Al I know that I need to get the sheet in the next step, so will check that out. Although Marcos suggestion might be more appropriate for this task.
Christian Isberner
Software Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform