StyleFrame | wraps pandas openpyxl | Dashboard library

I am trying to save a number of pandas dataframes to excel. I want them all in the same excel file, but with each one on a different sheet.

This is what I have at the moment. This is just saving all my dataframes to separate files. I have used StyleFrame. Some of the values in these dataframes have \n. When I write to excel, I want it to register this as a new line within each cell.

Using StyleFrame was the only solution I could find.

I have an excel file that hVave two sheets. I want to open the excel and apply Style frame to two sheets. Usually when the excel have only one sheet I use this code:

I'm trying to write a script that merges two excel files together. One has been has been hand processed and has a bunch custom formatting done to it, and the other is an auto-generated file. Doing the merge in pandas is simple enough, but preserving the formatting is proving troublesome. I found the styleframe library, which seems like it should simplify what I'm trying to do, as it can import style info in addition to the raw data. However, I'm having problems actually implementing the code.

My questions is this: how can I pull style information from each individual cell in the excel and then apply that to my merged dataframe? Note that the data is not formatted consistently across columns or rows, so I don't think I can apply styles in this manner. Here's the relevant portion of my code:

I'm attempting to programmatically create a spreadsheet to store some AWS data, by taking an Excel template and adding new data to it. I decided to use StyleFrame for this to preserve the formatting. I've managed to get the data concatenated together in the format I want it in, but I keep running into index issues when I attempt to write it to an Excel file.

The relevant section of stacktrace is:

i've been trying to create component classes in one file and default export them into another file where they are imported and displayed in another component class (all for the sake of keeping my code clean)

But i am having problems getting the code to show up on the webpage i have built.

Here is the code in my App.js

This is not a deal breaker but I used to import this library via "import StyleFrame", but now it throws the error:

ModuleNotFoundError: No module named 'StyleFrame'

Switching from "import StyleFrame" to "import styleframe" fixes the problem, but just wanted to know if this was done intentionally by the creator?

I want to find colored cells by iterating the rows.

I know how to iterate columns, but not rows.
In pandas dataframe, it would be

I have a file that has green highlighted cells and red highlighted cells indicating severity level.

Right now I'm using StyleFrame to extract them but for some reason I can extract the red cells but not the green cells. Any idea of how to go about this?

Notice that I made sure that the colors specified in the code are the same as the file.