google spreadsheet - Script to wrap range of cells in HTML tags -

i searching simple formatting solution. getvalue(), followed setvalue() same data, wrapped in html tags. , here trouble: can't figure out how range object of cells need , edit them in 1 move. there solution that?

there's lib that! sheetconverter library.

gist here.

here's how html table whole sheet:

var range = spreadsheetapp.getactivesheet().getdatarange(); var htmltable = sheetconverter.convertrange2html(range); 

you'll find other goodies convert ranges arrays of formatted strings, or generate html single cell (including fonts, background colors, text colors, , other formatting elements).

disclosure: i'm library author.