본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

csvtoexcel

xuanguan2020 제작

Shopping & E-commerce
923clawskills.sh가 보고한 다운로드 수
1조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

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

CLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크