search

jferard / py4lo

Py4LO is a simple toolkit to help you write and include Python scripts in LibreOffice Calc spreadsheets.
GNU General Public License v3.0
5 stars 2 forks source link

Add CSV loader function #22

Closed jferard closed 3 years ago

jferard commented 5 years ago

Example:

... .loadComponentFromURL(uno.systemPathToFileUrl(csv_path), "_blank", 0, make_pvs({"FilterName":"Text - txt - csv (StarCalc)", "FilterOptions":filter_options(cols)})

STANDARD=1
TEXT=2
MDY=3
DMY=4
YMD=5
IGNORE=9
US=10 

UTF_8 = 76  
...

def filter_options(cols, dialect=csv.excel, encoding=UTF_8, first_line=1):
   return "{},{},{},{},{}".format(ord(dialect.delimiter), ord(dialect.quotechar), encoding, first_line, "/".join(str(c) for c in cols))
jferard commented 3 years ago

See 933f7f12c881c36f088817d5be862dcb04a81f06