How to set column width in google sheets using google-spreadsheet (nodejs)?

• 0
  How to set column width and style cells (font size, color, background)?
  
  

  const sheet = await doc.addSheet({sheetId: 123123354, title: `Tracking - ${new Date().toLocaleDateString()}`, headerValues: rowHeaders});
  
    const users = await userRating.find({level: {$in: trackingLevels}}, {"sort":{"progress": -1}});
  
    for (let user of users) {
  
        await sheet.addRows([
          {
            'id': user.userId,
            'Уровень': user.level,
            'Прогресс': user.progress,
          }
        ]);
    }

  JavaScript Anonymous, Sep 10, 2019

---

0 Answers