search

rainabba / jquery-table2excel

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

消除科学计数 #113

Open yudaobin opened 5 years ago

yudaobin commented 5 years ago

比如身份号，excel怎么消除科学计数法，只展示字符串？

mouqianxi commented 3 years ago

js文件里这段判断一下，字段长度和是否为纯数字

if (rc.rows & rc.cols) { if ($(q).html().length > 11 && !isNaN($(q).html())) { tempRows += "" + $(q).html() + ""; } else { tempRows += "" + $(q).html() + ""; }
} else { if ($(q).html().length > 11 && !isNaN($(q).html())) { tempRows += "<td style='mso-number-format:\"\@\"'"; } else { tempRows += "<td"; } if( rc.rows > 0) { tempRows += " rowspan=\'" + rc.rows + "\' "; } if( rc.cols > 0) { tempRows += " colspan=\'" + rc.cols + "\' "; } tempRows += "/>" + $(q).html() + ""; }