import pandas as pd

# 基礎(chǔ)用法
df = pd.read_csv('data.csv')
df.to_excel('output.xlsx', index=False)

# 指定sheet名稱
df.to_excel('output.xlsx', sheet_name='數(shù)據(jù)', index=False)

# 多sheet寫入
with pd.ExcelWriter('output.xlsx') as writer:
    df1.to_excel(writer, sheet_name='Sheet1', index=False)
    df2.to_excel(writer, sheet_name='Sheet2', index=False)

import csv
from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill

# 創(chuàng)建工作簿
wb = Workbook()
ws = wb.active
ws.title = '數(shù)據(jù)'

# 從CSV讀取數(shù)據(jù)
with open('data.csv', 'r', encoding='utf-8') as f:
    csv_reader = csv.reader(f)
    for row_idx, row in enumerate(csv_reader, 1):
        for col_idx, value in enumerate(row, 1):
            cell = ws.cell(row=row_idx, column=col_idx, value=value)

            # 第一行格式化為標(biāo)題
            if row_idx == 1:
                cell.font = Font(bold=True, color='FFFFFF')
                cell.fill = PatternFill(start_color='4472C4', end_color='4472C4', fill_type='solid')

# 自適應(yīng)列寬
for column in ws.columns:
    max_length = 0
    column_letter = column[0].column_letter
    for cell in column:
        max_length = max(max_length, len(str(cell.value)))
    ws.column_dimensions[column_letter].width = min(max_length + 2, 50)

wb.save('output.xlsx')

import csv
import xlsxwriter

# 創(chuàng)建Excel文件
workbook = xlsxwriter.Workbook('output.xlsx')
worksheet = workbook.add_worksheet('數(shù)據(jù)')

# 定義格式
header_format = workbook.add_format({
    'bold': True,
    'bg_color': '#4472C4',
    'font_color': 'white',
    'border': 1
})

data_format = workbook.add_format({
    'border': 1,
    'align': 'left',
    'valign': 'vcenter'
})

# 讀取CSV并寫入Excel
with open('data.csv', 'r', encoding='utf-8') as f:
    csv_reader = csv.reader(f)
    for row_idx, row in enumerate(csv_reader):
        for col_idx, value in enumerate(row):
            if row_idx == 0:
                worksheet.write(row_idx, col_idx, value, header_format)
            else:
                worksheet.write(row_idx, col_idx, value, data_format)

# 凍結(jié)首行
worksheet.freeze_panes(1, 0)

workbook.close()

import csv
from openpyxl import Workbook
from openpyxl.utils import get_column_letter

def csv_to_excel(csv_file, excel_file, sheet_name='Sheet1', encoding='utf-8'):
    """
    將CSV轉(zhuǎn)換為Excel

    參數(shù):
        csv_file: CSV文件路徑
        excel_file: 輸出Excel文件路徑
        sheet_name: Excel sheet名稱
        encoding: 文件編碼
    """
    wb = Workbook()
    ws = wb.active
    ws.title = sheet_name

    with open(csv_file, 'r', encoding=encoding) as f:
        csv_reader = csv.reader(f)
        for row_idx, row in enumerate(csv_reader, 1):
            for col_idx, value in enumerate(row, 1):
                ws.cell(row=row_idx, column=col_idx, value=value)

    wb.save(excel_file)
    print(f"? 轉(zhuǎn)換完成: {excel_file}")

# 使用示例
csv_to_excel('data.csv', 'output.xlsx')

import pandas as pd
from openpyxl import load_workbook
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side

def csv_to_excel_pro(csv_file, excel_file, sheet_name='Sheet1'):
    """
    將CSV轉(zhuǎn)換為格式化的Excel（專業(yè)級）
    """
    # 第一步：使用pandas讀取CSV
    df = pd.read_csv(csv_file)

    # 第二步：用pandas寫入Excel
    df.to_excel(excel_file, sheet_name=sheet_name, index=False)

    # 第三步：使用openpyxl美化樣式
    wb = load_workbook(excel_file)
    ws = wb.active

    # 定義樣式
    header_fill = PatternFill(start_color='366092', end_color='366092', fill_type='solid')
    header_font = Font(bold=True, color='FFFFFF', size=12)
    header_alignment = Alignment(horizontal='center', vertical='center', wrap_text=True)

    border = Border(
        left=Side(style='thin'),
        right=Side(style='thin'),
        top=Side(style='thin'),
        bottom=Side(style='thin')
    )

    # 應(yīng)用樣式到所有單元格
    for row in ws.iter_rows(min_row=1, max_row=ws.max_row, min_col=1, max_col=ws.max_column):
        for cell in row:
            cell.border = border
            cell.alignment = Alignment(horizontal='left', vertical='center', wrap_text=True)

            # 特殊處理頭行
            if cell.row == 1:
                cell.fill = header_fill
                cell.font = header_font
                cell.alignment = header_alignment

    # 自適應(yīng)列寬
    for column in ws.columns:
        max_length = 0
        column_letter = column[0].column_letter
        for cell in column:
            try:
                if len(str(cell.value)) > max_length:
                    max_length = len(str(cell.value))
            except:
                pass
        adjusted_width = min(max_length + 2, 50)
        ws.column_dimensions[column_letter].width = adjusted_width

    # 凍結(jié)首行
    ws.freeze_panes = 'A2'

    wb.save(excel_file)
    print(f"? 專業(yè)級轉(zhuǎn)換完成: {excel_file}")
    print(f"?? 數(shù)據(jù)量: {len(df)} 行 × {len(df.columns)} 列")

# 使用示例
csv_to_excel_pro('data.csv', 'output.xlsx', sheet_name='數(shù)據(jù)')

# pandas（包含Excel支持）
pip install pandas openpyxl

# 僅xlsxwriter
pip install xlsxwriter

# 僅openpyxl
pip install openpyxl

# 使用encoding參數(shù)指定編碼
df = pd.read_csv('data.csv', encoding='gbk')  # 或 utf-8, gb2312

# 方案1：使用xlsxwriter（流式寫入）
# 方案2：分塊處理
chunks = pd.read_csv('data.csv', chunksize=10000)
for chunk in chunks:
    chunk.to_excel('output.xlsx', mode='a')

# 指定dtype
df = pd.read_csv('data.csv', dtype={'ID': str, '金額': float})

import glob
import pandas as pd

# 讀取所有CSV文件
csv_files = glob.glob('*.csv')

with pd.ExcelWriter('merged.xlsx') as writer:
    for csv_file in csv_files:
        df = pd.read_csv(csv_file)
        sheet_name = csv_file.replace('.csv', '')
        df.to_excel(writer, sheet_name=sheet_name, index=False)

# 轉(zhuǎn)換前檢查
assert not df.isnull().any().any(), "存在空值"
assert len(df) > 0, "數(shù)據(jù)為空"

try:
    df = pd.read_csv('data.csv')
    df.to_excel('output.xlsx', index=False)
except FileNotFoundError:
    print("? 文件不存在")
except Exception as e:
    print(f"? 轉(zhuǎn)換失敗: {e}")

import logging
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)
logger.info(f"成功轉(zhuǎn)換 {len(df)} 行數(shù)據(jù)")