How can I bypass the import dialog when opening CSV with OpenOffice?

Question

A (Python, but that's not really relevant) script I'm writing will issue a command line call to open a CSV file with OpenOffice (OO). I need OO to skip over the import dialog box while opening the script, or to tell OO that the defaults from that box are okay and thus the dialog is not needed.

Googling this has shown me stuff about setting up macros or a registered data source. Both of these seem to be overkill and are things I am clueless about.

Is there a command line option to tell OO to skip the dialog or use the defaults? Or some other simple way to accomplish what I need?

Answer 1

Perhaps if your Python script converted the CSV to another simple format (such as DIF) OpenOffice Calc would open it without needing a dialogue to confirm delimiters, column locations and column formats.

Update:

• DIF doesn't work as OO asks what character encoding to use.
• HTML doesn't work as OO asks what language to use.
• SYLK works well

I used start run "D:\Apps\OpenOffice.org 3\program\scalc.exe" -calc d:\temp\table.slk to load this file

ID;P
C;Y1;X1;K"Row 1"
C;Y2;X1;K"Row 2"
C;Y3;X1;K"Total"
C;Y1;X2;K11
C;Y2;X2;K22
C;Y3;X2;K0;ER1C2+R2C2
E

With some effort your Python script can convert CSV files to temporary SYLK files on the fly.