Re: How to read xlsx files in Euphoria
- Posted by EUWX Sep 05, 2013
- 2524 views
What are my options for reading data from an excel file into a Euphoria program?
regards, Spock
I use OpenOffice 4.0 (a free software) to open the XLS or XLSX file and save it as CSV.
I can then use the CSV file easily in many development level languages.
Euphoria has csv.zip and I am sure other development tools to read write CSV files, and extract/manipulate data.
There are also many other tools (some free) available to convert Excel files to different text formats.
I have used the "save as DBF" facility of OpenOffice and Excel to save files as DBF and then use DBF software to modify or extract useful data.
Euphoria's DBF system does exist but it is at a very simple level and there are not many functions.
You can use Harbour (a free software) to maniputlate the DBF file and sore it as DBF, CSV, XLS, etc.
Alternatively you can use Euphoria's facilities to convert to EDS database.
There is also EDS tool box "edstb13.zip", a year 2000 effort in Euphoria, which may need some modification to read write XLS files now under Euphoria 4, and certainly will not handle XLSX files.
Again you can use OpenOffice 4.0 to read XLSX file, save it as XLS and hopefully use this tool box with minor modifications.
In conclusion, although Euphoria may not have a directly usable software to manipulate XLSX files, there are easy ways to enable you to use Excel file with Euphoria.
