Excel Export: format cells as text
Excel Export: format cells as text
cmdControl
Posts: 11Questions: 3Answers: 0
When I export the data into the excel file, it will import data ( I am forcing the data to type "string" via columnDefs: [ {type:'string', targets: '_all'}, [...] } ) correctly so if there are numbers with leading zeroes, it seems to keep them as strings; however, if there is a number of type string with no leading zeroes, excel will read display the value in a cell of format "Number".
My question is if there is a way, when extending button 'excelHtml5', to force format the excel cells to type "text"?
Thank you
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Yes, this example shows how you can set a style for the cells in the spreadsheet. The built in styles are shown here. Use style
0for plain text.Allan
Am I to understand that if I want to format all rows as text, I can just run this?
$('row', sheet).each( function () {$(this).attr( 's', '0' );});Because it still sets the cell as a "general" rather than forcing it to text
I'm just trying to format rows 3 and greater to have the cells formatted to type "Text"
You need to apply the style to the
ctags (cell), so you would use:Allan
@allan
I used this but the excel cells becomes "General" format which then continues to adapt depending on the values in each cell ( "0001" as text; "100" as number) and I need these all forced to be text format.
Style
50perhaps then?Allan
That worked perfectly! Thank you!