New Simple Windows Form to Extract Data from EXCEL Documents

This is a simple windows form C# project that I need very quickly. This project is to extract data from a number of EXCEL documents that are all formatted the same and write the extracted data to an output file.

Here are the Requirements:

[url removed, login to view] be a windows form application written in C#

[url removed, login to view] will contain a control for the user to specify the directoty folder containing all the EXCEL files. There could be as many as 5,000 EXCEL files all

formatted the same. Will also need a button to execute.

3. Window form will read in a mapping file that contains the CELL location from the inbound for all data that needs to be extracted.

[url removed, login to view] form will then read in all EXCEL files within the directory

[url removed, login to view] form will copy each completed EXCEL file to a COMPLETED folder.

[url removed, login to view] form will parse data from each EXCEL document and then place the data into a output record using the mapping record. There should be one record created for each EXCEL file imported.

[url removed, login to view] form will generate one EXCEL output file containing one row of data for each EXCEL file

[url removed, login to view] form will display the number of EXCEL documents processed when finished.

9. Must support EXCEL 2007 and above.

I attached a sample import file and a partially completed mapping file which I will have finished today. Provided below are more details on how to write this program. This should be a very simple program for any experienced C# developer to write.

1. Logic to get the directory file path from specified by the user. The windows form will contain a window where the user can select the directory

path containing all the EXCEL spreadsheets.

2. Logic to open the mapping the file which will be provided in the same directory file path called “Mapping File”.

3. Logic to parse Label cell location and Data cell location from the mapping file which starts in cell C. The label cell location is in the 1st record.

The label name and cell location are separated by a | from the label. For example Polyunsaturated Fat|A19. The cell location for the data is located on

the 2nd record.

4. Logic to import each EXCEL document until all EXCEL files have been processed

5. Logic to open each EXCEL Document and do the following:

a. Create a record in the outbound mapping file and update COLA with name of the EXCEL file. There will be one record for each EXCEL file

processed.

b. Determine if format is correct by matching the column label names from output mapping attachment to the imported EXCEL spreadsheet

i. For each column in the mapping file, locate the corresponding label in the inputted EXCEL file.

1. If labels do not match,

a. Update Status in COLB on the outbound mapping file to “Fail”

b. Update the data CELL on the outbound mapping for the corresponding label “Fail”.

2. If labels match,

a. Get the value for the label and update the data CELL on the outbound mapping for the corresponding label.

b. Update Status COLB on the outbound mapping file to “Pass”

ii. When all columns have been processed for the Inbound EXCEL

1. If the status is fail, then Move the file to a new directory called completed-failed. If the directory folder does not exist create it.

2. If the status is pass, then Move the file to a new directory called completed-passed. If the directory folder does not exist create it.

3. Read in the next EXCEL file.

6. End of processing logic:

a. When all EXCEL files have been processed display the following results:

Number of EXCEL documents that passed

Number of EXCEL documents that failed

Total number of EXCEL documents processed

Total number of conversion record written to outbound file

.NET C# Programming

Project ID: #4600984

About the project