What is CLISC
Command Line Interface Spreadsheet Count Convert & Compare (& Archive)
A small Windows console application made in C#. It is a hobby project. The app might have use cases in digital archiving of spreadsheets. For graphical user interface, see child repository GUISC.
🏳️🌈 General
- Batch convert spreadsheets in a directory to .xlsx (Transitional conformance)
- Include or exclude subdirectories recursively
- Output results in a new directory with logs in CSV
➕ Count
Count number of spreadsheets in directory by file format.
- Accepted file extensions: .gsheet, .fods, .numbers, .ods, .ots, .xla, .xlam, .xls, .xlsb, .xlsm, .xlsx, .xlt, .xltm, .xltx
- .xlsx of Transitional and Strict conformance can be counted separately
🪄 Convert
Convert any spreadsheet to .xlsx (Transitional conformance).
- Office Open XML (Excel) with extensions .xlsb, .xlsm, .xltm, .xltx and .xlsx with Strict conformance
- Legacy Microsoft Excel with extensions .xls and .xlt
- OpenDocument with extensions .fods, .ods and .ots
🔍 Compare
Compare original and converted spreadsheets to log differences.
- Cell values
🗄️ Archive
The program can convert, package and describe spreadsheets to meet a data quality level, that will enable you to open your spreadsheets many years from now.
- Convert any spreadsheet to both .xlsx (Strict conformance) and .ods
- Package spreadsheets and metadata in a new archive directory
- Output all conversions in subdirectories named n+1
- Rename all conversions 1.xlsx and 1.ods
- Include copies of the original spreadsheets, this include password protected or otherwise unreadable files
- Validate spreadsheet against its file format standard (Office Open XML)
- Check if spreadsheet contains any sheets and any cell values
- Remove formula linking cells to other local spreadsheets but keep cell values
- Remove external data connections but keep cell values
- Remove RealTimeData (RTD) functions but keep cell values
- Remove printer settings (feature not working)
- Alert if spreadsheet has embedded or external objects
- Make first sheet the active sheet
- Calculate file checksums
- Zip the archive directory
