Using EasyPoi export excel file, the template used v_fe horizontal column values, excel cell type is text type, the front will have an exclamation point, to excel statistical computing,

Non v_fe lateral column of the cell can be "n:" will the values in the cell into a numeric type,

Numerical transformation for v_fe how? Ask for help!

CodePudding user response:

Take a look at this: https://blog.csdn.net/miao_x_m/article/details/99696008

CodePudding user response:

reference 1st floor KeepSayingNo response:

take a look at this: https://blog.csdn.net/miao_x_m/article/details/99696008

Link I see, is to use the code for each column of the aggregate,
Although also is a kind of statistics, but the customer wants to export value is numeric types in excel, you can use the excel all statistical and computational expressions, so you have to need to have a way to set the cell after the template export for numerical, thank you so much for referral.