Hello,
I have a C# application that creates a tab Delimited flat file. Once completed the user opens the file using Excel.
We have a second excel workbook with a bunch of macros for generating charts and graphs based on the data from the program. We cut and past the tab delimited data from one excel sheet into the data sheet of the of the macro workbook.
I would like to use the c# program to load the tab delimited file directly to the data sheet of the excel workbook.
I've written the code to open the workbook, select the data sheet and clear the previous runs data. I'm just not sure how to import that data to the specific sheet.
Any help is greatly appreciated.
Thanks,
John