تخطَّ إلى المحتوى
TakoAPI
العودة إلى المهارات

csvtoexcel

بواسطة xuanguan2020

Shopping & E-commerce
923التنزيلات وفق ما يذكره clawskills.sh
1المشاهدات
لا إعجاباتسجّل الدخول للإعجاب بهذه المهارة
—لم يُقيَّم بعد
تقييمك

موجز

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. 1

    Receives the three CSV files

  2. 2

    Runs csv_to_excel.py with all three inputs and --output flag

  3. 3

    Passes --sheet-names with Chinese labels for each sheet

  4. 4

    Script detects encoding of each file and writes formatted sheets

  5. 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/csvtoexcel

شغّل أمر واجهة سطر الأوامر، أو الصق النص في Claude Code أو Cursor أو Codex أو أي وكيل برمجة تستخدمه.

الروابط