Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to write a data in excel file
#5
Solved: 10 Years, 9 Months ago
Code:
Set ObjExcel=CreateObject("Excel.Application")
  Set objWorkbook = ObjExcel.Workbooks.add
  Set objWorksheet = objWorkbook.Worksheets(1)

   objWorksheet.Name = SheetName
   'ObjExcel.Visible=True

'to write values to the cells....

Code:
objWorksheet.cells(1,1)="Property"
    objWorksheet.cells(1,2)="Validation"
    objWorksheet.cells(1,3)="Outcome"
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,331 04-14-2019, 05:18 PM
Last Post: mounika6677
  Access not saved excel file randhirsinghskhn 0 933 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,171 07-10-2017, 04:20 PM
Last Post: rajeevk7
  dtLocalSheet empty even though excel file contains data cantorre 2 2,213 05-10-2017, 12:47 PM
Last Post: vidhi
  Reading data from excel sheet serenediva 1 8,840 03-03-2017, 10:07 AM
Last Post: vinod123

Forum Jump:


Users browsing this thread: 1 Guest(s)