/// <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;
