Copy range from google spreadsheet to google document

Question

Is it possible to copy sheet contents with formatting to google doc? I need to fill doc template with table from spreadsheet like copy and paste. Or to convert sheet to doc with google app script.

Answer 1

Open your files with getFilesByName(name) With getRange(row, column, numRows, numColumns) you can get the data you want And with body.appendTable(rowsData) you can and data to a table in a doc