Create an empty row on html5 Excel
Create an empty row on html5 Excel
jacobruvalcaba
Posts: 10Questions: 6Answers: 0
I am using the button plugin which is great.
I am trying to add an empty row based on a condition, not sure how this would be done.
This is an example
$('row c[r^="A"]', sheet).each( function () {
if ( $('is t', this).text() != cell ) {
// create empty row
// var cell = the new cell
cell = $('is t', this).text();
}
});
This discussion has been closed.
Answers
You need to create the XML structure requires for an XSLX row. What I would suggest is that you take a look at the
rowelement (justconsole.log( $('row', sheet)[0] );) and see how it is constructed. You can then use jQuery or DOM methods to create the new row.Unfortunately, Buttons doesn't expose the function it uses internally to create nodes, although if you are interested, this is where it does.
Allan
Awesome, Thanks for the reply.