Skip to content

A light weight data extraction library built on top of ClosedXML for data extraction in Excel files.

Notifications You must be signed in to change notification settings

CallumHoughton18/XLSXDataExtractor

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

A light weight data extraction library built on top of ClosedXML for data extraction in Excel files.

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages