//Create tab if it does not exist public void CreateTab(string tab) { // Add new Sheet string sheetName = string.Format(tab); var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, this.sheetID); try { batchUpdateRequest.Execute(); } catch { } }
public static void CreateSheet(string sheetName) { if (Service .Spreadsheets .Get(SpreadsheetId) .Execute() .Sheets .Select(x => x.Properties.Title) .Contains(sheetName)) { return; } var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = Service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, SpreadsheetId); batchUpdateRequest.Execute(); }
public BatchUpdateSpreadsheetResponse CreateSheet(string sheetName) { String spreadsheetId = "13CwpWvOWW1B-lyB_kzzvcCeQPukM5AgGoZ32l7bl5e4"; var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = Service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); try { var res = batchUpdateRequest.Execute(); return(res); } catch { } return(null); }
public static void CreateSheet(string sheetName) { var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; var updateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest() { Requests = new List <Request>() }; updateSpreadsheetRequest.Requests.Add( new Request { AddSheet = addSheetRequest, }); _service.Spreadsheets.BatchUpdate(updateSpreadsheetRequest, _spreadsheetId).Execute(); var valueRange = new ValueRange() { Values = new List <IList <object> >() { new List <object>() { "Сервер", "База данных", "Размер в ГБ", "Дата обновления" } } }; var updateRequest = _service.Spreadsheets.Values.Update(valueRange, _spreadsheetId, $"{sheetName}!A1:4"); updateRequest.ValueInputOption = SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.RAW; updateRequest.Execute(); }
public bool CreateTable(string spreadsheetId, string sheetName) { // Create Google Sheets API service. var service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); return(true); }
public string UpdateTab(string guildname) { GoogleConnection(); log.Info("Google Sheets connection successful."); // Add new Sheet string sheetName = string.Format("{0}/{1}/{2} {3}", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, guildname); _sheetname = sheetName; var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = _sheetsService.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, _spreadsheetId); BatchUpdateSpreadsheetResponse response = batchUpdateRequest.Execute(); return(JsonConvert.SerializeObject(response)); }
/// <summary> /// 創建一張工作表 /// </summary> private void CreateV4Sheets() { SheetsService sheetsService = new SheetsService(new BaseClientService.Initializer { HttpClientInitializer = GetCredential(), ApplicationName = "Get Google SheetData with Google Sheets API", }); // Add new Sheet var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = sheetsService.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); }
/// <summary> /// adds blank tab specified by SheetName to spreadsheet /// </summary> /// <param name="SpreadSheetID"></param> /// <param name="SheetName"></param> public static void AddTabToSpreadSheet(string SpreadSheetID, string SheetName) { var service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = GetCredential(), ApplicationName = ApplicationName, }); // Add new Sheet var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = SheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, SpreadSheetID); batchUpdateRequest.Execute(); }
// Add internal static SpreadsheetsResource.BatchUpdateRequest GetAddSheetRequest(SheetsService sheetsService, string spreadsheetId, string sheetTitleId, int columnCount, int rowCount) { // Create new add sheet partial request AddSheetRequest addSheetRequest = new AddSheetRequest(); // Create and assign instance of SheetProperties class into the addSheetRequest. addSheetRequest.Properties = new SheetProperties(); // Set sheet title id. addSheetRequest.Properties.Title = sheetTitleId; // Create new sheet grid properties, and set number of columns and rows according the provided columnCount and row count property. addSheetRequest.Properties.GridProperties = new GridProperties(); addSheetRequest.Properties.GridProperties.ColumnCount = columnCount; addSheetRequest.Properties.GridProperties.RowCount = rowCount; // Create new instance of BatchUpdateSpreadsheetRequest, data of the to be returned instance of SpreadsheetsResource.BatchUpdateRequest .. BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequestData = new BatchUpdateSpreadsheetRequest(); // .. initialize new list of partial requests .. batchUpdateSpreadsheetRequestData.Requests = new List <Request>(); // .. and add sheet partial request to it. batchUpdateSpreadsheetRequestData.Requests.Add(new Request { AddSheet = addSheetRequest }); // Set ResponseIncludeGridData flag to false to increase performance. batchUpdateSpreadsheetRequestData.ResponseIncludeGridData = false; // Construct and return SpreadsheetsResource.BatchUpdateRequest. return(sheetsService.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequestData, spreadsheetId)); }
/// <summary> /// Creates a request to create a new tab within a sheets doc /// <para></para> /// THROWS: InvalidOperationException /// </summary> /// <param name="spreadsheetId">The id of the sheets doc to create a tab in</param> /// <param name="tabName">The name of the tab to be created</param> /// <param name="size">The size in cells the created tab will be</param> /// <param name="targetIndex">The location in the tabs list the created tab will be placed</param> /// <returns></returns> private static Request requestCreateNewTab(string spreadsheetId, string tabName, Size size, int?targetIndex) { if (tabExists(spreadsheetId, tabName) == true) { throw new InvalidOperationException(m_errorTabAlreadyExists); } // create a request of the type you want AddSheetRequest addSheet = new AddSheetRequest(); // create a new properties object for it addSheet.Properties = new SheetProperties(); // set the values of the properties for this request addSheet.Properties.Title = tabName; addSheet.Properties.Index = targetIndex; addSheet.Properties.GridProperties = new GridProperties(); addSheet.Properties.GridProperties.ColumnCount = size.Width; addSheet.Properties.GridProperties.RowCount = size.Height; // create a new base request object Request request = new Request(); // apply the request to it's type in the base request request.AddSheet = addSheet; return(request); }
public static void CreateList(string sheetName, string[] properties) { if (!CheckMissingListName(sheetName)) { throw new ArgumentException(); } var addSheetRequest = new AddSheetRequest { Properties = new SheetProperties { Title = sheetName } }; var batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest { Requests = new List <Request> { new Request { AddSheet = addSheetRequest } } }; var batchUpdateRequest = Service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, SpreadsheetId); batchUpdateRequest.Execute(); /*var properties = ParseProperties(GetDataFromList("Properties", "!A2:A7"));*/ AppendList(sheetName, properties); }
protected void AddNewSheet(string title, int?sheetId, params string[] headings) { var addSheetRequest = new AddSheetRequest { Properties = new SheetProperties { Title = title, SheetId = sheetId, Index = 1, // The presumes we will add sheets in reverse order GridProperties = new GridProperties { FrozenRowCount = 1 }, } }; var row = headings.ToRowData(); var updateRequest = new UpdateCellsRequest { Range = new GridRange { SheetId = sheetId, StartColumnIndex = 0, StartRowIndex = 0, EndColumnIndex = headings.Length, EndRowIndex = 1 }, Rows = new List <RowData> { row }, Fields = "userEnteredValue" }; _requests.Add(new Request { AddSheet = addSheetRequest }); _requests.Add(new Request { UpdateCells = updateRequest }); }
public static void AddSheetAtParticularIndex(string sheetName, int index, IUoW uow, int clientId, string sheetId, int apiKeySecretId = 20, int accountTypeId = 27) { try { var service = GetGoogleSpreadSheetService(uow, clientId, sheetId, apiKeySecretId, accountTypeId); // Add new Sheet var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; addSheetRequest.Properties.Index = index; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, sheetId); var response = batchUpdateRequest.Execute(); } catch (Exception ex) { throw; } }
public void MakeSheetExistAndVisible(string sheetName) { var spreadsheets = Service.Spreadsheets.Get(SheetId).Execute(); var sheet = spreadsheets.Sheets.FirstOrDefault(x => x.Properties.Title == sheetName); if (sheet == null) { AddSheetRequest request = new AddSheetRequest { Properties = new SheetProperties { Hidden = false, Title = sheetName } }; var batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest { Requests = new List <Request> { new Request { AddSheet = request } } }; Service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, SheetId).Execute(); } else { if (sheet.Properties.Hidden.HasValue && sheet.Properties.Hidden.Value) { var newProperties = sheet.Properties; newProperties.Hidden = false; UpdateSheetPropertiesRequest request = new UpdateSheetPropertiesRequest { Properties = newProperties, Fields = "*" }; var batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest { Requests = new List <Request> { new Request { UpdateSheetProperties = request } } }; Service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, SheetId).Execute(); } } }
public async Task CreateSheet(string title, string ssid) { var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = title; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = await this._service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, ssid).ExecuteAsync(); }
private void AddSheet(string name) { var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = name; var batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var req = _sheets.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, _ownSpreadsheetId); req.Execute(); }
public void CreateSheets(string SpreadsheetId, List <string> ListServer, IList <IServerObj> servers, SheetsService sheetService) { Console.WriteLine("Количество не найденых листов: {0}\nНачинается добавление недостающих листов...", ListServer.Count); foreach (var sheetName in ListServer) { var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = sheetService.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, SpreadsheetId); try { batchUpdateRequest.Execute(); } catch (Exception e) { Console.WriteLine("Ошибка: Не удается соединится с google api, лист в таблице не создан.", e.Message); workFiles.WriteFileTxt(servers); Console.WriteLine("Данные записаны в файл: {0}, в корневой папке программы.\nНажмите любую кнопку для закрытия программы.", ConfigurationManager.AppSettings["PathFileTxt"]); Console.ReadKey(); Environment.Exit(1); } } IList <IServerObj> newServers = new List <IServerObj>(); for (int a = 0; a < ListServer.Count; a++) { foreach (var _servers in servers) { if (ListServer[a].ToString() == _servers.NameServer) { newServers.Add(_servers); } } } writerSheets.WriteSheet(SpreadsheetId, newServers, sheetService); }
public (bool justCreated, bool hasError, string message) CheckOrCreateSheet(string sheetName, int sheetIndex, string sheetId) { try { //Get spreadsheet and check if sheet exist or not Spreadsheet spreadsheet = _service.Spreadsheets.Get(sheetId).Execute(); Sheet sheet = spreadsheet.Sheets.Where(s => s.Properties.Title == sheetName).FirstOrDefault(); // if sheet is not available create new sheet at specified index if (sheet == null) { var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; addSheetRequest.Properties.Index = sheetIndex; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = _service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, sheetId); var response = batchUpdateRequest.Execute(); return(justCreated : true, hasError : false, message : "New sheet created successfully"); } else { // checking if it has headers or not assuming first row is header var header = _service.Spreadsheets.Values.Get(sheetId, $"{sheetName}!1:1").Execute(); var valvalues = header.Values; if (valvalues == null || valvalues.Count == 0) { return(justCreated : true, hasError : false, message : "Existing sheet without header"); } } return(justCreated : false, hasError : false, message : ""); } catch (Exception ex) { return(justCreated : true, hasError : true, message : ex.Message); } }
private void CreateLogSheet(SheetsService service) { // Only run this the first time if (!_First) { return; } _First = false; var thisSpreadsheet = service.Spreadsheets.Get(Spreadsheet).Execute(); if (!thisSpreadsheet.Sheets.Any(s => s.Properties.Title == "PixelBotLog")) { var newSheetRequest = new AddSheetRequest() { Properties = new SheetProperties { Title = "PixelBotLog" } }; service.Spreadsheets.BatchUpdate( new BatchUpdateSpreadsheetRequest { Requests = new[] { new Request { AddSheet = newSheetRequest } } }, Spreadsheet).Execute(); var newRecords = new List <IList <object> >(); var newRow = new List <object>(); newRow.Add("Date"); newRow.Add("Acting User"); newRow.Add("Record Updated"); newRow.Add("Command"); newRow.Add("Pixels Changed"); newRecords.Add(newRow); AppendRequest appendRequest = service.Spreadsheets.Values.Append(new ValueRange { Values = newRecords }, Spreadsheet, "PixelBotLog!A1:E"); appendRequest.InsertDataOption = AppendRequest.InsertDataOptionEnum.INSERTROWS; appendRequest.ValueInputOption = AppendRequest.ValueInputOptionEnum.USERENTERED; _ = appendRequest.Execute(); } }
internal void SheetNewSheet() { var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = "Awesome Sheet"; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); }
private static AddSheetRequest GetAddSheetRequest(int sheetId, int branchesCount) { var addSheetRequest = new AddSheetRequest { Properties = new SheetProperties { Title = DateTime.Now.ToString("dd.MM.yyyy_hh:mm:ss"), SheetId = sheetId, Index = 0, GridProperties = new GridProperties { ColumnCount = 5, RowCount = branchesCount + 1, FrozenRowCount = 1 //note: +1 row for header /as } } }; return(addSheetRequest); }
private void CreateNewSheet(SheetsService service, string filename, string spreadsheetId) { try { string range = filename + "!A1:B1"; ValueRange body = new ValueRange(); List <IList <object> > values = new List <IList <object> >(); body.Values = values; SpreadsheetsResource.ValuesResource.UpdateRequest response = service.Spreadsheets.Values.Update(body, spreadsheetId, range); response.ValueInputOption = SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.USERENTERED; response.Execute(); } catch (Exception) { var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = filename; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); MergeCellsRequest mergeCells = new MergeCellsRequest(); GridRange gridRange = new GridRange(); gridRange.SheetId = 2; gridRange.StartColumnIndex = 7; gridRange.EndColumnIndex = 9; gridRange.StartRowIndex = 1; gridRange.EndRowIndex = 1; mergeCells.Range = gridRange; batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest //MergeCells = mergeCells }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); AddHeaderToSheet(service, spreadsheetId, filename); } }
private void DeleteAllSheets(SheetsService service, string spreadsheetId) { var SheetRequest = new List <DeleteSheetRequest>(); var ssRequest = service.Spreadsheets.Get(spreadsheetId); Spreadsheet ss = ssRequest.Execute(); foreach (Sheet sheet in ss.Sheets) { SheetRequest.Add(new DeleteSheetRequest() { SheetId = sheet.Properties.SheetId }); } var addSheetRequest = new AddSheetRequest() { }; addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = "Time"; addSheetRequest.Properties.SheetId = 1337228; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); foreach (var e in SheetRequest) { batchUpdateSpreadsheetRequest.Requests.Add(new Request { DeleteSheet = e }); } batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); }
// Создание листа в таблице private void createSheets(string sheetName) { var sheetRequest = new AddSheetRequest(); sheetRequest.Properties = new SheetProperties { Title = sheetName }; var sheetsUpdate = new BatchUpdateSpreadsheetRequest(); sheetsUpdate.Requests = new List <Request>(); sheetsUpdate.Requests.Add(new Request { AddSheet = sheetRequest }); _service.Spreadsheets.BatchUpdate(sheetsUpdate, _spreadSheetId).Execute(); }
static void _myCreateSheet(string sheetName) // метод создающий лист с заданным именем sheetName // он нам нам понадобится в _myCreteSheetsWithServerName // когда будут создаваться лист с именем как у Server { var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = _myService.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, _mySpreadsheetId); batchUpdateRequest.Execute(); }
public void Create(SheetsService service, string spreadsheetId, string server_name) { //Создание листа с именем сервера(хоста) var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = server_name; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); }
public static void AddSheet(SheetsService service, string spreadsheetId, string sheetName) { string new_sheetName = sheetName; var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = new_sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); Console.WriteLine(DateTime.Now.ToString() + ": New sheet created for server {0}", sheetName); }
/** * Метод создания нового листа * @sheetName - название листа таблицы **/ public void CreateNewSheet(string sheetName) { var newSheetRequest = new AddSheetRequest(); newSheetRequest.Properties = new SheetProperties(); newSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest SpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); SpreadsheetRequest.Requests = new List <Request>(); SpreadsheetRequest.Requests.Add(new Request { AddSheet = newSheetRequest }); var request = service.Spreadsheets.BatchUpdate(SpreadsheetRequest, SpreadSheetID); request.Execute(); CreateEntries(sheetName, new List <object>() { "Сервер", "База данных", "Размер в ГБ", "дата обновления" }); }
public void CreateSheet(string spreadsheetId, string sheetName) { var sheetService = GetSheetsService(); // Add new Sheet var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = sheetName; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = sheetService.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); }
public void InitialSheet(string workSheetName, string spreadsheetId) { var service = AuthorizeGoogleApp(); var addSheetRequest = new AddSheetRequest(); addSheetRequest.Properties = new SheetProperties(); addSheetRequest.Properties.Title = workSheetName; addSheetRequest.Properties.Index = 0; BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest(); batchUpdateSpreadsheetRequest.Requests = new List <Request>(); batchUpdateSpreadsheetRequest.Requests.Add(new Request { AddSheet = addSheetRequest }); var batchUpdateRequest = service.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetId); batchUpdateRequest.Execute(); }