I have a standard Excel sheet '[url removed, login to view]' which I would like to restructure in three separates frames, i.e. 'Day Trading', 'Scalping' and 'Shorting'. The main title would be 'Best gainers'. I would like the end result gives me a worksheet stylish and elegant.
1- Each frame and the title will be separated with one or two rows.
2- The main title is at the top and centered. The subtitles are at the top left of each frame.
3- The title bar needs to be inserted in each frame or it could be a followed title bar whenever we scroll down.
4- The columns would resize automatically according to the number of characters of each title column. Use resize_columns() class method from styling.py.
5- Each frame needs to be auto-adjustable in function of the number of rows. folding_rows() class method from [url removed, login to view] could be used to fix the maximum number of rows in each frame.
6- Each title would be styled. The style_ws() class method from [url removed, login to view] could be used for that task.
7- The title bar will be framed and the titles of each columns will be enlarged and bold.
Be creative! :D
P.S. Your best tool is probably pandas and openpyxl. I liked using writer = [url removed, login to view](filename, engine='openpyxl').