//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();
}
