df-to-excel-a1 0.1.1

Convert pandas DataFrames to Excel-style A1 layouts.

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:

pip install df-to-excel-a1

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

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:

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:

from df_to_excel_a1 import str_excel_label

print(str_excel_label(27))  # AB