Hello
I have an Excel file that is already designed and has content
The program is designed in such a way that when the user clicks on the save in Excel file option in the menu, the content of several strings and numbers will be saved in the specified sheet and columns of this Excel file.
Currently, my problem is that I don't know how to determine what is the last row stored in that text?
I use XLUtils and XLWorkbookWriter method to save Excel file
Please help me, when I open the Excel file, it will be clear, for example, what row is the last empty row of column B?
I have an Excel file that is already designed and has content
The program is designed in such a way that when the user clicks on the save in Excel file option in the menu, the content of several strings and numbers will be saved in the specified sheet and columns of this Excel file.
Currently, my problem is that I don't know how to determine what is the last row stored in that text?
I use XLUtils and XLWorkbookWriter method to save Excel file
Please help me, when I open the Excel file, it will be clear, for example, what row is the last empty row of column B?
frist code:
Dim Workbook As XLWorkbookWriter = xl.CreateWriterFromTemplate("C:\Users\*****\Desktop\New folder", "1.xlsx")
Dim sheet1 As XLSheetWriter = Workbook.CreateSheetWriterByName("Sheet1")