Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to write a data in excel file
#4
Solved: 11 Years, 3 Months, 4 Weeks ago
Hi,
Try this

Code:
'Set objExcel = CreateObject("Excel.Application")
'Set objWorkbook = objExcel.WorkBooks.Open("C:\Arul\Automationscripts\Excel-Cell-001")
'Set objDriverSheet = objWorkbook.Worksheets("Name")
'
''then just acces the cell itself :
'row = 1
'a=objDriverSheet.Cells(row,"A").Value
'b=objDriverSheet.Cells(row,"B").Value

regards,
Arul.D
Reply


Messages In This Thread
RE: How to write a data in excel file - by vIns - 06-07-2011, 06:43 PM
RE: How to write a data in excel file - by Arul - 08-20-2011, 08:01 PM
RE: How to write a data in excel file - by Ankesh - 08-23-2011, 07:00 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to export the output value of a webedit object to a new excel file. mounika6677 1 1,517 04-14-2019, 05:18 PM
Last Post: mounika6677
  Access not saved excel file randhirsinghskhn 0 1,029 09-04-2018, 07:26 AM
Last Post: randhirsinghskhn
  Want to read the data from excel and set read value in the JavaTable rajeevk7 0 2,309 07-10-2017, 04:20 PM
Last Post: rajeevk7
  dtLocalSheet empty even though excel file contains data cantorre 2 2,428 05-10-2017, 12:47 PM
Last Post: vidhi
  Reading data from excel sheet serenediva 1 9,597 03-03-2017, 10:07 AM
Last Post: vinod123

Forum Jump:


Users browsing this thread: 1 Guest(s)