search

data4development / iati-workbench

Create IATI data files from a mix of spreadsheets and IATI input files.
https://developer.data4development.nl/iati-workbench/
GNU Affero General Public License v3.0
0 stars 1 forks source link

Convert spreadsheets with multiple sheets #33

Open rolfkleef opened 3 years ago

rolfkleef commented 3 years ago

Sightsavers has some spreadsheet files with multiple sheets (budgets for different years).

With a different conversion routine, it's possible to export all sheets in a file.

Current version: all files MUST have the same column layout, otherwise it won't work.

Explore alternative version to export each sheet into its own file for further processing: that would also make it possible to have a single spreadsheet with different sheets for the different bits of information.

rolfkleef commented 3 years ago

csvkit’s in2csv doesn’t seem to produce output

gnumeric’s ssconvert generates filenames ending in numerical extension

xlsx2csv seems to work easiest for now:

./xlsx2csv.py -a -i -f '%d-%m-%Y' Budgets_Sightsavers.xlsx .

manual conversion right now, need to find a way to integrate into the workbench (python dependency, might be included with headless libreoffice already)