Skip to content

Latest commit

 

History

History
34 lines (20 loc) · 2.18 KB

README.md

File metadata and controls

34 lines (20 loc) · 2.18 KB

XLSXDataExtractor

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

Build Status

To see an example of this library is used check out the XLSXBulkDataExtractor Desktop Application.

NuGets

Name Link
XLSX_Data_Extractor NuGet Link
XLSXDataExtractor.Common NuGet Link

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.