我有一个代码，它应该写在Google工作表的电子表格中。当我运行该函数时，出现以下错误：

  

消息[请求的写作范围为['6/12 / 2019-20：37'！A1]，但   试图写入[B]列]位置[-]原因[badRequest]   域[全局]

那是我的代码：

        private void SheetPattern(Item webinar)
    {
        var valueRange = new ValueRange();
        var range = $"{sheet}!A:D";

        DateTime dateTime=(DateTime)webinar.webInfo.times[0].startTime;
        var date = dateTime.Day+"-"+dateTime.Month+"-"+dateTime.Year;
        var hour = dateTime.Hour + ":" + dateTime.Minute;
        var webName = webinar.webInfo.subject;
        var webDescription = webinar.webInfo.description;

        var oblist = new List<object>() { date,hour,webName,webDescription};

        valueRange.Values = new List<IList<object>> { oblist };

        var appendRequest = service.Spreadsheets.Values.Append(valueRange,SpreadsheetId,range);
        Console.WriteLine(appendRequest);
        appendRequest.ValueInputOption = Spreadsheetsresource.ValuesResource.AppendRequest.ValueInputOptionEnum.USERENTERED;
        var appendReponse = appendRequest.Execute();
    }