Chris Edwards
Reputation: 484
How can I convert an Excel file on a Linux server to a delimited text file?
I am running a Linux server and one of our suppliers only knows how to send me an Excel file which I need to import into our system daily. Does anyone know of a good way to export the Excel file to a delimited file? Preferably with php or perl.
Thanks!
Chris Edwards
Upvotes: 2
Views: 1717
Answers (2)
wallyk
Reputation: 57784
OpenOffice (or LibreOffice) has a scripting ability, alas, which I have never looked at. However, it seems it would be straightforward to open the Excel file using Calc, and then do a Save As .csv operation.
Upvotes: 1
Related Questions
- Convert xlsx to csv in Linux with command line
- Convert csv to excel worksheet with filters in linux
- Convert XLSB files to csv in Linux on command line
- Automatically convert csv file into Excel table?
- convert .csv to a .xlsx from CLI
- Convert ctrl A delimited file to csv
- How to convert xlsx file to csv file using shell script?
- converting an Excel (xls) file to a comma separated (csv) file without the GUI
- CSV to XLS linux script
- Export from Excel to text file without line breaks