JdeJabali.JXLDataTableExtractor 1.0.3

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. 
dotnet add package JdeJabali.JXLDataTableExtractor --version 1.0.3
                    


                    

                
NuGet\Install-Package JdeJabali.JXLDataTableExtractor -Version 1.0.3
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="JdeJabali.JXLDataTableExtractor" Version="1.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="JdeJabali.JXLDataTableExtractor" Version="1.0.3" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="JdeJabali.JXLDataTableExtractor" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add JdeJabali.JXLDataTableExtractor --version 1.0.3
                    


                    

                
#r "nuget: JdeJabali.JXLDataTableExtractor, 1.0.3"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package JdeJabali.JXLDataTableExtractor@1.0.3
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=JdeJabali.JXLDataTableExtractor&version=1.0.3
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=JdeJabali.JXLDataTableExtractor&version=1.0.3
                    


                            Install as a Cake Tool

JdeJabali.JXLDataTableExtractor

MIT License GitHub Workflow Status (with event) Nuget

  • Extract data as tables or rows from Excel.
  • Search columns by their header or index number.
  • Sets conditions for extracting the rows.
  • Read one or many workbooks.
  • Select what worksheets should be read, by index number or name.
  • Get the result in a DataTable or in a collection of rows.

Demo

string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
string subFolderPath = Path.Combine(path, "Daily store sales");
string[] workbooks = Directory.GetFiles(subFolderPath, "*.xls");

DataTable dataTable = DataTableExtractor
    .Configure()
    .Workbooks(workbooks)
    .SearchLimits(searchLimitRow: 10, searchLimitColumn: 30)
    .Worksheet(worksheetIndex: 0) // Worksheet indexes in Excel are 0-based.
    .ReadOnlyTheIndicatedSheets()
    .ColumnHeader("Description")
    .ColumnHeader("Sales Value")
    .ColumnHeader("Discounts")

    .ColumnHeader("VAT")
        .ConditionToExtractRow(ConditionalsToExtractRow.HasNumericValueAboveZero)
        
    .ColumnIndex(columnIndex: 7) // Column indexes in Excel are 1-based.

    .CustomColumnHeaderMatch(cellValue => cellValue.Contains("Total"))
        .ConditionToExtractRow(cellValue => !string.IsNullOrEmpty(cellValue))
    .GetDataTable();

Documentation

This line

.SearchLimits(searchLimitRow: 10, searchLimitColumn: 30)

applies to all the worksheets to read.

To read each worksheet in each workbook, simply change this line

.ReadOnlyTheIndicatedSheets()

to this

.ReadAllWorksheets()

If after this line for example

.ColumnHeader("Description")

this other line is not specified

.ConditionToExtractRow(condition)

then the row will always be extracted (although for that all other conditions must be met).

You may want to get a collection of rows instead of a DataTable, for that, change

.GetDataTable();

with

.GetExtractedRows();

at the end.

If you need more details about the rows, for example which workbook or sheet they were extracted from, then you might want to use this line at the end.

.GetWorkbooksData();

That's all

Feedback

If you have any feedback, please reach out to me at jdejabali@outlook.com

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.0.3 46 9/11/2026
1.0.2 42 9/10/2026
1.0.1 385 9/9/2023
1.0.0 312 5/23/2023

- When the headers to look for are not all in one row, HeadersNotMatchingSameRowException is thrown. Its message names the workbook and the worksheet and says where each header was found, or that it was not found within the search limits.
- It derives from InvalidOperationException, which is what this error was thrown as up to 1.0.2, so existing catch blocks keep working.
- Reading a worksheet by name no longer replaces that message with a generic one.
- Each worksheet looks for its headers from scratch. Until 1.0.2, when a header was missing from a later worksheet, that worksheet was read at the column the header had in the previous one, returning the wrong data without any error; now the missing header is reported.
- A header that is not found is reported even when it is the only one; until 1.0.2 its worksheet was read anyway.
- CustomColumnHeaderMatch runs its condition in every worksheet. Until 1.0.2 the header text it matched in the first worksheet replaced the condition, so later worksheets, and later reads with the same configuration, only found that exact text. The column keeps the name of the first header matched, so every worksheet's values come out under the same name, as before.