Hi I update an excel worksheet from vb.net.
Sometime, I would like to take off some rows in this worksheet for example, row 20 to row 32.
How can I make it?
Sometime, I would like to take off some rows in this worksheet for example, row 20 to row 32.
How can I make it?
Code:
Dim exPoolSchedule As New Excel.Application
Dim wbPoolSchedule As Excel.Workbook
Dim wsPoolSchedule As Excel.Worksheet
wbPoolSchedule = exPoolSchedule.Workbooks(1)
wsPoolSchedule = wbPoolSchedule.Worksheets(1)
wsPoolSchedule.Cells(2, 4) = String.Format("{0:MMMM dd yyyy}", Today)
wsPoolSchedule.Cells(4, 2) = JobDr.Item("ProjectName")
wsPoolSchedule.Cells(5, 2) = JobDr.Item("ProjectLocation")
wsPoolSchedule.Cells(6, 2) = JobDr.Item("Room_volume")
...
exPoolSchedule.Visible = False
wsPoolSchedule.SaveAs(Path & "\" & "PoolSchedule Master May 20061.xls")
exPoolSchedule.Workbooks.Close()