Add Static Worksheet to Excel html5 Export

jlock

I am making many customizations to my excel export and need to have the workbook contain a second worksheet. I want to include 4 rows of data and was thinking it might be done through the customize option. Does anyone know how to do this? I am not good at jquery!

data I want to add to a new worksheet called Report Info

var r1 = Addrow(1, [{ key: 'A', value: 'Report Name:' }, { key: 'B', value: 'List' }]);
var r2 = Addrow(2, [{ key: 'A', value: 'Related to:' }, { key: 'B', value: 'Selection' }]);                          
var r3 = Addrow(3, [{ key: 'A', value: 'User:' }, { key: 'B', value: 'User' }]);
var r4 = Addrow(4, [{ key: 'A', value: 'Date:' }, { key: 'B', value: 'Date' }]);            
var r5 = Addrow(5, [{ key: 'A', value: '' }, { key: 'B', value: '' }]);        

jlock

@F12Magic you have posted a lot of helpful code, can you write something to add a second worksheet?

F12Magic

@jlock I'll try to make an example and post it on codepen. Could take a couple of days since I don't have much time lately. Watch out for another reply in this thread.

jlock

Thank you @F12Magic

I should add that the second worksheet is not going to pull from the datatable. I would be setting the text of the cell through jquery.

F12Magic

Okay @jlock . This was new for me too.
After some attempts, I've got an excel file with a second static worksheet, without errors when opening. The complete example is on Codepen.
Hope you can do something with it.

jlock

This is perfect, thank you so much! I owe you! I hope others find this useful as well.