Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
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 ...
|
|||||||
|
|||
|
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 | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| DML for excel csv source | anil.kv | Data Warehousing | 2 | 09-25-2009 05:08 AM |
| Export to excel | paritosh.garg | JavaScript | 2 | 02-12-2009 08:44 AM |
| Excel | srinii_vasu | Testing Issues | 2 | 02-23-2008 12:12 AM |
| microsoft excel | raj.aura | Database General | 1 | 04-26-2007 06:18 AM |