Metadata-Version: 2.4
Name: df-to-excel-a1
Version: 0.1.1
Summary: Convert pandas DataFrames to Excel-style A1 layouts.
Author: Alves Beirigo
License: MIT
Classifier: Development Status :: 3 - Alpha
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Programming Language :: Python :: 3.12
Classifier: Operating System :: OS Independent
Classifier: Intended Audience :: Developers
Classifier: Topic :: Software Development :: Libraries
Requires-Python: >=3.8
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pandas
Dynamic: author
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: license
Dynamic: license-file
Dynamic: requires-dist
Dynamic: requires-python
Dynamic: summary

## df-to-excel-a1

Convert pandas DataFrames to Excel-style A1 layouts.

### Features
- Convert zero-based column indexes to Excel labels (`A`, `B`, ..., `AA`, `AB`).
- Transform a DataFrame to look like an Excel sheet (headers as first row, Excel-style column labels, 1-based index).

### Usage

Install from PyPI:

```bash
pip install df-to-excel-a1
```

Convert a DataFrame with ordinary pandas columns and zero-based row indexes:

```python
import pandas as pd
from df_to_excel_a1 import excelify

df = pd.DataFrame({"Name": ["Alice", "Bob"], "Score": [90, 85]})

print("Before:")
print(df)

print("\nAfter:")
print(excelify(df))
```

Output:

```text
Before:
    Name  Score
0  Alice     90
1    Bob     85

After:
       A      B
1   Name  Score
2  Alice     90
3    Bob     85
```

Column labels can also be generated directly:

```python
from df_to_excel_a1 import str_excel_label

print(str_excel_label(27))  # AB
```
