.05 adding excel support

Revision 819 - (view) (annotate) - [select for diffs]
Modified Thu Jan 18 19:49:21 2024 UTC (2 years, 2 months ago) by nino.borges
File length: 9431 byte(s)
Diff to previous 818

Adding the previous batch coding support and solving around issues where there are characters missing in the previous live report that exist in the export files, making it so that there are missing matches.  This version fixes that.

Added code to mark the batch field as To Confirm UAT or To Confirm LanID.  This made the delivered the v3 report.

Revision 817 - (view) (annotate) - [select for diffs]
Modified Tue Jan 16 21:37:56 2024 UTC (2 years, 2 months ago) by nino.borges
File length: 5924 byte(s)
Diff to previous 816

This version added code to name the dated header columns correctly.  QCd this by selecting 5 rows at random and comparing them to Tom's table.

This program will open multiple xlsx files, using the Excel COM API, and will perform a simple combining of the data into a single xlsx report.  This version is the first delivered report.