Excel export font size and borders

Excel export font size and borders

kreso191kreso191 Posts: 5Questions: 5Answers: 0

I want to change font of an Excel export to 13, 14 pt instead of 11, but I don't even know where to start.
I also want to to have thin border on all cells so I did this:

customize: function( xlsx ) {
var sheet = xlsx.xl.worksheets['sheet1.xml'];
$('row c', sheet).attr( 's', '25' );
}

But the thing is that only cells with some sort of data have borders and I don't want to force some characters in empty cells just so they have borders.

Answers

  • RadrenRadren Posts: 1Questions: 0Answers: 0

    Oof, this simple question still haven't answered yet and i have the same problem, but did you find the answer for yourself OP?

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    This thread should help, it's asking the same thing.

    Cheers,

    Colin

This discussion has been closed.