Again psting : Problem In a template file

Hi , I write the following code to set the file as template : ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; IWorkbook myWorkbook = ExcelUtils.CreateWorkBookUsingTemplate (Application.StartupPath + @"\\repCpxFormat.xls"); IWorksheet SheetAll = myWorkbook.Worksheets[0]; IWorksheet SheetInfo = myWorkbook.Worksheets[1]; IWorksheet SheetBuild = myWorkbook.Worksheets[2]; It gives me the following error on the line that said (ExcelUtils.CreateWorkBookUsingTemplate...etc): ---- system.argumentoutofrangeexception , The specified argument was out of valid values parameter name reading order. --- Please Note: 1-I''''m sure about the file name and the location available at the application path. 2-The number of worksheets is 3. The strange thing that I did the same code with another Excel files in another part of the application without any error problems and here is an examples (Error free) : ----- ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; //A new workbook is created.[Equivalent to creating a new workbook in MS Excel] // The number of default worksheets is the IWorkbook myWorkbook=ExcelUtils.CreateWorkBookUsingTemplate (Application.StartupPath + @"\\repbldgFormat.xls"); //The first worksheet object in the worksheets collection is accessed. IWorksheet SheetAll = myWorkbook.Worksheets[0]; IWorksheet SheetInfo = myWorkbook.Worksheets[1]; --- ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; //A new workbook is created.[Equivalent to creating a new workbook in MS Excel] // The number of default worksheets is the application setting in MS Excel. IWorkbook myWorkbook = ExcelUtils.CreateWorkBookUsingTemplate (Application.StartupPath + @"\\reptDepFormat.xls"); /The first worksheet object in the worksheets collection is accessed. IWorksheet SheetAll = myWorkbook.Worksheets[0]; IWorksheet SheetInfo = myWorkbook.Worksheets[1]; Thank you

1 Reply

MA Mohammad Abdullah January 11, 2005 08:51 AM UTC

Attache A bit map image represents the message title inside a zipped file. The Excelrw version is : 2.1.0.9 Thanks. problem of Excelrw_8237.zip

Loader.
Up arrow icon