andersnm

@rstm-sf Thanks, but alas the tests depend on run order. The tests run alphabetically and fail if you rename them to f.ex TestA and TestB

Hi @eJJonatah, can you share a file having this problem? (If not, and its xlsx, can you unzip it and paste some examples what those dates look like in the...

@eJJonatah It might be premature to close this. If the original file opens correctly in Excel, then one could argue it should read in ExcelDataReader too. The key facts so...

Well wouldn't you know. Here's the code that parses the 1904 flag: https://github.com/ExcelDataReader/ExcelDataReader/blob/2dc4c7ef261192c37e9b33eec7cb7f9f6e6d9851/src/ExcelDataReader/Core/OpenXmlFormat/XmlFormat/XmlWorkbookReader.cs#L46-L47 vs the code that generates the 1904 flag: https://github.com/sokolsaiti/as_xlsx/blob/f268ec3bce9cd44aac600c6f183fc9bc4568fdbb/as_xlsx.sql#L1742 ```xml ``` Took a while to notice, but...

A PR for this is welcome :) It'd be good to craft a couple .xlsx with different values for date1904 and reverse more precisely how Excel interprets the value, f.ex...

It's not supported at the moment. Never used this feature before, it appears you can find it under Data -> Group, and the XLSX and XLS specs refers to these...

Hi, alas there is no way to configure the quote char in ExcelDataReader currently.

Hi, `reader.GetColumnWidth()` returns the width of a column in character units. May be 0 if the column is hidden.

Hi @FreeVB! The AsDataSet configuration object supports skipping columns using `FilterColumn` and skipping rows in two different ways using `ReadHeaderRow` and `FilterRow`. Please check the documentation at https://github.com/ExcelDataReader/ExcelDataReader for more...

Hi @FreeVB, Sounds like you need to do some heuristics on the data to determine the actual extents. This is specialized to your situation, unfortunately I cannot provide general programming...