Hi all,
I am facing an error while trying to read an excel report downloaded from SAP having 71 Columns using Workbook Read Range.
Source: Read Range
Error Message: Row number must be between 1 and 1048576
Exception Type: System.IndexOutOfRangeException
An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.IndexOutOfRangeException: Row number must be between 1 and 1048576
at ClosedXML.Excel.XLWorksheet.Row(Int32 row, Boolean pingCells) in C:\Projects\ClosedXML\ClosedXML\Excel\XLWorksheet.cs:line 1368
at ClosedXML.Excel.XLWorkbook.LoadRows(Stylesheet s, NumberingFormats numberingFormats, Fills fills, Borders borders, Fonts fonts, XLWorksheet ws, SharedStringItem sharedStrings, Dictionary2 sharedFormulasR1C1, Dictionary
2 styleList, Row row) in C:\Projects\ClosedXML\ClosedXML\Excel\XLWorkbook_Load.cs:line 1329
at ClosedXML.Excel.XLWorkbook.LoadSpreadsheetDocument(SpreadsheetDocument dSpreadsheet) in C:\Projects\ClosedXML\ClosedXML\Excel\XLWorkbook_Load.cs:line 227
at ClosedXML.Excel.XLWorkbook.LoadSheets(String fileName) in C:\Projects\ClosedXML\ClosedXML\Excel\XLWorkbook_Load.cs:line 45
at UiPath.Excel.WorkbookFile…ctor(String workbookPath, String password, Boolean createNew)
at UiPath.Excel.Activities.WorkbookActivity1.ConstructWorkbook(String path, String password, Boolean createNew) at UiPath.Excel.Activities.WorkbookActivity
1.BeginExecute(AsyncCodeActivityContext context, AsyncCallback callback, Object state)
at System.Activities.AsyncCodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
![ReadRangeError|690x245]![ReadRangeError|690x245]
If anyone has found any solution for this error, Please share in it comments.
I want to use only workbook read range.
Regards,
Satya.