-
December 21st, 2012, 07:18 AM
#1
C# to Create Excel Workbook
In C# how would I add an Excel Workbook, and explicitly name the worksheet that is added to the workbook?
Last edited by jo15765; December 21st, 2012 at 08:07 AM.
-
December 22nd, 2012, 12:50 PM
#2
Re: SaveAs For C#
Well I answered my own question after HOURS of googling --- thanks to all who viewed my beginner question
Here is the solution I used...
Code:
Excel.Application myApp;
Excel.Workbook myWorkBk;
object missingValue = System.Reflection.Missing.Value;
myApp = new Excel.Application;
myApp.Visible = true;
myWorkBk = myApp.WOrkbooks.Add(missingValue);
myWorkBk.SaveAs(@"C:\Try\TestData\Heythere.xls");
myWorkBK.Close();
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|