csvtoexcel
xuanguan2020 द्वारा
Shopping & E-commerceसंक्षिप्त
Convert CSV files to professionally formatted Excel workbooks with Chinese character support, automatic formatting.
विवरण
यह स्किल क्या करती है
Converts CSV files to formatted Excel workbooks using a Python script. Handles Chinese character encoding automatically and supports combining multiple CSVs into a single workbook with separate sheets.
Automatically detects encoding (UTF-8, GBK, GB2312) and applies professional formatting in one step, avoiding the manual encoding and styling work required when opening CSVs directly in Excel.
इसे कब इस्तेमाल करें
- Converting a data export CSV into a shareable Excel report
- Merging quarterly sales CSVs into one workbook with named sheets
- Fixing garbled Chinese text when opening CSVs in Excel
- Creating formatted spreadsheets with styled headers and auto-sized columns
- Generating multi-sheet Excel files from separate department data files
उदाहरण वर्कफ़्लो
User asks: Combine sales_q1.csv, sales_q2.csv, and inventory.csv into one Excel file with Chinese sheet names
- 1
Receives the three CSV files
- 2
Runs csv_to_excel.py with all three inputs and --output flag
- 3
Passes --sheet-names with Chinese labels for each sheet
- 4
Script detects encoding of each file and writes formatted sheets
- 5
Outputs combined .xlsx with frozen headers, borders, and auto-adjusted columns
A single Excel workbook with three named sheets, each containing formatted data from the corresponding CSV
आवश्यकताएँ
- openpyxl Python package (pip install openpyxl)
इंस्टॉलेशन
clawhub install xuanguan2020/csvtoexcelCLI कमांड चलाएँ, या प्रॉम्प्ट को Claude Code, Cursor, Codex या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।