Question : Python save to excel
Answered by : tame-thrush-8s1i0qbxiam3
with pd.ExcelWriter('directory'+'Name of excel file') as writer: Df.to_excel(writer, sheet_name='File_name')
Source : https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_excel.html | Last Update : Wed, 27 Apr 22
Question : write in an xls excel file python
Answered by : armando-flores
{"tags":[{"tag":"textarea","content":"from xlrd import open_workbook\nfrom xlutils.copy import copy\n\nrb = open_workbook(\"file.xls\")\nwb = copy(rb) # Copy read file \ns = wb.get_sheet(0) # Specify sheet of xls file to edit\ns.write(row,column,data_to_insert) # Insert data in a cell in xls file\nwb.save('file.xls') # Save changes in file","code_language":"python"}]}
Source : | Last Update : Fri, 14 Apr 23