modifier template dans excel #3

New Issue

guillaumeredoules · 2020-07-21T15:57:33Z

guillaumeredoules commented

2020-07-21 15:57:33 +00:00

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