Thank you. I was able to implement starting from a different row, but it didnt work for different column. This is what i did, can you show me how to do it correctly? public static DataTable ReadExcelAsDataSet(string fileName, int table, int headerRowNumber, int startColumnNumber) { System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); using (var stream = File.Open(fileName, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { var config = new ExcelDataSetConfiguration() { ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration() { UseHeaderRow = true, ReadHeaderRow = (headerRowReader) => { // F.ex skip the first row and use the 2nd row as column headers: for (int i = 0; i < headerRowNumber; i++) { headerRowReader.Read(); } }, FilterRow = (rowReader) => { return rowReader.Depth > headerRowNumber - 1; }, FilterColumn = (columnReader, startColumnNumber) => { return columnReader.Depth > startColumnNumber - 1; }, } }; DataTable ds = reader.AsDataSet(config).Tables[table]; return ds; } } }

…

On Wed, Jul 17, 2024 at 9:52 PM Johan Appelgren ***@***.***> wrote: If you are using the reader interface then you just Read() until you get to your desired row. If you are using AsDataSet() then you need to provide a configuration that skips the 10 leading rows and 2 leading columns and the 12th row, see https://github.com/ExcelDataReader/ExcelDataReader?tab=readme-ov-file#asdataset-configuration-options . — Reply to this email directly, view it on GitHub <#676 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AF2M2RWXBXJIRF7CJCE747LZM24NDAVCNFSM6AAAAABK6JRNBGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMZUGAZDCOBYG4> . You are receiving this because you authored the thread.Message ID: ***@***.***>

How to read from specific column/row? #676

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions