1

I'm trying to export my table in aggrid into Excel. The amount column is using float dataType. When I export in excel. The cell is correctly formatted as Number, but still the cells shows an error "Number stored as Text" and I would have to manually convert them into number. Can anyone suggest any fix for it.

Improve this question
2
  • Were you able to find any optimal fix for this? Commented Oct 11, 2022 at 9:25
  • @Praveen Yes! Can't remember the correct code, but it was something with the format of data displayed on the aggrid table. In my case, the amount was displayed with comma and that's why even was reading it as string. Commented Oct 13, 2022 at 7:08
Related questions
3
Format cell when exporting to Excel
9
Exporting to excel with proper cell formatting on ag-grid
0
ag-grid export excel api getDataAsExcel
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.