Last post Jan 16, 2008 05:28 PM by abdulbq
Jan 14, 2008 04:00 AM|bslim67|LINK
From my understanding, my workbook had 3 worksheet in default.
But if the worksheet exceed 3, it will give me an error.
I am not sure of how to create a new worksheet
I have code it as
newWorksheet = (Excel._Worksheet)ExcelWorkbook.Sheets.Add(....)
Jan 14, 2008 04:06 AM|vijayvrr_2001|LINK
Can you try if the following works:
newWorksheet = (Excel.Worksheet)Globals.ThisWorkbook.Worksheets.Add(
missing, missing, missing, missing);
Pls refer to
http://msdn.microsoft.com/en-us/library/6fczc37s(VS.80).aspx for more information.
Hope that helps
Jan 16, 2008 05:28 PM|abdulbq|LINK
I have seen that using this method causes a bit delay as compared to the simple datagrid method and then posting html , using repsone.write.... How ever with this method one cannot create multi worksheets....