[wtr-general] Re: Need a sample code to import test data from Excel sheet

2009-09-08 Thread Rocky 

You can use:

   $folder_path='C:\\script\\qa'
   excel = WIN32OLE::new(excel.Application) # Create an instance of
the Excel application object
   $workbook = excel.Workbooks.Open($folder_path+\\TestData.xls)
   $worksheet = $workbook.WorkSheets(1) # get first workbook
   $test_site = $worksheet.Range(C4).Value # Pick Test URL form
TestData sheet

   $ie = Watir::IE.new
   $ie.goto($test_site)


Thanks
D G


On Sep 7, 6:05 pm, Ari arindraj...@googlemail.com wrote:
 MS Excel file can be read using parseexcel. See details 
 inhttp://ari-techno.blogspot.com/2009/09/reading-microsoft-office-excel...

 On Aug 11, 8:37 am, Naveen devadass naveeenku...@gmail.com wrote:

  Hi all,
  Can you please help on this

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---

[wtr-general] Re: Need a sample code to import test data from Excel sheet

2009-09-08 Thread Alister Scott 

You can always check out Roo: http://roo.rubyforge.org/
This library makes it easy to read Excel, OpenOffice and Google Docs,
without needing these programs installed (reads file directly).

Cheers,
Alister Scott

On Sep 8, 6:58 pm, Rocky dheerajgamb...@gmail.com wrote:
 You can use:

    $folder_path='C:\\script\\qa'
    excel = WIN32OLE::new(excel.Application) # Create an instance of
 the Excel application object
    $workbook = excel.Workbooks.Open($folder_path+\\TestData.xls)
    $worksheet = $workbook.WorkSheets(1) # get first workbook
    $test_site = $worksheet.Range(C4).Value     # Pick Test URL form
 TestData sheet

    $ie = Watir::IE.new
    $ie.goto($test_site)

 Thanks
 D G

 On Sep 7, 6:05 pm, Ari arindraj...@googlemail.com wrote:

  MS Excel file can be read using parseexcel. See details 
  inhttp://ari-techno.blogspot.com/2009/09/reading-microsoft-office-excel...

  On Aug 11, 8:37 am, Naveen devadass naveeenku...@gmail.com wrote:

   Hi all,
   Can you please help on this
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---

[wtr-general] Re: Need a sample code to import test data from Excel sheet

2009-09-08 Thread Alister Scott 

I have also just written a blog post on how to use Roo to specify test
cases in Excel/Open Office: http://wp.me/p98zF-56

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---

[wtr-general] Re: Need a sample code to import test data from Excel sheet

2009-09-08 Thread Richard Wijdenes 

I´ve learned a lot from this example:

http://wiki.openqa.org/display/WTR/Excel+Data+Driven+Harness+with+Database+Verifications
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---

[wtr-general] Re: Need a sample code to import test data from Excel sheet

2009-09-07 Thread Ari 


MS Excel file can be read using parseexcel. See details in
http://ari-techno.blogspot.com/2009/09/reading-microsoft-office-excel-file-in.html


On Aug 11, 8:37 am, Naveen devadass naveeenku...@gmail.com wrote:
 Hi all,
 Can you please help on this

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---

[wtr-general] Re: Need a sample code to import test data from Excel sheet

2009-08-11 Thread zakir hussain 
Hi,

I wud like to post in this group. Kindly add me in this chain


Thanks

zakir

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---

[wtr-general] Re: Need a sample code to import test data from Excel sheet

2009-08-11 Thread Smruti Ranjan Kar 
require 'win32ole'

$application = WIN32OLE.new('Excel.Application')
generalworksheet=$application.Workbooks.Open(Dir.getwd+\\Testdata\\testdata.xls).Worksheets(General)
generalworksheet.Activate
$test_site=generalworksheet.Cells(6,2).value

On Tue, Aug 11, 2009 at 1:14 PM, zakir hussain zaki...@gmail.com wrote:

 Hi,

 I wud like to post in this group. Kindly add me in this chain


 Thanks

 zakir


 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---

[wtr-general] Re: Need a sample code to import test data from Excel sheet

2009-08-11 Thread Wesley Chen 
You can search in the google group, you can also turn to Watir community,
you can get all the great documents about what you want.

Please search...

Thanks.
Wesley Chen.


On Tue, Aug 11, 2009 at 5:04 PM, Smruti Ranjan Kar 
smrutiranjan@gmail.com wrote:

 require 'win32ole'

 $application = WIN32OLE.new('Excel.Application')

 generalworksheet=$application.Workbooks.Open(Dir.getwd+\\Testdata\\testdata.xls).Worksheets(General)
 generalworksheet.Activate
 $test_site=generalworksheet.Cells(6,2).value


 On Tue, Aug 11, 2009 at 1:14 PM, zakir hussain zaki...@gmail.com wrote:

 Hi,

 I wud like to post in this group. Kindly add me in this chain


 Thanks

 zakir





 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---