scientific notation

[luolei100]

how can i set the cell data style . not 123.456E+12

[luolei100]

$nbsp;

[rainabba]

There's not really any style support at this point. XLSX does allow for styling though and I definitely welcome a PR to add that features.

I suggest using Google Sheets to "export" an XLSX with a bold cell and a cell with content not bolded. Then export another one with no bolded content at all (to see if you need to include style markup to be able to add a "bold" style to a cell AND see how).

I'll try to get to this myself in a couple days if nobody gets a PR to me or declares their intention more quickly.

[xiayin1992728]

mid: "</x:ExcelWorksheets></x:ExcelWorkbook><![endif]-->

",

$(this).find("td").each(function() { if(!$(this).is(".noExl")){ tempColum += "

" +$(this).html()+ ""; } });

[xiayin1992728]

tempColum += "

" +$(this).html()+ "";

[xiayin1992728]

tempColum +=

"" +$(this).html()+ "";

[xiayin1992728]

tempColum += "" +$(this).html()+ "";

[xiayin1992728]

``tempColum += "

" +$(this).html()+ "";

[xiayin1992728]

tempColum += "<td class='format'>" +$(this).html()+ "</td>";

[Zephyr-co]

if (additionalStyles) {
                            tempRows += "style= mso-number-format:\"\@\";"
                                + additionalStyles + "'";
                        } else {
                            tempRows += " style= mso-number-format:\"\@\";"
                        }

you can set style,i set style defult text;