Python: output variables onto existing excel sheet

Question

I was wondering how to output using Python variables onto an existing excel sheet.

Given the excel column

[A] [B] [C] [D] [E] [F] [G] [H] [I] [J]

Note:

List item [A] [B] [C] [D] : are given in one excel file (text.xlsx)
I have strings on [E] [F] , [H] [I] (manipulations based on [A][B][C][D]) ready as a variable
I have an int (%) on [G] [J] (manipulations based on [A][B][C][D]) ready as a variable

For excel input, I am using xlrd, but I was wondering how do I output these variables onto the same/existing excel file? Which library do I use?

Rahul Raut · Accepted Answer · 2019-06-25 10:25:31Z

4

There are python packages available to work with Excel files that will run on any Python platform and that do not require either Windows or Excel to be used. They are fast, reliable and open source like openpyxl, xlsxwriter.

Also this may help to you to update existing excel file.

answered Jun 25, 2019 at 10:25

Rahul Raut

1,53810 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python: output variables onto existing excel sheet

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related