How to write Pandas Dataframe Horizontally in to Excel sheet from python openpyxl (elements in same row, consecutive columns)

Question

I have this problem where I am able to write Pandas dataframe into excel using openpyxl and it works fine where the dataframe is written vertically.( Same column, consecutive rows)

but I want to write my dataframe horizontally i.e. elements in same row, consecutive columns

My dataframe is a single dimensional one like [10, 9,8,7,6]

writer = pd.ExcelWriter(fn, engine='openpyxl')

writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

#df.to_excel(writer, sheet_name='Sheet1', header=None, index=False)
df_2.to_excel(writer, sheet_name='Sheet3', header=None, index=False,
             startcol=1,startrow=1)

writer.save()

My question is:

Can we define into this code snippet whether the data frame should be written vertically or horizontally just like startrow and startcol.

I've searched everywhere but could not find any.

First use df2 = df2.transpose()

Hoekieee
– Hoekieee

2019-11-19 11:40:11 +00:00
Commented Nov 19, 2019 at 11:40 — Hoekieee
– Hoekieee, Commented Nov 19, 2019 at 11:40

Hoekieee · Accepted Answer · 2019-11-19 11:41:41Z

0

This should solve your problem:

df2 = df2.transpose()
df_2.to_excel(writer, sheet_name='Sheet3', header=None, index=False,
         startcol=1,startrow=1)

As mentioned here

answered Nov 19, 2019 at 11:41

Hoekieee

4012 silver badges16 bronze badges

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

Comments

Horace · Accepted Answer · 2019-11-19 11:31:01Z

0

Have you tried transposing the dataframe before writing it ? e.g.

df_2.T.to_excel(writer, sheet_name='Sheet3', header=None, index=False, startcol=1,startrow=1)

answered Nov 19, 2019 at 11:31

Horace

1,0547 silver badges12 bronze badges

1 Comment

Jacky Over a year ago

I have used the same but do not get my desired result.

Collectives™ on Stack Overflow

How to write Pandas Dataframe Horizontally in to Excel sheet from python openpyxl (elements in same row, consecutive columns)

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related