Prepare for your Next Interview
This is a discussion on Read excel values into script without opening excel within the QTP forums, part of the Software Testing category; hi, I would like to get values from excel sheet without having to open the excel application. The code right now i have with me always opens the excel sheet ...
|
|||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
|||
|
Read excel values into script without opening excel
hi,
I would like to get values from excel sheet without having to open the excel application. The code right now i have with me always opens the excel sheet and then reads from it, instead is there a way to read the values without opening the excel workwook. The code is dim sExcelObj dim sWorkBook dim sWorkSheets dim sValue set sExcelObj = CreateObject("Excel.Application") sExcelObj.Visible = true set sWorkBook = sExcelObj.Workbooks.open("c:\book1.xls") set sWorkSheets = sWorkBook.worksheets ("Sheet1") sValue = sWorkSheets.cells(3,1).value Thanks in advance Regards Nemish |
| Sponsored Links |
|
|||
|
Re: Read excel values into script without opening excel
Try commenting the line of code -
sExcelObj.Visible = true I suppose that should do the trick !! Cheers....
__________________
Regards, V.Umesh Krishnan QA Consultant |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| DML for excel csv source | anil.kv | Data Warehousing | 1 | 06-24-2008 03:51 AM |
| Excel | srinii_vasu | Testing Issues | 2 | 02-23-2008 12:12 AM |
| Export to excel | paritosh.garg | JavaScript | 0 | 12-27-2007 01:26 AM |
| microsoft excel | raj.aura | Database General | 1 | 04-26-2007 06:18 AM |