SheetConverter merged and wrapped cells not being

2019-08-23 09:04发布

问题:

Good morning,

I am using the library SheetConverter to convert a range in my google spreadsheet into an html body in my email. Mostly it works perfectly! However, I have some merged cells that create some titles, and it seems the merged-ness of them gets lost using SheetConverter's method 'ConvertRange2html'. Anybody know how I could fix this? The relevant code:

sig= Gmail.Users.Settings.SendAs.list("me").sendAs.filter(function(account){if(!account.isDefault){return true}})[0].signature;
htmlRange = SheetConverter.convertRange2html(range);
fullBody = htmlRange+"<br><br>--<br><br></p>"+sig;
GmailApp.createDraft(contacts, subject, null,{from:"test@example.com", cc: cc, htmlBody: fullBody}); 

I have attached an image of the result: I'd like the first two rows to be merged so that the paragraph is more cleanly spread out, and also so that the empty cells are not there. I have also attached an example of what we email currently by copy and pasting from the spreadsheet.

What gets generated now below:

This is the ideal one below: