public UploadSheetTransaction(SpreadsheetAccess spreadsheetAccess, SheetProperties sheet)
{
this.requestBuilder = spreadsheetAccess.CreateBatchRequestBuilder();
this.sheetId = sheet.SheetId.Value;
var deleteRange = this.requestBuilder.AddDeleteRange(this.sheetId);
deleteRange.Range.StartRowIndex = 1;
deleteRange.Range.EndRowIndex = sheet.GridProperties.RowCount - 1;
var cellsUpdater = this.requestBuilder.AddUpdateCells(this.sheetId);
this.firstRow = cellsUpdater.Rows.AddRow();
this.appender = this.requestBuilder.AddAppendCells(this.sheetId);
this.requestBuilder.AddAutoResizeDimensions(this.sheetId);
this.spreadsheetAccess = spreadsheetAccess;
}
