search

rainabba / jquery-table2excel

jQuery Plugin to export HTML tabled to Excel Spreadsheet Compatible Files
592 stars 665 forks source link

when table content having phone no then excel sheet don't show it properly #112

Open amitjoc opened 5 years ago

amitjoc commented 5 years ago

my table having phone no in the format +91-9999999999

but when exported then it show it wrong inside the excel sheet like -9999999999

but when i click the cell in formula bar it shows the =91-9999999999

rainabba commented 5 years ago

By US standards, that's not a phone number, and to excel it would look like a partial formula, "+ 91 - 999999999".

The only thing you can do right now is update the format in Excel after opening. Long term, we have to figure out a way to decorate and parse format in with other such features.