读取Excel表头和行值

import xlrd
from qcloud_cos import CosConfig
from qcloud_cos import CosS3Client

# 配置腾讯云 COS
secret_id = 'YOUR_SECRET_ID'
secret_key = 'YOUR_SECRET_KEY'
region = 'YOUR_REGION'
bucket = 'YOUR_BUCKET'
config = CosConfig(Region=region, SecretId=secret_id, SecretKey=secret_key)
client = CosS3Client(config)

# 下载Excel文件到本地
object_key = 'your-excel-file.xlsx'
local_file_path = 'local-file-path.xlsx'
response = client.get_object(Bucket=bucket, Key=object_key)
response['Body'].get_stream_to_file(local_file_path)

# 读取Excel表头和行值
workbook = xlrd.open_workbook(local_file_path)
sheet = workbook.sheet_by_index(0)

header = []
for col_index in range(sheet.ncols):
    header.append(sheet.cell_value(0, col_index))

rows = []
for row_index in range(1, sheet.nrows):
    row = []
    for col_index in range(sheet.ncols):
        row.append(sheet.cell_value(row_index, col_index))
    rows.append(row)

# 打印表头和行值
print("表头：", header)
print("行值：", rows)

# 清理本地文件
os.remove(local_file_path)