ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to extract data without opening Excel (https://www.excelbanter.com/excel-programming/383142-how-extract-data-without-opening-excel.html)

John

How to extract data without opening Excel
 
My XL spreadsheet has multiple pages. I need to be able to extract single
sheets as tab-delimited text withOUT opening excel. Typically this will be
done via command line in a linux env.

I believe this can be done, can anyone point me in the right direction

Thanks,

John

Tom Ogilvy

How to extract data without opening Excel
 
In case you don't get any better suggestions:

Why not have the data saved as CSV.

Beyond that, I believe there is support for ODBC in Unix

http://www.ozzu.com/ftopic69554.html
see last answer

or search google for ODBC UNIX EXCEL

--
Regards,
Tom Ogilvy


"John" wrote in message
...
My XL spreadsheet has multiple pages. I need to be able to extract single
sheets as tab-delimited text withOUT opening excel. Typically this will
be
done via command line in a linux env.

I believe this can be done, can anyone point me in the right direction

Thanks,

John





All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com