Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- clip = pd.read_clipboard(header=None,names=['EA'])
- writer = pd.ExcelWriter('test.xlsx', engine="openpyxl")
- writer.book = book
- writer.sheets = {ws.title: ws for ws in book.worksheets}
- for test in writer.sheets:
- clip.to_excel(writer, sheet_name=test, startcol=2, startrow=writer.sheets[test].max_row, index=False, header=False)
- writer.save()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement