Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Importing data sheet
#1
Not Solved
hi all,

i am new to qtp. so can you please help me that how to import value to excel sheet
Reply
#2
Not Solved
you can check for ExportSheet or Export datatable methods in help.

Code:
DataTable.Export FileName
DataTable.Export ("C:\flights.xls")

Code:
DataTable.ExportSheet FileName, vtSrcSheet, [DstSheetName]
DataTable.ExportSheet "C:\name.xls" ,1
Thanks,
SUpputuri
Reply
#3
Not Solved
Also if you are creating excel object then u can code like this..
sheet.cells(i,j).value=4,5,etc.. to set values in cells
workbook.save
xl.quit ' to quit excel application
set xl = nothing ' to release memory
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading data from excel sheet serenediva 1 9,696 03-03-2017, 10:07 AM
Last Post: vinod123
Question QTP not performing iterations based on local data sheet Breaker 18 56,959 01-25-2016, 04:32 PM
Last Post: arunshuklainbox
  On Saving Script in QTP 11 my Global Data Sheet data is removed M Adnan Iftikhar 0 2,196 06-02-2015, 09:19 PM
Last Post: M Adnan Iftikhar
Smile Importing Excel sheet - Reference Values are not recognized michiusa69 3 7,943 01-23-2015, 02:36 AM
Last Post: lkng2001
  Invalid File error importing a spreadsheet but only on a VM msacks 1 2,784 10-19-2014, 09:04 PM
Last Post: supputuri

Forum Jump:


Users browsing this thread: 1 Guest(s)