Pythonは直接Excelを修正

 

サンプルコード:

import xlrd

from xlutils.copy import copy

def setNewValue(rowIndex,colIndex,newValue):
data = xlrd.open_workbook(inFile)
tmpData = copy(data)
tmpData.get_sheet(0).write(rowIndex,colIndex,newValue)
tmpData.save(“/var/startnews24.xls")

Source

Posted by arkgame