Question

I m 采用国家预防机制的“google-spreadsheet”项目。

When I add some rows with the .addRows() command, sometimes the format is converted by Google sheet (like phone number). I would like to add the values with the format I wanted ;)

这是我法典的摘录。

我想在文字中写到,电话栏号——号码应是纯文本。

const { GoogleSpreadsheet } = require( google-spreadsheet );
const GS_creds= require( ../xxxxxx.json );
const GS_concertannuel = new GoogleSpreadsheet( yyyyyyyyy );
await GS_concertannuel.useServiceAccountAuth(GS_creds);
await GS_concertannuel.loadInfo();
const GS_CA_tab_hebergements = GS_concertannuel.sheetsByTitle[ hebergements ];
const ajout_gs_hebergements = GS_CA_tab_hebergements.addRows([{
                 identifiant : myIdentifiant,
                 phone_number : myPhoneNumber // 0909090909
            }]);

一、导言

INPUT: 我在数据库中的电话号码是0909090909。

OUTPUT : The phone number copied in the Google Sheet with google-spreadsheet is 909090909 (without the first 0). The OUTPUT I would like is 0909090909, that means in string format and not number.

I read the documentation, but I don t understand. (https://theoephraim.github.io/node-google-spreadsheet/#/).

尽管有广告 “最受欢迎的谷歌谢斯普西特/字母”文本,我没有在互联网上找到许多信息。

我可以尝试过国际仲裁机构。我先是奶粉;

谢谢你。

Answer 1

In your situation, as a simple modification, how about the following modification?

From:

const ajout_gs_hebergements = GS_CA_tab_hebergements.addRows([{
                 identifiant : myIdentifiant,
                 phone_number : myPhoneNumber // 0909090909
            }]);

To:

const ajout_gs_hebergements = GS_CA_tab_hebergements.addRows(
   [
     {
       identifiant: myIdentifiant,
       phone_number: myPhoneNumber, // 0909090909
     },
   ],
   { raw: true }
 );

或

const ajout_gs_hebergements = GS_CA_tab_hebergements.addRows(
   [
     {
       identifiant: myIdentifiant,
       phone_number: " " + myPhoneNumber, // 0909090909
     },
   ]
 );

I thought that the reason f或 your current issue is due to By this modification, the value is put as a text.

Reference:

addRow(rowValues, options)

From:

To:

Reference:

友情链接