Sylvan.Data.Excel

Sylvan.Data.Excel copied to clipboard

MarkPflug

want to be able to set ExcelDataReader.SheetNames PUBLIC

4

For some usage scenarios, I want to be able to set the access scope for SheetInfo[] sheetNames in ExcelDataReader to public, Now I can only use the source code to...

lileyzhao

Ole2Package+Ole2Stream abruptly quits when reading an XLS from a FileStream in a Blazor Server app

3

I've a problem reading a particular, reasonably sized (700kb, 2600 rows) file in a Blazor server app. I've done various tests of changing the problem file and project type: *...

CaiusJard

Values of some columns will be lost in special cases.

3

Here is the sample code, using the file: [table1.xlsx](https://github.com/MarkPflug/Sylvan.Data.Excel/files/14805400/table1.xlsx) ``` { using ExcelDataReader edr = ExcelDataReader.Create("d://table1.xlsx", new ExcelDataReaderOptions { Schema = ExcelSchema.NoHeaders }); edr.NextResult(); edr.NextResult(); // to sheet3 edr.Read(); for...

lileyzhao

Using Excel library and Csv library to read .csv, .xls, and .xlsx files respectively, the experience is inconsistent, and there are even logic errors.

4

Using only a simple two-row, two-column table, create .xlsx, .xls, and .csv files. e.g. | name | age | | --- | --- | | nike | 18 | Here...

lileyzhao

Xlsb in MS Excel 2016

1

Hello, XLSB file created with dafault settiings cannot be sorted in Excel 2016.. (Excel crashes). ```c# using var edw = ExcelDataWriter.Create("fileSylvan.xlsb", new ExcelDataWriterOptions() { CompressionLevel = cLvl}); DbDataReader dr; dr...

KrzysztofDusko

Can't read xls file

3

Cannot read this file [link removed] which is totally fine and created by LibreOffice 7.2.5.2. IndexOutOfRangeExeption at Sylvan.Data.Excel.Ole2Package.NextSector(UInt32 sector) at Sylvan.Data.Excel.Ole2Package.d__36.MoveNext() at System.Linq.Buffer`1..ctor(IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at Sylvan.Data.Excel.Ole2Package.Ole2Entry.Open() at...

olekpa

Feature Request: Active Tab / Sheet Access in Sylvan.Data.Excel

2

**Issue Summary:** I would like to request the implementation of a feature that allows users to access the active tab or sheet in the "Sylvan.Data.Excel" library. Currently, there is no...

AbdulGafoor-inmar