The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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
