openpyxl saved excel file can't be opened in another system
Created originally on Bitbucket by liga810 (Lili)
We have a reporting system which needs to read numbers from an excel file. The excel file is updated by openpyxl everyday. if I just upload the excel file to the reporting system, the system can't read data from excel file. so everyday after processing the excel file, I need to open the file and click 'save' button, then I upload the excel file to the system, and the system can read data now. the excel file I use is 2013. The code is :
#!python
wb = openpyxl.load_workbook('excel_test.xlsx')
ws=wb.get_sheet_by_name('Day')
row_index=1
ws['B1']='hello'
wb.save('excel_test.xlsx')
Attachments: excel_test.xlsx