I have a standard Excel sheet '[login to view URL]' 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.
Description:
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 [login to view URL] 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 [login to view URL] 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 = [login to view URL](filename, engine='openpyxl').
I'm confident to assist you with my experience in similar projects. If you award this project to me, I'll do my maximum to complete the work as per your requirements accurately / timely.