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
Your Answer
To place the code, please use CodePen or similar tool. Thanks you!