python winapi check if sheet exists

Question

i am using this:

from win32com.client import Dispatch
excel_file = Dispatch("Excel.Application")
excel_file.Workbooks.Open(excel_result_path)
excel_file.Visible = 1
mySheet = excel_file.Worksheets.Add()
mySheet.Name = "name"

which works fine. the only problem is, if the sheet allready exists, i get an error telling me, that the sheet already exists

File "..\dynamic.py", line 554, in setattr pywintypes.com_error: (-2147352567, 'Ausnahmefehler aufgetreten.', (0, 'Microsof t Excel', 'Kann einem Blatt nicht den gleichen Namen geben wie einem anderen Bla tt, einer Objektbibliothek oder einer Arbeitsmappe, auf die Visual Basic Bezug n immt.', 'xlmain11.chm', 0, -2146827284), None)

so my question is, how can i check if an excel-sheet-name allready exists ?

Could you catch the exception? Or see if "name" is in wb.Sheets.Name? What do you want to do if it exists already? — doctorlove, Sep 18 '13 at 08:50

score 4 · Accepted Answer · answered Sep 18 '13 at 09:43

4

'name' in [excel_file.Sheets(i).Name for i in range(1,excel_file.Sheets.Count+1)]

answered Sep 18 '13 at 09:43

vikash

56
2

A different solution is at: http://stackoverflow.com/a/37966737/1305322 – sm535 Dec 31 '16 at 03:33
yes but that solution uses a library not part of the OP's original question – LeanMan May 29 '20 at 23:10
The library op uses can't do what op asks – Charalamm Jun 13 '21 at 10:51

score 0 · Answer 2 · answered Oct 19 '22 at 11:53

0

Slightly more readable solution:

'name' in [sheet.Name for sheet in excel_file.Sheets]

answered Oct 19 '22 at 11:53

Izaak Cornelis

173
7

python winapi check if sheet exists

2 Answers2

Linked