«

I've tried:
$Test_suite_workbook = excel.workbooks.open(FileName,ReadOnly:=True)
and
$Test_suite_workbook = excel.workbooks.openFileName),ReadOnly:=True

Neither worked.

Thanks
--
Posted via http://www.ruby-forum.com/.

[Note: parts of this message were removed to make it a legal post.]

well, these links may help.

http://www.weheartcode.com/2007/10/0...file-with-ruby



On Feb 4, 2008 3:41 PM, Darin Duphorn <> wrote:

>
> I've tried:
> $Test_suite_workbook = excel.workbooks.open(FileName,ReadOnly:=True)
> and
> $Test_suite_workbook = excel.workbooks.openFileName),ReadOnly:=True
>
> Neither worked.
>
> Thanks
> --
> Posted via http://www.ruby-forum.com/.
>
>


--
--Ben Baka
Blog : http://benjaminbaka.wordpress.com/

On Feb 4, 2008 10:41 AM, Darin Duphorn <> wrote:
>
> I've tried:
> $Test_suite_workbook = excel.workbooks.open(FileName,ReadOnly:=True)
> and
> $Test_suite_workbook = excel.workbooks.openFileName),ReadOnly:=True
>
> Neither worked.
>
> Thanks
> --
> Posted via http://www.ruby-forum.com/.

Have a look at the parseexcel gem
http://raa.ruby-lang.org/project/parseexcel/

Darin Duphorn wrote:
>
> I've tried:
> $Test_suite_workbook = excel.workbooks.open(FileName,ReadOnly:=True)
> and
> $Test_suite_workbook = excel.workbooks.openFileName),ReadOnly:=True
>
> Neither worked.
>
> Thanks

try giving open() parameters as block...

xlApp=WIN32OLE::new('Excel.Application')
xlApp.Visible=1
xl_file = ('c:\\file.xls')
xlApp.Workbooks.Open({'filename'=> xl_file, 'readOnly' => true})
--
Posted via http://www.ruby-forum.com/.

Greg Halsey wrote:
> Darin Duphorn wrote:
>>
>> I've tried:
>> $Test_suite_workbook = excel.workbooks.open(FileName,ReadOnly:=True)
>> and
>> $Test_suite_workbook = excel.workbooks.openFileName),ReadOnly:=True
>>
>> Neither worked.
>>
>> Thanks
>
> try giving open() parameters as block...
>
> xlApp=WIN32OLE::new('Excel.Application')
> xlApp.Visible=1
> xl_file = ('c:\\file.xls')
> xlApp.Workbooks.Open({'filename'=> xl_file, 'readOnly' => true})

Thanks Greg that worked.

DD
--
Posted via http://www.ruby-forum.com/.