What is CLISC

Introduction

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.

🏳️‍🌈 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 spreadsheet1 to .xlsx (Transitional conformance).

• Office Open XML (Excel) with extensions .xlsb, .xlsm, .xltm, .xltx and .xlsx with Strict conformance2
• Legacy Microsoft Excel with extensions .xls and .xlt
• OpenDocument with extensions .fods, .ods and .ots

🔍 Compare

Compare original and converted spreadsheets to log differences.3

• Cell values
• File size

🗄️ 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 spreadsheet1 to both .xlsx (Transitional conformance) and .ods
• Package spreadsheets and metadata in a new archive directory
• Output all conversions in subdirectories named n+1
• Rename all conversions n+1.xlsx and n+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)
• Remove formula linking cells to other local spreadsheets but keep snapshot of cell values (feature not working)
• Remove external data connections but keep snapshot of cell values (feature not working)
• Remove RealTimeData (RTD) functions but keep snapshot of cell values (feature not working)
• Alert if spreadsheet has embedded or external objects
• Calculate file checksums
• Zip the archive directory

Overview of CLISC methods