Export excel file data format error

Hello, when i download file as excel, if some colomn data type is number, in excel type will covert type to “None” or “str”. How to keep the original data type of the downloaded file?

This picture shows that it cannot be summed!

If data type is number, i can sum data like this:


So this problem is a bug? Thank you!

I don’t think this is supported. The Excel download just takes the query result, which is a JSON string, and converts it to an Excel file. The data types are “guessed” by the front-end but the API always returns them as text. To retain the types you’d need to add type “guessing” to the Excel download code.

Ok, thank you, i will try to do it.


peter lee



Signature is customized by Netease Mail Master