#excel #git #markdown #ods #txt

app xl2txt

A tool to convert excel files into *.md *.vb files. Can be used for git difftools

2 releases

Uses old Rust 2015

0.1.1 May 8, 2017
0.1.0 May 5, 2017

#7 in #ods

MIT license

20KB
151 lines

Contains (Zip file, 20KB) tests/issues.xlsb

xl2txt

Convert Excel / OpenDocument SpreadSheets files into text files

xl2txt /my/excel/filename.xlsx

This command will per default create a /my/excel/.filename directory which contains:

  • data/sheet_name.md files for cells value. example
  • formula/sheet_name.md files for cells formula example
  • refs.md file for all references. example
  • names.md file for all defined names. example
  • vba/module_name.vb files for each module. example

Internally it relies heavily on calamine crate.

Supports all kind of excel files (xls, xlsx, xlsm, xlsb, xla, xlam) and ods files.

Dependencies

~10MB
~257K SLoC