Loading

problem while exporting from asp.net mvc to excell

Cedric Soum

8y768.NET

good morning everyone.

i am trying to export a table from my asp.net view to excel.

i used a method i saw in c-sharpcorner here.

the problem is when i export the document in excel file, the cells where the formulas are applied display like this:

#NOM?

so i have to click on the cell then press enter in the formula bar.

after looking for a solution in the web i didn't a correct one.

this what my code looks like for a cell:

thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar8y ago
Could you please provide more detail on question and output like which kind of coulmn numeric, text or any formula ?
Rupesh Kahane8y ago
try below solutions
1) https://www.c-sharpcorner.com/article/export-data-in-excel-file-with-asp-net-mvc/
2) https://www.c-sharpcorner.com/article/export-to-excel-in-asp-net-mvc/
3) https://www.codeproject.com/articles/325103/mvc-grid-to-excel-file-download
4) https://jsfiddle.net/lesson8/jWAJ7/