Question
Carelon
IN
Last activity: 20 Nov 2024 4:41 EST
Get Last Cell Address in Excel
Hi Everyone,
I'm importing data from one sheet to exporting into master sheet and removing the duplicates in that column. When i'm trying to get the lastcellAddress but it is not giving accurate lastcellAddress. It is always giving the after exported the data into master sheet, it is giving that last cell Address not for after i removed the duplicates and then it should give that result.
for Ex: Initially I have 200 rows in master sheet and again i have export and imported data into master sheet and now master having the 400 rows.
Now i have removed the duplicates in that column and now total rows is 350. Now i'm trying to get the lastCellAddress and it is giving still 400 not for 350.
Please suggest on this.
Thanks & Regards,
Madhu
Pegasystems Inc.
US
@MadhuB16888323Which Connector are you using? If you use the ExcelConnector, it has a method called GetLastCellAddress. One of the parameters is Value only. This should provide you with the last address that has a value. There are overloads for that method that take in other parameters that might help as well. Do you have a simple example of the spreadsheets you are trying to work with? If so, you can attach them (assuming they have example data and nothing proprietary or identifying) and I will put together an example with them.
Carelon
IN
@ThomasSasnett Thank you for response!!
Now i'm able to get correct response after i close the connector and re open connector.