I tried to add sheet[cell_ref].t = 'n' to set a cell's type to number . It worked out in WPS ,But it went wrong in microsoft excel .When opened in microsoft excel, an error mesage pop up saying "Something went wrong in xxx.xlsx, would you like to recovery it...."Is there any method to deal with this problem?
Janet-wj
commented
3 years ago
I tried to add sheet[cell_ref].t = 'n' to set a cell's type to number . It worked out in WPS ,But it went wrong in microsoft excel .When opened in microsoft excel, an error mesage pop up saying "Something went wrong in xxx.xlsx, would you like to recovery it...."Is there any method to deal with this problem?