i am working on a web base project, using technology ASP.Net
i need to access some controls like check boxes and drop down lists on an excel sheet to change their values.
can anybody of u GURUs help me to sort out this problem.
any idea or solution????????
i am using a code below:
Dim xl As New Excel.Application
Dim wb As Excel.Workbook
Dim sh As Excel.Worksheet
wb = xl.Workbooks.Open("c:\asim.xls")
wb.SaveCopyAs("c:\asim2.xls")
wb.Close()
wb = xl.Workbooks.Open("c:\asim2.xls")
sh = wb.Worksheets("Sheet1")
sh.Cells(5, 2) = "Project 1"
sh.Cells(6, 2) = "asim jamil"
sh.Cells(7, 2) = "Hello world"
wb.Save()
wb.Close()
xl.Application.Quit()
i need to access some controls like check boxes and drop down lists on an excel sheet to change their values.
can anybody of u GURUs help me to sort out this problem.
any idea or solution????????
i am using a code below:
Dim xl As New Excel.Application
Dim wb As Excel.Workbook
Dim sh As Excel.Worksheet
wb = xl.Workbooks.Open("c:\asim.xls")
wb.SaveCopyAs("c:\asim2.xls")
wb.Close()
wb = xl.Workbooks.Open("c:\asim2.xls")
sh = wb.Worksheets("Sheet1")
sh.Cells(5, 2) = "Project 1"
sh.Cells(6, 2) = "asim jamil"
sh.Cells(7, 2) = "Hello world"
wb.Save()
wb.Close()
xl.Application.Quit()