Stack Trace " at Syncfusion.XlsIO.Implementation.FormulaParser.CreateLocalName(Int32 iRefIndex, String strToken, ParseParameters arguments, Hashtable indexes, Int32 i, ExcelParseFormulaOptions options)
at Syncfusion.XlsIO.Implementation.FormulaParser.CreateNamedRange(String strToken, ParseParameters arguments, Hashtable indexes, Int32 i, ExcelParseFormulaOptions options, Int32 iRefIndex)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseIdentifier(String identifier, Hashtable indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFirstOperand(Priority priority, Hashtable indexes, Int32 i, ExcelParseFormulaOptions& options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseExpression(Priority priority, Hashtable indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.Parse(String formula, Hashtable indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaUtil.ParseString(String strFormula, IWorksheet sheet, Hashtable hashWorksheetNames, Int32 iCellRow, Int32 iCellColumn, Boolean bR1C1)
at Syncfusion.XlsIO.Implementation.RangeImpl.SetFormula(String value, Hashtable hashWorksheetNames, Boolean bR1C1)
at Syncfusion.XlsIO.Implementation.RangeImpl.SetFormula(String value)
at Syncfusion.XlsIO.Implementation.RangeImpl.OnValueChanged(String old, String value)
at Syncfusion.XlsIO.Implementation.RangeImpl.set_Value(String value)
at Syncfusion.XlsIO.Implementation.RangeImpl.SetSingleCellValue2(Object value)
at Syncfusion.XlsIO.Implementation.RangeImpl.set_Value2(Object value)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ImportDataTableWithoutCheck(DataTable dataTable, Int32 firstRow, Int32 firstColumn, Int32 maxRows, Int32 maxColumns, DataColumn[] arrColumns)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ImportDataTable(DataTable dataTable, Boolean isFieldNameShown, Int32 firstRow, Int32 firstColumn, Int32 maxRows, Int32 maxColumns, DataColumn[] arrColumns, Boolean bPreserveTypes)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ImportDataTable(DataTable dataTable, Boolean isFieldNameShown, Int32 firstRow, Int32 firstColumn, Int32 maxRows, Int32 maxColumns)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ImportDataTable(DataTable dataTable, Boolean isFieldNameShown, Int32 firstRow, Int32 firstColumn)
at LRCDataController.ExportExcel() in D:\gaurav git working folder\leadresourcecenter\App_Code\LRCDataController.vb:line 452
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.<ExecuteAsync>b__4()
at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"
while exporting Datatable to excel file using ImportDataTable method of IWorksheet. I am tyring to export 50000 rows from datatable to excel file.
Below is my code.
Dim excelEngine = New ExcelEngine()
Dim application As IApplication = excelEngine.Excel
'application.DefaultVersion = ExcelVersion.Excel2007
Dim workbook As IWorkbook = application.Workbooks.Create(1)
Dim sheet As IWorksheet = workbook.Worksheets(0)
'Here i am getting error
sheet.ImportDataTable(dtExport, True, 1, 1)
Please help me out.