ExcelPlugin 0.1.6

Плагин для гибкой настройки Excel документов.

ExcelPlugin

Features

• 🎨 Advanced cell styling (fonts, borders, alignment)
• 📊 Seamless pandas DataFrames integration
• 🔄 Excel template processing
• 📈 Batch operations support
• 🖥️ CLI interface for quick operations

Installation

pip install ExcelPlugin

Quick Start

from ExcelPlugin import ExcelStyler, PandasExcelManager

# Create styled workbook
styler = ExcelStyler()
workbook = styler.create_workbook()
sheet = styler.add_sheet(workbook, "Report")

# Apply styles
styler.apply_style(sheet['A1'], 
                 font=styler.font(bold=True, color="FF0000"),
                 fill=styler.fill(patternType="solid", fgColor="00FF00"))

# Save
styler.save(workbook, "report.xlsx")

# Pandas integration
manager = PandasExcelManager()
df = manager.read_excel("data.xlsx")
manager.write_with_styles(df, "output.xlsx", styler)

CLI Usage

# Apply template styles
excel-plugin apply-styles --input data.xlsx --template styles.json --output styled.xlsx

# Convert CSV to styled Excel
excel-plugin csv2xlsx data.csv --output report.xlsx

Documentation

Full documentation available at GitHub Wiki

Contributing

Pull requests are welcome! See CONTRIBUTING.md for details.