Convert SpreadSheets to CSV files with Python and pyuno, Part 1v2

“The regular expression search checks to see if the input file
name can be broken into a file name part and a sheet name part. If
it can, and only if the original unbroken input file name does not
refer to an existing file, the pieces are used as the input file
and sheet specification. Checking to see if the original unbroken
input file name refers to an existing file allows you to specify
input files that have colons and at signs in their names, and it
continues to work even in the case where you have an input file
with a colon or at sign in its name and you want to extract a
particular sheet, for example:

$ python ssconverter.py this:month.xls:sales output.csv

“will correctly recognize that the sheet name is “sales” and
that the file name is “this:month.xls”. Since the regular
expression search is be default greedy the break will occur at the
last colon and since “this:month.xls:sales” does not refer to an
existing file the match will be used.”

Complete Story