Converting XLS to CSV from Ubuntu command line?

[z0mbi3]

Anyone got any advice on how I can do this? I have a report automatically saving as an xls daily, the nature of the reporting software means that I can't save it as anything other than xls. What I'm looking to do, via clever script or simple application, is convert said xls to a csv from the command line so it can be imported into a mysql database.

So anyone got any ideas? I've got an app called xls2csv but I can't get it to produce a file, regardless of what operators I use

 

[z0mbi3]

Heh quite the discussion I've started here .

I thought the obvious thing to do would be to use Excel under Windows to export particular worksheets as CSV using VBA. Using Linux to fix a Windows problem is just a retarded approach tbh.

Perhaps I could have been clearer in my original post but this wouldn't work. The reporting agent runs on a server that, aside from scheduling, I have no interaction with. So no running of VBA scripts against Excel. That said it's since come to light that the reporting software can produce a tab delimited text file. So I just need to brush up on mysql so I can import that from the command line.

Also I don't believe the open office solutions would have worked as I'm running Ubuntu server.