how do I open read-only excel from python using win32com

Question

I need to open an xls file from python using win32com as read-only and I seem not be getting the effect I desire

Here is what I do:

import win32com

xl = win32com.client.Dispatch('Excel.Application')
wb = xl.Workbooks.Open(file_path, ReadOnly=1) # 1 is for readonly

The workbook opens and data shows; however, the file is not opened as read-only.
per MSDN argument signature should trigger read-only effect but it does not.

Anyone had to deal with similar problem before?

What do you need to get from the workbook? Table of information? — chucklukowski, Aug 13 '19 at 17:13
Although there are better ways to access an Excel document than using win32com, try setting `ReadOnly` to `True` instead of `1` — FishMonkey, Aug 13 '19 at 17:15

score 2 · Accepted Answer · answered Aug 13 '19 at 17:15

2

ReadyOnly is a third parameter according to the documentation. Pass None for the UpdateLinks and True for ReadyOnly.

wb = xl.Workbooks.Open(file_path, None, True)

answered Aug 13 '19 at 17:15

EylM

5,967
2
16
28

1

@EyIM, Thank you very much! that was exactly what I was missing. I have gotten way too used to named parameters in python...Thanks again!! – JavaFan Aug 13 '19 at 17:18

how do I open read-only excel from python using win32com

1 Answers1