So, I have one very large Dataframe that is composed of over 70 smaller dataframes, of ten rows each. I want to use xlsxwriter to write them into an excel sheet; however, I want the dataframes to be displayed in a grid format, so that they do not simply place going east to west or north to south. My desired output is shown below.
Asked
Active
Viewed 92 times
0
-
Please provide enough code so others can better understand or reproduce the problem. – Community May 23 '22 at 17:12
1 Answers
0
Just use the startcol and startrow from DataFrame.to_excel
Use df.shape to get the desired col/row position. Allocate space for the headers
Zaero Divide
- 699
- 2
- 10