Skip to content

A WPF application that bulk extracts data from a directory of XLSX files.

Notifications You must be signed in to change notification settings

CallumHoughton18/XLSXBulkDataExtractor

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

32 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

XLSXBulkDataExtractor

This is a WPF application built to demonstrate the data extraction capabilities of the XLSX Data Extractor library.

Build Status

The use case for this application is mass data extraction from a directory of XLSX reports, all within the same style. The application allows you to input data retrieval commands; specifying the data retrieval commands field name, column location, and row location. As shown below. The column location can also be specified as either an integer or as the Excel lettering system.

The application also supports different output formats, as shown below.

The extracted data can also be viewed in the application on the 'Data Viewer' tab. An example is shown below for a set of added extraction requests.

How To Install

  • Click on the green 'Clone or download' button on the GitHub repository page.
  • Click 'Download ZIP' and extracted the downloaded ZIP file.
  • Open the extracted folder and navigate to the sub directory 'desktop installer'
  • Run 'installer.exe', Click on the 'more info' link in the pop and click 'Run Anyway'
  • After installing, the XLSXBulkDataExtractor application should be added to your system.