There is a newer version of the record available.

Published August 19, 2019 | Version v190820
Software Open

SchildCode/EpXL v190820

Authors/Creators

Description

Changes in this release

Solved 3 issues that were reported, together with other improvements:

  • Issue #1: EpXL can now store huge matrices (Matrix:TwoDimension object) containing more elements than the maximum number of columns in Excel (16384). Instead of storing each matrix element in separate spreadsheet cell, each spreadsheet cell now stores a whole matrix row as a string of semicolon-separated values in row-major order. Thus a 1010 matrix is stored in 10 spreadsheet cells, and EpXL can hypothetically store matrices up to a maximum of 16384 rows 16384 columns (assuming single digit elements, as a spreadsheet cell can store string of maximum 32768 characters).
  • Issue #2: More robust epJSON export for objects with extended groups.
  • Issue with slow epJSON export: Is now much faster, and memory overhead is reduced.
  • Smarter algorithm that automatically corrects for incorrect choices, such as 'Autosize' vs 'Autocalculate'
  • More robust import of dates: Date strings are now stored unchanged as a string in the input spreadsheet, not converted to Excel dates.
  • Minor improvements to epJSON schema import.
How to download
  • To download just the EpXL spreadsheet file (not the readme etc.), go to the main GitHub page for EpXL (https://github.com/SchildCode/EpXL), click on the file EpXL_vXXXXX.xlsb, and click download.

Files

SchildCode/EpXL-v190820.zip

Files (1.5 MB)

Name Size Download all
md5:02fbdb15bff672fc0e05de3386987358
1.5 MB Preview Download

Additional details

Related works