/// <summary>
/// Очистка листа от старой информации
/// </summary>
/// <param name="sheet"></param>
void ClearSheet(string sheet)
{
string range = string.Format("'{0}'!A1:Z", sheet);
ClearValuesRequest requestBody = new ClearValuesRequest();
sheetsService.Spreadsheets.Values.Clear(requestBody, SpreadsheetsId, range).Execute();
}
private void RemoveEntry(string SpreadSheet, List <object> objectArray)
{
ValueRange values = GetValues(SpreadSheet);
int i = 1;
bool hasBeenSet = false;
foreach (IList <object> row in values.Values.Skip(1))
{
i++;
if (row[0].ToString() == objectArray[0].ToString())
{
hasBeenSet = true; break;
}
}
if (!hasBeenSet)
{
return;
}
string range = $"{SpreadSheet}!A{i}:Z{i}";
ClearValuesRequest valueRange = new ClearValuesRequest();
SpreadsheetsResource.ValuesResource.ClearRequest clearRequest = service.Spreadsheets.Values.Clear(valueRange, SpreadSheetID, range);
ClearValuesResponse updateRespond = clearRequest.Execute();
}
void DaiLy()
{
string range1 = $"Đại lý!A:B";
var valueRange = new ValueRange();
var requestbody = new ClearValuesRequest();
var request1 = SService.Spreadsheets.Values.Clear(requestbody, SpreadsheetId, range1);
request1.Execute();
List <IList <object> > lstList = new List <IList <object> >();
for (int i = 0; i < lstDaiLy.Count; i++)
{
var objectList = new List <object>()
{
lstDaiLy[i].Ten, (i < lstCTV.Count - 1) ? lstCTV[i].Ten : string.Empty
};
lstList.Add(objectList);
}
valueRange.Values = lstList;
var appendRequest = SService.Spreadsheets.Values.Append(valueRange, SpreadsheetId, range1);
appendRequest.ValueInputOption = SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum.USERENTERED;
appendRequest.Execute();
}
//API Documentation
//Method: deleteData(String range)
//String range: sheetName!ColumnStart:ColumnEnd
//RequestType: Deletes data at range
public void deleteData(String range)
{
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, spreadsheetId, range);
var deleteReponse = deleteRequest.Execute();
}
public void AddData(string spreadsheetId, string range, string[] data)
{
SheetsService sheetsService = Connect();
ClearValuesRequest clearrequestBody = new ClearValuesRequest();
//var result = sheetsService.Spreadsheets.Values.Clear(clearrequestBody, spreadsheetId, "Sheets1!A3:C").Execute();// Append( valueRange, spreadsheetId, "Sheets1!A6").Execute();
ValueRange body = new ValueRange();
List <Object> sub = new List <object>();
sub.Add("qwerewtreytrjy");
List <List <Object> > list1 = new List <List <object> >();
list1.Add(sub);
IList <IList <Object> > values = GetData(spreadsheetId, range);
values.Clear();
values.Add(data);
body.Values = values;
SpreadsheetsResource.ValuesResource.UpdateRequest request1 = sheetsService.Spreadsheets.Values.Update(body, spreadsheetId, range);
request1.ValueInputOption = SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.RAW;
Console.WriteLine(request1.ValueInputOption);
UpdateValuesResponse result = request1.Execute();
Console.WriteLine(JsonConvert.SerializeObject(result));
}
/**
* Метод удаляет последнюю строку на указанном листе
* @sheet - название листа таблицы
* @value - номер строки для удаления
**/
public void DeleteEntry(string sheet, int value)
{
var range = $"{sheet}!A{value}:D{value}";
var request = new ClearValuesRequest();
var delRequest = service.Spreadsheets.Values.Clear(request, SpreadSheetID, range);
var response = delRequest.Execute();
}
public static void AtualizarPlanilha()
{
SpreadsheetsResource.GetRequest get = sheetsService.Spreadsheets.Get(idPlanilha);
planilhas = get.Execute();
valueInputOption = (SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum) 2;
foreach (Sheet planilha in planilhas.Sheets)
{
ClearValuesRequest clearRequest = new ClearValuesRequest();
SpreadsheetsResource.ValuesResource.ClearRequest request = sheetsService.Spreadsheets.Values.Clear(clearRequest, idPlanilha, "!A1:Z1000");
request.Execute();
for (int i = 0; i <= 5; i++)
{
GerarTabelaMesSheet(i);
}
for (int i = 0; i <= 5; i++)
{
GerarTabelaSavingsSheet(i);
}
Layout();
}
}
public void ClearSheetAtRange(string sheetName, string range)
{
ClearValuesRequest requestBody = new ClearValuesRequest();
SpreadsheetsResource.ValuesResource.ClearRequest clearRequest = Service.Spreadsheets.Values.Clear(requestBody, SheetId, GetSheetAndRangeName(sheetName, range));
clearRequest.Execute();
}
public static ClearValuesResponse ClearRange(this SheetsService service, string spreadsheetId, string range)
{
ClearValuesRequest requestBody = new ClearValuesRequest();
var request = service.Spreadsheets.Values.Clear(requestBody, spreadsheetId, range);
return(request.Execute());
}
public static void UpdateEntry()
{
ReadCart();
var range = $"cart!A:C";
var valueRange = new ValueRange();
var oblist = new List <object>()
{
0
};
valueRange.Values = new List <IList <object> > {
oblist
};
ClearValuesRequest requestBody = new ClearValuesRequest();
SpreadsheetsResource.ValuesResource.ClearRequest request =
_service.Spreadsheets.Values.Clear(requestBody, SpreadsheetId, range);
// To execute asynchronously in an async method, replace `request.Execute()` as shown:
ClearValuesResponse response = request.Execute();
// Data.ClearValuesResponse response = await request.ExecuteAsync();
// TODO: Change code below to process the `response` object:
Console.WriteLine(JsonConvert.SerializeObject(response));
}
private void clearColumn(string range)
{
ClearValuesRequest clearRequest = new ClearValuesRequest();
SpreadsheetsResource.ValuesResource.ClearRequest req = service.Spreadsheets.Values.Clear(clearRequest, spreadSheetId, range);
req.Execute();
}
public void Clear(string sheetId, string range)
{
ClearValuesRequest body = new ClearValuesRequest();
SpreadsheetsResource.ValuesResource.ClearRequest clearRequest = _sheetService.Spreadsheets.Values.Clear(body, sheetId, range);
clearRequest.Execute();
}
public static void ClearRow(int rowID, string spreadSheetId)
{
var range = $"{sheet}!A{rowID}:F{rowID}";
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, spreadSheetId, range);
var deleteReponse = deleteRequest.Execute();
}
//Delete data from range of cells
public void DeleteRange(string range)
{
this.range = this.tab + "!" + range;
ClearValuesRequest requestBody = new ClearValuesRequest();
this.service.Spreadsheets.Values.Clear(requestBody, this.sheetID, this.range).Execute();
}
/// <summary>
/// This method deletes entries from the spreadsheet. (untested)
/// </summary>
public static void DeleteEntry(string leftBound, string rightBound, int index)
{
var range = $"{sheets[index]}!{leftBound}:{rightBound}";
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, SpreadsheetID, range);
var deleteResponse = deleteRequest.Execute();
}
//刪除
public void DeleteEntry(string sheet, string Start, string End)
{
var range = $"{sheet}!{Start}:{End}";
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, SpreadsheetId, range);
var deleteReponse = deleteRequest.Execute();
}
public void ClearInvoiceID(int Id)
{
int rowID = Id + 1;
var range = $"{dataSheet}!A{rowID}:D{rowID}";
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, SpreadsheetId, range);
var deleteReponse = deleteRequest.Execute();
}
private void ClearSpreadsheet()
{
string range = "Server List!A1:A255";
ClearValuesRequest requestBody = new ClearValuesRequest();
SpreadsheetsResource.ValuesResource.ClearRequest request = SheetsService.Spreadsheets.Values.Clear(requestBody, spreadsheetId, range);
ClearValuesResponse response = request.Execute();
}
static void deleteEntry()
{
var range = $"{sheet}!A2:F2";
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, sheet_id, range);
var deleteResponse = deleteRequest.Execute();
}
static void DeleteEntry()
{
var range = $"{sheet}!A543:F";
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, SpreadsheetId, range);
var deleteReponse = deleteRequest.Execute();
}
public void ClearValues(string range)
{
var body = new ClearValuesRequest();
SpreadsheetsResource.ValuesResource.ClearRequest request =
_service.Spreadsheets.Values.Clear(body, _sheetId, range);
request.Execute();
}
public void DeleteLastRow(SheetsService service, string SpreadsheetId, int lastRow, string server_name)
{
//Удаляем строку со старыми данными о размере свободного места на диске.
var range = $"{server_name}!A{lastRow}:D";
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, SpreadsheetId, range);
var deleteResponse = deleteRequest.Execute();
}
public static void DeleteEntry()
{
var range = $"{Constants.Sheet}!A7:C";
var requestBody = new ClearValuesRequest();
var deleteRequest = _service.Spreadsheets.Values.Clear(requestBody, Constants.SpreadsheetId, range);
deleteRequest.Execute();
}
public async Task <ClearValuesResponse> Clear(string id, string range, ClearValuesRequest requestBody = default)
{
requestBody ??= new ClearValuesRequest();
using var service = _sheetsServiceFactory.Build();
var request = service.Spreadsheets.Values.Clear(requestBody, id, range);
return(await request.ExecuteAsync());
}
internal void SheetDelete()
{
var range = $"{sheet}!A:F";
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, spreadsheetId, range);
deleteRequest.Execute();
}
public bool deletDonor(string id)
{
var range = $"{_Connection.Sheet}!A" + (int.Parse(id) + 1).ToString() + ":AL" + (int.Parse(id) + 1).ToString();
var valueRange = new ClearValuesRequest();
valueRange.Equals(range);
var clearRequest = _Connection.Service.Spreadsheets.Values.Clear(valueRange, _Connection.SpreadsheetId, range);
var appendReponse = clearRequest.Execute();
return true;
}
/// <inheritdoc />
public Result DeleteEntry()
{
var requestBody = new ClearValuesRequest();
var deleteRequest = service.Spreadsheets.Values.Clear(requestBody, SpreadsheetId, RANGE);
deleteRequest.Execute();
return(Result.Ok());
}
internal static void ClearRange(SheetsService service, string spreadsheetId, string range)
{
ClearValuesRequest requestBody = new ClearValuesRequest();
var clearRequest = service.Spreadsheets.Values.Clear(
body: requestBody,
spreadsheetId: spreadsheetId,
range: range
);
clearRequest.Execute();
}
public Boolean DeleteMember(int ID)
{
_Connection.Sheet = "Fundraisers";
var range = $"{_Connection.Sheet}!A" + ID.ToString() + ":AP" + ID.ToString();
var valueRange = new ClearValuesRequest();
valueRange.Equals(range);
var clearRequest = _Connection.Service.Spreadsheets.Values.Clear(valueRange, _Connection.SpreadsheetId, range);
var appendReponse = clearRequest.Execute();
return(true);
}
public static void ClearAllRow(string spreadSheetId)
{
var result = ReadSheet(spreadSheetId);
if (result.Count > 1)
{
var range = $"{sheet}!A2:F{result.Count}";
var requestBody = new ClearValuesRequest();
var clearRequest = service.Spreadsheets.Values.Clear(requestBody, spreadSheetId, range);
var clearReponse = clearRequest.Execute();
}
}
