/// <summary> /// 更新工作表名稱 /// </summary> public static void UpdateSheetTitle(this SheetsService service, string spreadsheetId, string oldName, string newName) { var sheet = service.GetSheet(spreadsheetId, oldName); if (sheet == null) { throw new NullReferenceException($"Can't find the spreadsheetId {spreadsheetId}, sheetName {oldName}"); } var sheetProperties = new SheetProperties { SheetId = sheet.Properties.SheetId, Title = newName }; var updateSheetPropertiesRequest = new UpdateSheetPropertiesRequest { Properties = sheetProperties, Fields = "title" }; //Create a new request with containing the addSheetRequest and add it to the requestList var request = new Request { UpdateSheetProperties = updateSheetPropertiesRequest }; service.BatchUpdateSpreadsheet(spreadsheetId, request); }
/// <summary> /// 刪除工作表 /// </summary> public static void DeleteSheet(this SheetsService service, string spreadsheetId, string sheetName) { var sheet = service.GetSheet(spreadsheetId, sheetName); if (sheet == null) { throw new NullReferenceException($"Can't find the spreadsheetId {spreadsheetId}, sheetName {sheetName}"); } // 創建刪除Sheet指令 var deleteSheetRequest = new DeleteSheetRequest { SheetId = sheet.Properties.SheetId }; // 創建一個要求 var request = new Request { DeleteSheet = deleteSheetRequest }; // 送出請求 service.BatchUpdateSpreadsheet(spreadsheetId, request); }
public static bool ISheetExist(this SheetsService service, string spreadsheetId, string sheetName) => service.GetSheet(spreadsheetId, sheetName) != null;
public static int?GetSheetId(this SheetsService service, string spreadsheetId, string sheetName) => service.GetSheet(spreadsheetId, sheetName).Properties.SheetId;