mdbtools
test_files
| mdbtools | test_files | |
|---|---|---|
| 2 | 1 | |
| 955 | 165 | |
| 1.0% | 0.0% | |
| 5.2 | 10.0 | |
| about 2 months ago | over 1 year ago | |
| C | HTML | |
| GNU General Public License v3.0 only | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
mdbtools
- Parsing an Undocumented File Format
-
Databases
shoutout to mdbtools for when I've actually had to do this shit
test_files
-
Parsing an Undocumented File Format
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)
What are some alternatives?
Excelerator - This is an Excel Addin for Windows that reads and writes data to Snowflake
ImHex - 🔍 A Hex Editor for Reverse Engineers, Programmers and people who value their retinas when working at 3 AM.
msaccess-vcs-addin - Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.
byter - Python binary object reader/writer
FreeSql - 🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.