We are in a process of converting Interop.Excel to Aspose.Cells . Request your help on how to find Last Cell address with data in a given row using Aspose.Cell. We are using Aspose.Cells 22.214.171.124 for .NET
Following is the old code using Interop. Requires the corresponding alternative in Aspose. Also is there any tools available to convert the code in Excel.Interop to Aspose.Cells or any good documentation on this.
strStartTsLoc = WorkSheet1.Range("D3").Next(2, 0).Address(False, False)
strStartTsEndLoc = WorkSheet1.Range(strStartTsLoc).End(XlDirection.xlToRight).Address(False, False)
Here D3 is temporarily hardcoded for better understanding actually this will be dynamic