Data-Extraction-with-Java

What this is - A Java application to read Excel data files & datatables embedded in Outlook emails. 3 main module(s):

• ExcelToCSV

• OutlookToCSV

• ZipToExcel

• Note: Bonus Module included to merge PDF Files

Sample datasets to test are included: data folder

Built with Java version 8 on Windows OS (application is platform independent)

External JAR libraries included

Filename	Functionality
ooxml-schemas-1.3.jar	Read & Write to Microsoft Documents
poi-ooxml-schemas-3.15	Read & Write to Microsoft Documents
poi-3.15	Read & Write to Microsoft Documents
xmlbeans-3.1.0	Read & Write to Microsoft Documents (parses XML)
commons-collections-3.2.2.jar	Dependency of poi libraries
commons-collections4-4.1.jar	Dependency of poi libraries
poi-scratchpad-3.15.jar	To Read Outlook Email Files
msgparser-1.1.15.jar	To Read Outlook Email Files
commons-logging-1.2.jar	Dependency of poi-scratchpad-3.15.jar library

Updated as of 29 Aug 2021

Part I Article at: https://towardsdatascience.com/extracting-data-from-excel-and-outlook-files-with-java-7979eb64edff

Part II Article at: https://towardsdatascience.com/heres-how-you-can-auto-adjust-your-datatable-range-in-excel-with-java-d00502d336d