XLSX_Data_Extractor 1.1.0

An extension library for ClosedXML to allow for quick and easy bulk data extraction from Excel Workbooks into various formats.

There is a newer version of this package available.
See the version list below for details.
Install-Package XLSX_Data_Extractor -Version 1.1.0
dotnet add package XLSX_Data_Extractor --version 1.1.0
<PackageReference Include="XLSX_Data_Extractor" Version="1.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add XLSX_Data_Extractor --version 1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

XLSXDataExtractor

An extension library for ClosedXML to allow for quick and easy bulk data extraction from Excel Workbooks into various formats.

Build Status

What's Included?

Two components are included. The DataExtractor class which is used to extract data out from Worksheets of a loaded Workbook, and the ExtractedDataConverter static class which is used to convert the extracted data into various formats, such as a CSV or XLSX document.

DataExtractor Usage

The DataExtractor contains multiple overloads for single data extraction using the worksheets known name, column, and row of the data. Or, an ExtractionRequest object can be passed to it containing the same information. For bulk data extraction a collection of ExtractionRequest objects can be passed to it, an example of this is shown below.

DataExtractor dataExtractor = new DataExtractor(Path.Combine(executingAssemblyPath, "Files", "IntegrationTestExample.xlsx"));

var extractionRequests = new List<ExtractionRequest>() { new ExtractionRequest("SalesRep", 2, 3), new ExtractionRequest("SalesRepID", 2, 2) };

var extracted = dataExtractor.RetrieveDataCollectionFromAllWorksheets<object>(extractionRequests);

ExtractedDataConverter Usage

This is a static class than converts a two dimensional collection of the KeyValuePair objects produced from the various extraction methods into a string of CSV text or a IXLWorksheet to be used with the ClosedXML library.

XLSXDataExtractor

An extension library for ClosedXML to allow for quick and easy bulk data extraction from Excel Workbooks into various formats.

Build Status

What's Included?

Two components are included. The DataExtractor class which is used to extract data out from Worksheets of a loaded Workbook, and the ExtractedDataConverter static class which is used to convert the extracted data into various formats, such as a CSV or XLSX document.

DataExtractor Usage

The DataExtractor contains multiple overloads for single data extraction using the worksheets known name, column, and row of the data. Or, an ExtractionRequest object can be passed to it containing the same information. For bulk data extraction a collection of ExtractionRequest objects can be passed to it, an example of this is shown below.

DataExtractor dataExtractor = new DataExtractor(Path.Combine(executingAssemblyPath, "Files", "IntegrationTestExample.xlsx"));

var extractionRequests = new List<ExtractionRequest>() { new ExtractionRequest("SalesRep", 2, 3), new ExtractionRequest("SalesRepID", 2, 2) };

var extracted = dataExtractor.RetrieveDataCollectionFromAllWorksheets<object>(extractionRequests);

ExtractedDataConverter Usage

This is a static class than converts a two dimensional collection of the KeyValuePair objects produced from the various extraction methods into a string of CSV text or a IXLWorksheet to be used with the ClosedXML library.

Release Notes

Added functionality to generate DataTable object from extracted data.
Added functionality to ExtractedDataConverter class to generate a CSV or Worksheet from a given DataTable object.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.2.0 44 9/27/2019
1.1.0 109 5/23/2019
1.0.0 86 5/11/2019