[wtr-general] Re: Need a sample code to import test data from Excel sheet
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
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
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
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
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
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
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
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 -~--~~~~--~~--~--~---