xlsx to xls

proNick · 07-09-2008, 08:38 AM

hi all!

can you help me to find some tool, that will convert xlsx file to xls? its all about microsoft excel file format.

thank you in advance!

pwc101 · 07-09-2008, 08:46 AM

Perhaps Google is your friend?

http://www.oooninja.com/2008/01/conv...nux-using.html or http://www.zamzar.com/?

nx5000 · 07-09-2008, 09:45 AM

Did you try a very recent OpenOffice version?

proNick · 07-09-2008, 10:07 AM

right, but in that case i can convert xlsx to ods.

but i need xls format, not ods...

and i need it all in shell, because it will be part of system i developed earlier.

amani · 07-09-2008, 10:30 AM

proNick, there are many xls options in openoffice

M$...XP
95, 97

See file --> save as --> change format in the resulting dialog

nx5000 · 07-09-2008, 10:31 AM

Hum I though OO can save as xls? Did you check?

Then for scripting you can look at this:
http://www.oooninja.com/2008/02/batc...sion-with.html
http://www.artofsolving.com/files/DocumentConverter.py

I search for these terms in google:
openoffice automation from bash

general_koffi · 07-09-2008, 10:37 AM

OO can open and save .xls (the old MS Office spreadsheet), but not .xlsx.

MS fail at life. I swear the only reason they invented these new formats is to screw OO.

proNick · 07-09-2008, 10:47 AM

wait, wait, wait...

i have to do it all in linux shell, no way i can open file on OpenOffice, and then save it in some format.

the point is that i have to convert XLS file to XML. for that i used xmllint (http://xmlsoft.org/xmllint.html). great tool.

but now, i have to be able to do the same with XLSX files. my idea was to convert XLSX to XLS, and then to continue by using xmllint. that's why i asked about whole thing. so, no way i can use OO directly, then open and save as... file.

proNick · 07-10-2008, 06:50 AM

any kind of help?

pwc101 · 07-10-2008, 06:55 AM

Perhaps this thread will point you down the right road?

http://www.oooforum.org/forum/viewtopic.phtml?t=54301

dodgyboat · 12-14-2008, 12:09 AM

I came across this site called sheetconvert.com to convert .xlsx to .xls online for free. Works fine for me. Worth a try

arunmathew1984 · 12-14-2008, 01:01 AM

Have you tried using MS Excel 2007 itself. You can always do a Save As .xls after opening the .xlsx file in it.

Linux Archive

dodgyboat · 12-15-2008, 12:53 AM

True, But my office PC's are installed with 2003 so I have to reply on a online option to convert the files which our clients send.