Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. clip = pd.read_clipboard(header=None,names=['EA'])
  2. writer = pd.ExcelWriter('test.xlsx', engine="openpyxl")
  3. writer.book = book
  4. writer.sheets = {ws.title: ws for ws in book.worksheets}
  5. for test in writer.sheets:
  6. clip.to_excel(writer, sheet_name=test, startcol=2, startrow=writer.sheets[test].max_row, index=False, header=False)
  7. writer.save()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement