Using C# or VB.net to query 1 Excel Spreadsheet then Write result to another.
Posted on 2012-04-06
I really need to be able to read the data from three columns in one Excel Spreadsheet (c:\SpreadSheet_1.xls)
then create a New Spreadsheet (c:\SpreadSheet_2.xls) on the fly.
Then write the Spreadsheet 1 queried data ("select Row,Total,Difference from [Archive$]Where Total=104") to Spreadsheet 2
Please note , I'm using Visual Studios 2008 (not sure if that matters).
Thank you in advance for your help on this.
Please provide a full coded solution to this problem.