Does anyone know how to open a excel file in read only?

Ruby
1

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

Neither worked.

Thanks

2

well, these links may help.

http://www.weheartcode.com/2007/10/05/reading-an-excel-file-with-ruby

3

On Feb 4, 2008 10:41 AM, Darin D. [email protected]
wrote:

Posted via http://www.ruby-forum.com/.
Have a look at the parseexcel gem
http://raa.ruby-lang.org/project/parseexcel/

4

Darin D. 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})

5

Greg H. wrote:

Darin D. 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