A Python macro for LibreOffice calc exporting all the sheets from a spreadsheet to CSV files UTF-8 encoded

README.md

Manual

This macro has to be installed in your personnal user macro in:

• ~/.config/libreoffice/4/user/Scripts/python/export_as_csvs.py on Linux
• \AppData\Roaming\LibreOffice\4\user\Scripts\python\export_as_csvs.py on Windows
• /Applications/LibreOffice.app/Contents/Resources/Scripts/python/export_as_csvs.py on MacOS (there may be a better alternative)

You can execute it from the menu Tools > Macros > Run macro... and then select My Macros > export_as_csv in the left column and export_sheets_to_csv in the right one and then click on Run.

export_as_csvs.py

import os
import unicodedata

from com.sun.star.beans import PropertyValue


def csv_properties():
    '''Build the dialog parameter for UTF-8 CSV'''
    props = []
    p = PropertyValue()
    p.Name = 'FilterName'
    p.Value = 'Text - txt - csv (StarCalc)'
    props.append(p)
    p = PropertyValue()
    p.Name = 'FilterOptions'
    p.Value = '59,34,76,1,,0,false,true,true,false'
    props.append(p)
    return tuple(props)


def export_sheets_to_csv():
    '''Iter over each sheet and save it as CSV file. '''
    desktop = XSCRIPTCONTEXT.getDesktop()  # noqa
    model = desktop.getCurrentComponent()
    controller = model.getCurrentController()
    dirname = os.path.dirname(model.URL)
    for sheet in model.Sheets:
        controller.setActiveSheet(sheet)
        name = sheet.getName().lower().replace(' ', '-')
        name = unicodedata.normalize('NFKD', name).encode('ascii', 'ignore')
        filename = '{0}/{1}.csv'.format(dirname, name.decode('ascii'))
        model.storeToURL(filename, csv_properties())

g_exportedScripts = export_sheets_to_csv,

Works beautifully on windows. How would I change the delimeter to be a comma instead of a semicolon?

EDIT: solved. Change 59 to 44