We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Again psting : Problem In a template file

Thread ID:

Created:

Updated:

Platform:

Replies:

23356 Jan 11,2005 03:43 AM UTC Jan 11,2005 08:51 AM UTC WinForms 1
loading
Tags: XlsIO
Mohammad Abdullah
Asked On January 11, 2005 03:43 AM UTC

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

Mohammad Abdullah
Replied On 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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;