如何在Google Cloud Storage上创建和写入XLSX文件

import openpyxl
from google.cloud import storage

# 设置Google Cloud Storage存储桶和文件名
bucket_name = "your_bucket_name"
file_name = "your_file_name.xlsx"

# 创建一个工作簿对象
workbook = openpyxl.Workbook()

# 创建一个工作表对象
sheet = workbook.active

# 写入数据到工作表
sheet["A1"] = "Hello"
sheet["B1"] = "World"

# 保存工作簿到本地临时文件
temp_file = "/tmp/temp.xlsx"
workbook.save(temp_file)

# 上传临时文件到Google Cloud Storage
client = storage.Client()
bucket = client.get_bucket(bucket_name)
blob = bucket.blob(file_name)
blob.upload_from_filename(temp_file)

# 删除本地临时文件
os.remove(temp_file)