test_files

:books: SheetJS Test Files (XLS/XLSX/XLSB and other spreadsheet formats) (by SheetJS)

Test_files Alternatives

Similar projects and alternatives to test_files

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better test_files alternative or higher similarity.

test_files reviews and mentions

Posts with mentions or reviews of test_files. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-12-29.
  • Parsing an Undocumented File Format
    6 projects | news.ycombinator.com | 29 Dec 2023
    3) try to reproduce the artifacts with a NodeJS script.

    A simple `xlsx2csv` NodeJS script generates CSV text from a XLSX file, and a simple `diff` would reveal any deviations from the expected result.

    No one in the preceding 30 years thought to do the same! Many open source projects including OpenOffice/LibreOffice had huge collections of sample XLS and XLSX artifacts without accompanying plaintext artifacts.

    We wrote a series of scripts to automate Excel and generate the desired artifacts. https://github.com/SheetJS/test_files/blob/master/tests/txt.... is a AppleScript automation script for Excel 2011 for Mac.

    Those tests have revealed a number of unexpected bugs in third-party tools and regressions in Excel itself. For example, Excel 5.0 introduced the datetime format `yyyy-mm-dd [hh]:mm:ss`. The value 0.001 is expected to be rendered as "1900-01-00 00:01:26", and Excel 5.0 - 2003 worked as expected. Excel 2007 changed number formatting and newer versions show the nonsensical result "1900-01-00 645:01:26" (it is nonsensical since the value 0.001 represents less than one hour)

Stats

Basic test_files repo stats
1
165
10.0
over 1 year ago

SheetJS/test_files is an open source project licensed under Apache License 2.0 which is an OSI approved license.

The primary programming language of test_files is HTML.


Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com