Python(Pandas/XlsxWriter)を使ってExcelファイルを操作してみる① - Qiita# import lib import pandas as pd import numpy as np # create data dates = pd.date_range("20130101", freq='D', periods=6) df = pd.DataFrame(np.random.randn(6,4),index = dates, columns = list("ABCD")) # set data fileName = "hoge.xlsx" writer = pd.ExcelWriter(fileName) df.to_excel(writer, sheet_name="hoge1") df.T.to_excel(writer, sheet_name="hoge2") workbook = writer.book worksheet1 = writer.sheets['
pythonでオフィス快適化計画
