Comments (1)
If you want to format your header then use header_format
if you want to format everything else then use column_formats
but just assign the same format to all of your columns. It accepts a selector so you don't have to verbosely list all your columns. For example...
import polars as pl
import polars.selectors as cs
df.write_excel('file.xlsx', header_format={'bg_color': '#FFCC99', 'border': 2}, column_formats={cs.all():{'border':1})
@alexander-beedie what do you think?
from polars.
Related Issues (20)
- Using `scan_csv` with `with_column_names` argument disables schema validation
- `strict` parameter not applied correctly during row-wise DataFrame construction HOT 5
- Fix doc of GroupBy.__iter__ HOT 1
- SchemaMismatch during `collect`
- Segmentation fault with `to_numpy` with Numpy 2 and datetime column HOT 1
- Entered unreachable code on valid SQL HOT 7
- Using pandas `Timestamp` in DataFrame constructor drops timezone info
- Add instructions for building from source for non polars developers HOT 2
- Aggregate the whole dataframe HOT 2
- Panic when filtering by non-boolean
- Issue in global variable discovery in `polars.sql` HOT 3
- struct selector HOT 2
- Indexing a Series object with a string raises a confusing TypeError. HOT 1
- pl.from_pandas fails when NaNs are in object columns HOT 1
- Iter_batches does not work with a Snowflake connection in pl.read_database()
- Possible bug at `when().then().otherwise()` HOT 4
- read_excel (calamine engine) Boolean schema override not working HOT 2
- `from_arrow` is not zero-cost HOT 2
- `DataFrame.cast` and `Series.cast` with nested dtype casts to `null` without error HOT 1
- str.split with list.get is not detecting the indexes HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from polars.