Repository files navigation

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 meetarchival data quality specifications. The program is intended for use in archival workflows.

• For more information, see repositoryCLISC

⚠️Microsoft Excel

Excel can be used as conversion tool.

⚠️LibreOffice

LibreOffice can be used as conversion tool.

⚠️ODS-ArchivalRequirements

ODS-ArchivalRequirements are used for policy compliance for ODS spreadsheets.

Download the executable versionhere. 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 conversion1 = File completed conversion

The following packages and software are used under license.

• .Net 9, copyright (c) Microsoft Corporation
• 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