Write an array in specific column by Pandas to_excel

Question

pandas.DataFrame.to_excel documentation says column is optional Columns to write, but I'm wrong, how should the specific column (e.g. column J) be defined?

import pandas as pd
my_array = [0 for i in range(len(data))]
pd_array = pd.DataFrame(my_array)
pd_array.to_excel(r'C:\Users\my_dir\SandBox.xlsx', sheet_name='Sheet2', columns = 8)

Shivid · Accepted Answer · 2017-03-17 12:18:17Z

3

Ok, startcol was the answer!

pd_array.to_excel(r'C:\Users\my_dir\SandBox.xlsx', sheet_name='Sheet2', startcol= 8)

answered Mar 17, 2017 at 12:18

Shivid

1,3511 gold badge23 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Write an array in specific column by Pandas to_excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related