grate
grate copied to clipboard
pbnjay
A Go native tabular data extraction package. Currently supports .xls, .xlsx, .csv, .tsv formats.
Needs some backtracking in `makeFormatter`, currently "dddd" becomes "Sunday" but then "d" is applied to become "Sun11ay"
Opening any .xlsx file would result in an EOF error. Go version: **1.18** OS: Windows **10** MS Excel Used: **Microsoft Excel 2010**
The [xls standard](https://learn.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/04fa5340-122f-49db-93ea-00cc75501efc) allows to save a decimal number like 1.75 as an integer, multiplied by 100. The current implementation did neither detect this as an integer nor as a...
When creating a formatter with the format "hh:mm", then makeFormatters will not detect the "mm" as minutes, but as months, and will therefore create an incorrect output. For example, the...
It would be better to return the original cell value when apply date format fails, instead of returning error message. A XLS file is attached that would yield unwanted error...
unable to process password protected .xls file. How can we enhance the xls.go open function to pass password as params and use the same while reading data from workbook
Referring to the example file, the numbers are read as 0.00, and some are read as other incorrect numbers. thx [test.xls](https://github.com/pbnjay/grate/files/14953519/test.xls)
