Guriddo » Topic: Excel export and $ (excel parser) error in exported file

Excel export and $ (excel parser) error in exported file

Guriddo
Excel export and $ (excel parser) error in exported file

This topic has 2 replies, 2 voices, and was last updated 3 years, 11 months ago by krisreddy.

Creator

Topic
January 13, 2021 at 9:34 pm #127552

krisreddy
Participant

Hello,

Please check the example below

http://50.53.74.215:90/jqgrid/gridExportHtml.php

When you click export to excel and option the excel file it produces an error and $ sign is not formatted.

Please advise,

Kris

Guriddo customer
Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies

January 14, 2021 at 1:08 pm #127553

guriddo.support

Participant

Hello,

In your replace_format function for that field you will need to replace the comma too in order excel to parse the data correct.

...
{name:'curSalePrice',index:'curSalePrice',width:65,align:"right",search:false,formatter:'currency'
            ,formatoptions:{decimalSeparator:'.',thousandsSeparator: ',',decimalPlaces:2,prefix:'$'}
            ,exportoptions:{excel_parsers:false,excel_format:"[$$-45C]\#,##0.00_-",replace_format:function(v){return v.replace('$','').replace(',','');}}
...

...

{name:'curSalePrice',index:'curSalePrice',width:65,align:"right",search:false,formatter:'currency'

,formatoptions:{decimalSeparator:'.',thousandsSeparator: ',',decimalPlaces:2,prefix:'$'}

,exportoptions:{excel_parsers:false,excel_format:"[$$-45C]\#,##0.00_-",replace_format:function(v){return v.replace('$','').replace(',','');}}

...

Kind Regards,
Will

Guriddo Support Team

January 14, 2021 at 5:03 pm #127554

krisreddy

Participant

As always, Thank you Will!

Author

Replies

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Registered Users: 12,253
Forums: 7
Topics: 10,948
Replies: 23,146
Topic Tags: 324
Empty Topic Tags: 9

21 Users Online

Users: 5 Guests, 16 Bots

Stay connected with us in your favorite flavor!

Excel export and $ (excel parser) error in exported file

Search Forum

Recent Replies

Forum Statistics

UserOnline