Sheets Set Column Width

Here is a workaround to the sheet problem you've encountered.

function to allow me to manually set the size of columns, or add additional spacing to AutoResizeColumn

Additional Code:

headers.forEach((x, i) => {
  sht.setColumnWidth(i + 1, sht.getColumnWidth(i + 1) + 10)
});

Sample Output Before:

Sample Output After:

Reference:

• Class Sheet