semvec/pypi-packages huggingface dataset:
xlpandas 0.1.4
Read and write xlsx/xlst using pandas/openpyxl while preserving Excel formatting
License: MIT

# xlPandas

Read and write Excel xlsx using pandas/openpyxl without destroying formatting.

Sometimes you have a nicely formatted worksheet, but you'd like to work with it
using [pandas](https://pypi.org/project/pandas/), or perhaps you want to write
data to an Excel template.

Pandas can read and write Excel files using `xlrd`, but treats them like csvs.
xlPandas uses [openpyxl](https://pypi.org/project/openpyxl/) to access data
while preserving template formatting, macros, and other worksheet attributes.

## Install

`pip install xlpandas`

## Example

``` python

import xlpandas as xpd

# Read excel file
df = xpd.read_file('template.xlsx', skiprows=2)
print(df.columns)

# Modify dataframe
df['new_column'] = True

# Access openpyxl worksheet
sheet = df.to_sheet()
sheet.cell(1,1).value = 'title'

# From openpyxl worksheet
df = xpd.xlDataFrame(sheet)

# Write file
df.to_file('out.xlsx')

```
boolify 0.0.4.dev0
Convert common strings into bool values.
License: MIT
Requires Python: >=3.6.*
Keywords: boolify,bool,boolean,convert,open-source,library,python,python3,python-3


# Boolify

[![License][bagde-license]][license]
[![Runtime Version][bagde-runtime-version]][boolify-pypi]
[![Discord Server][bagde-discord-server]][support-server-discord]

Convert common strings into bool values


[bagde-discord-server]: https://img.shields.io/discord/549020573846470659.svg?logo=discord&logoColor=white&logoWidth=15&style=plastic
[bagde-license]: https://img.shields.io/github/license/luissilva1044894/boolify?logo=github&logoWidth=15&style=plastic
[bagde-runtime-version]: https://img.shields.io/pypi/pyversions/boolify.svg?logo=python&logoColor=white&logoWidth=15&style=plastic
[license]: ./LICENSE "Boolify · License"
[boolify-pypi]: https://pypi.org/project/boolify "Boolify · PyPI"
[support-server-discord]: https://discord.gg/XkydRPS "Support Server · Discord"