Excel Export: format cells as text

cmdControl

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

allan

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 0 for plain text.

Allan

cmdControl

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

cmdControl

I'm just trying to format rows 3 and greater to have the cells formatted to type "Text"

allan

You need to apply the style to the c tags (cell), so you would use:

$('row c', sheet).attr( 's', '0' );

Allan

cmdControl

@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.

allan

Style 50 perhaps then?

Allan

cmdControl

That worked perfectly! Thank you!