modifier template dans excel #3

Open
opened 2020-07-21 15:57:33 +00:00 by guillaumeredoules · 0 comments
import xlwings as xw
app = xw.App(visible=False)

#%%
wb = xw.Book  (r'Template_Gamme_Fusion.xlsx')

wb.names("test").refers_to_range.value = 2
wb.save("Gamme_fusion.xlsx")
wb.close()

# %%

# %%
wb = xw.Book  (r'Template_Gamme_Fusion.xlsx')
wb.names

# %%
for name in wb.names:
    print(name)

```python import xlwings as xw app = xw.App(visible=False) #%% wb = xw.Book (r'Template_Gamme_Fusion.xlsx') wb.names("test").refers_to_range.value = 2 wb.save("Gamme_fusion.xlsx") wb.close() # %% # %% wb = xw.Book (r'Template_Gamme_Fusion.xlsx') wb.names # %% for name in wb.names: print(name) ```
Sign in to join this conversation.
No Label
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: guillaumeredoules/redoules.github.io#3
No description provided.