andersnm
andersnm
Hi and thank you! Unfortunately I believe this is a problematic change. In particular because of Mono, which apparently has slight differences in its DataSet implementation from the "official" ones....
Some kind of new `ExcelDataTableConfiguration.TransformValue(reader, columnIndex)` callback could be a flexible way to handle this and other scenarios. F.ex I had a use case where I wanted to apply formatting...
Hi, This looks to be the same as #432. And a fix seems to include converting from the .NET style `CultureInfo.DateTimeFormat.ShortDatePattern` into Excel style number formats. Thanks for digging that...
@SpiritBob Alas no estimates, probably not anytime soon. Maybe you can use `GetNumberFormatIndex()` and a switch to determine if dates should be formatted using a "culture-dependant" format, and in that...
@SpiritBob A subset of the built-in number formats in Excel are different depending on the culture. You can usually determine if a number format is built-in from `GetNumberFormatIndex()`, if its...
Hi, Thanks, but this will require some changes to be accepted. The code adds an overload of the CreateOpenXmlReader factory method which returns only the creator field. This does not...
Hi, This is sort of by design. The Excel file formats are designed in a way that seeking is required to parse them. See f.ex comment in https://github.com/ExcelDataReader/ExcelDataReader/issues/17#issuecomment-308862570 The easiest...
Hi, Am I assuming correctly if you've got a cell with rich text, like for example "See footnote [1]", and ExcelDataReader returns this as "See footnote[1]" and you want to...
Hi, ExcelDataReader is not using DOM. And indeed, only one row is loaded in the memory at once (with some exceptions). You're not measuring memory usage after calling AsDataSet()? 16x...
Can you also (rename the xlsx to zip and) unzip the XLSX and let us know the size of `xl/sharedStrings.xml` from inside the zip? XlsxSST is the "Shared String Table",...