/Python/Append data at the end of an excel sheet pandas

Append data at the end of an excel sheet pandas

### first get max row number ###
max_row = df.shape[0]
### the append to (max_row + 1) without header ###
df.to_excel("file.xlsx",sheet_name="sheetname",startrow=max_row+1,header=False,index=False)
### if you have index column in your excel file ###
	 ### then you can just set index=True  ###

Similar codes

2 votes143 views1 answer
Logout in discord.py
Python
0 vote138 views1 answer
Name decorator in python
Python
95 votes179 views6 answers
Check if string contains python
Python
1 vote125 views1 answer
Check if coroutine python
Python
0 vote194 views1 answer
Find position of nan pandas
Python
0 vote141 views1 answer
First hitting time python
Python
3 votes124 views2 answers
Python initialize list
Python
3 votes182 views2 answers
Publisher python ros
Python
7 votes132 views1 answer
Short if else in python
Python
1 vote101 views1 answer
How to print the max occurring in dictionary python
Python