The program converts any input spreadsheet file format to any output spreadsheet file format using Excel or LibreOffice in the background. If output file format is xlsx, the program can convert to meet archival data quality specifications. The program is intended for use in archival workflows.
- For more information, see repository CLISC
Excel can be used as conversion tool.
LibreOffice can be used as conversion tool.
ODS-ArchivalRequirements are used for policy compliance for ODS spreadsheets.
Download the executable version here. There's no need to install. In your terminal change directory to the folder where convert-spreadsheet.exe is. Then, to execute the program input:
.\convert-spreadsheet.exe --inputfilepath="[filepath]" --outputfileformat="[extension]"
Parameters
Required
--inputfilepath="[filepath]" // path to the file you want to convert
--outputfileformat="[extension]" // your output file format e.g. "ods", "xlsx", "xlsx-strict", "csv"
Optional
--outputfolder="[folder]" // your custom folder for output file, i.e. "C:\Users\%USERNAME%\Desktop"
--libreoffice // if you want to use LibreOffice as conversion tool instead of Excel
--policy // if you want to convert data to comply with regular archiving requirements
--policy-strict // if you want to convert data to comply with strict archiving requirements
--delete // if original file should be deleted
--rename="[filename]" // your custom filename e.g. "1".
Exit codes
The program writes information to the console and it also returns an exit code to integrate in workflows.
0 = File failed conversion
1 = File completed conversion
The following packages and software are used under license.
- LibreOffice, Mozilla Public License v2.0
- Magick.Net, Apache-2.0 license, copyright (c) Dirk Lemstra
- Microsoft Excel, Copyright (c) Microsoft Corporation
- ODS-ArchivalRequirements, MIT license, copyright (c) Asbjørn Skødt
- Open XML SDK, MIT License, Copyright (c) Microsoft Corporation