Stack Overflow
Stack Overflow

Questions tagged [styleframe]

StyleFrame is a Python library that wraps pandas and openpyxl and makes outputting styled dataframes to Excel easy.

Resources:

53 questions
0
votes
0 answers

How to filter excel data based on color of the cell in python?

I have an excel file with many columns. The data has to be separated based on the colour of the cells specific column. For example in the above image, last 3 rows should be extracted in single file based on the color of column A1/A2. Similarly, the…
Gaurav
  • 2,003
  • 1
  • 25
  • 50
0
votes
1 answer

How to select one row in styleframe?

I want to select the first two rows to apply styles, but I cannot select them. I have tried many methods, but all cannot work. SH1.apply_style_by_indexes(indexes_to_style=SH1[SH1[0]],…
Trinidad
  • 211
  • 2
  • 14
0
votes
1 answer

Is it possible to set the border to be the default Excel faint grey using StyleFrame?

Looking at the documentation for StyleFrame, it looks like none of the borders options are just the normal faint grey border found by default on Excel spreadsheets. Is it possible to set this using Styler?
OD1995
  • 1,647
  • 4
  • 22
  • 52
0
votes
1 answer

pandas require version xlrd 1.1.0 but styleframe should have xlrd 1.0.0. How to set it correctly, so that I need both styleframe and pandas?

### I tried to read excel, pandas.read_excel("excel_file.xlsx") where I got the error saying "ImportError: Pandas requires version '1.1.0' or newer of 'xlrd' (version '1.0.0' currently installed)" ### Reinstalling xlrd. After when checked…
Aravind KR
  • 27
  • 6
0
votes
1 answer

saving style of the header of StyleFrame.object to_excel

When I save a StyleFrame object using sf.to_excel(), the header's style does not get saved to the xls file. Xls file's header always comes up in Arial 12 which appears to me as some default. Right before calling sf.to_excel() my…
Jorge
  • 83
  • 10
0
votes
1 answer

convert StyleFrame obj to a pandas dataframe after reading a excel file

Is it possible to extract pandas dataframe from a styleframe object? sf = StyleFrame.read_excel("my.xlsx", read_style=True) df = sf.to_dataframe()?? Panda's read_excel() does not seem to read style from excel so I am thinking of using StyleFrame…
Jorge
  • 83
  • 10
0
votes
1 answer

Possible to Read Excel Tab into Code and Write Back that Same Tab With Formatting

I have code that creates an excel file named file_A using XlsxWriter. Users have sent me an excel file named file_b which just has one tab, named tab_b. They want tab_b appended to file_A. This tab_b includes a lot of formatting (some of it I…
Curiosity
  • 149
  • 1
  • 2
  • 11
0
votes
0 answers

Why does the index column's title not show when using StyleFrame sf.to_excel()?

I am writing a script in which I want the output to be an Excel sheet with auto-fitted column width's. Further, I want the index column's title to appear. Right now, I run the script and the Excel sheet populates with auto-fitted column width's, but…
Dylan G
  • 1
1 2 3
4