Hey,
First, sorry if this has been asked already, but the topic names are not very descriptive when searching.
I am trying to find a way to take a csv file, am bring it into an excel workbook, overwriting a specific worksheet. For instance, the work book has worksheets called: “comp”, “data”, “report1”, “report2”
The csv file has all the information that I want to be on the “data” worksheet. Is there a way to (automatically via script) just make the csv file’s data go into the data worksheet.
The process would be
1. Using the web interface (written in asp.net (C#)), query the database (oracle) to spit out the csv file into some directory where the xls file is.
2. Run some script (which I’m trying to figure out how to do ;p) which will take the csv file’s information and drop it into the “data” worksheet which will update the reports.
3. Save just the report page (finalized — whatever the formula in the cell calculated) and display that to the user without the other worksheets.
Thanks!
Mike