public static Request GetFormatRequest(int sheetId, int fgColor, int bgColor, int startRowIndex, int endRowIndex, string startColumn, string endColumn)
{
int startColumnIndex = GoogleSheetsRequests.ColumnNumber(startColumn) - 1;
int endColumnIndex = GoogleSheetsRequests.ColumnNumber(endColumn);
return(GetFormatRequest(sheetId, fgColor, bgColor, startRowIndex, endRowIndex, startColumnIndex, endColumnIndex));
}
public static Request GetBasicFilterRequest(int sheetId, int startRowIndex, int endRowIndex, string startColumn, string endColumn)
{
int startColumnIndex = GoogleSheetsRequests.ColumnNumber(startColumn) - 1;
int endColumnIndex = GoogleSheetsRequests.ColumnNumber(endColumn);
return(GetBasicFilterRequest(sheetId, startRowIndex, endRowIndex, startColumnIndex, endColumnIndex));
}
public static Request GetFormulaAndNumberFormatRequest(int sheetId, string formulaValue, int startRowIndex, int endRowIndex, string startColumn, string endColumn)
{
int startColumnIndex = GoogleSheetsRequests.ColumnNumber(startColumn) - 1;
int endColumnIndex = GoogleSheetsRequests.ColumnNumber(endColumn);
return(GetFormulaAndNumberFormatRequest(sheetId, formulaValue, startRowIndex, endRowIndex, startColumnIndex, endColumnIndex));
}
public static Request HideColumnsRequest(int sheetId, string startColumn, string endColumn)
{
int startColumnIndex = GoogleSheetsRequests.ColumnNumber(startColumn) - 1;
int endColumnIndex = GoogleSheetsRequests.ColumnNumber(endColumn);
return(HideColumnsRequest(sheetId, startColumnIndex, endColumnIndex));
}