New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
Set the column header in the excelsheet before importing it to local datasheet

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Set the column header in the excelsheet before importing it to local datasheet
surya_7mar Offline
Member
***
Posts: 130
Threads: 0
Joined: Jul 2008
Reputation: 0
#2
Solved: 11 Years, 3 Months, 3 Weeks ago 08-04-2008, 03:42 PM
Try adding your columns names using the below code to your Data Sheets.


Code:
DataTable.AddSheet "DBOutput"
arrHeader = Array("Col1", "Col2", "Col3", "Col4")

    For each s in arrHeader
            DataTable.GetSheet ("DBOutput").AddParameter  s, ""              
            Next
Find
Reply


Messages In This Thread
RE: Set the column header in the excelsheet before importing it to local datasheet - by surya_7mar - 08-04-2008, 03:42 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  export UFT datasheet to excel and then append Mozza 0 1,893 09-04-2018, 08:58 AM
Last Post: Mozza
  to count the number of used rows in a particular column sujaravi123 3 11,149 06-12-2013, 03:17 PM
Last Post: sujaravi123
  Importing excel not working Adam82 6 13,601 11-05-2012, 05:22 PM
Last Post: Adam82
  GetRowWithCellText does not work if the header has a colspan ConstantChange 6 7,529 05-08-2012, 04:19 PM
Last Post: Mahmoud.Karam
  How to recognize table row and column siwani 4 5,018 04-05-2012, 05:06 PM
Last Post: verma.vik6

Forum Jump:


Users browsing this thread: 1 Guest(s)