Excel export and comma decimal
-
<font _mstmutation=”1″></font><font _mstmutation=”1″>We are using commas for decimal. If we export numbers with commas, for example 1,59 the number exports as 159. However, if the number has thousands, for example 1.450,45 the number is exports correctly as 1.450,45</font>
In “datatables.net” I have found this solution:
{
?extend: 'excel',
????? exportOptions: {
??????????columns: ':visible',
??????????format: {
???????????body: function(data, row, column, node) {
??????????????data = $('<p>' + data + '</p>').text();
??????????????return $.isNumeric(data.replace(',', '.')) ? data.replace(',', '.') : data;
??????????????}
?????????? }
????? ?}
}But I’d need to know how it would work in my code:
{
"extend": "excelHtml5",
"text": "EXCEL",
"exportOptions": {
"modifier" : {
"order" : "current",
"page" : "all",
"search" : "applied"
}
}
}Is there a way to export what you see on the web to excel?
Thanks
Best regards.
Agruquero.The page I need help with: [log in to see the link]
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
- You must be logged in to reply to this topic.