Hi,
while opening the excel from the code
application.Workbooks.OpenReadOnly
we got the below message
Message : ErrorMessage :Specified argument was out of the range of valid values.
Parameter name: firstRow or lastRow
StackTrace : at Syncfusion.XlsIO.Implementation.RangeImpl..ctor(IApplication application, Object parent, Int32 firstCol, Int32 firstRow, Int32 lastCol, Int32 lastRow)
at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateRange(Object parent, Int32 firstCol, Int32 firstRow, Int32 lastCol, Int32 lastRow)
at Syncfusion.XlsIO.Implementation.RangeImpl.get_Item(Int32 row, Int32 column, Int32 lastRow, Int32 lastColumn)
at Syncfusion.XlsIO.Implementation.HyperLinkImpl.get_Range()
at Syncfusion.XlsIO.Implementation.HyperLinkImpl.get_TextToDisplay()
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseHyperlink(XmlReader reader, WorksheetImpl sheet, HyperLinksCollection hyperlinks, RelationCollection relations)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseHyperlinks(XmlReader reader, WorksheetImpl sheet)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseAfterSheetData(XmlReader reader, WorksheetImpl sheet, MemoryStream& streamCF, String strParentPath, Dictionary`2 dictItemsToRemove)
Regards,
Harish Chepuri