how can I add data to a new sheet when it's too long in Python

Question

Is there a way to add data to a new excel sheet when it's too long in python ? I have a dataframe with a lot of rows that do not fit into one excel sheet.

What library are you using? Pandas? – NumberC May 25 '20 at 21:16 — NumberC, May 25 '20 at 21:16

score 0 · Accepted Answer · answered May 25 '20 at 21:19

This was answered here: How to save a new sheet in an existing excel file, using Pandas?

Essentially, create a new dataframe object and then save it with a name.

x4 = np.random.randn(100, 2)
df4 = pd.DataFrame(x4)

df4.to_excel(writer, sheet_name = 'x4')

how can I add data to a new sheet when it's too long in Python

1 Answers1