-
May 18th, 2017, 07:46 PM
#1
Get last cell address in Excel worksheet
I've noticed over the years developers asking how to get the last used cell in an Excel WorkSheet via Excel automation. So I created a GitHub repo which demonstrates using Excel automation how to get the last used cell address along with using SpreadSheetLight library.
https://github.com/karenpayneoregon/...s/tree/Update1
When downloaded you will need to check the projects ExcelUsedColumnsLib and ExcelUsedColumnsLib_vb references to see if the reference for Microsoft.Office.Interop.Excel is valid as you may have a different version of Excel. For SpreadSheetLight right click on the Solution, select restored packages.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|