/// <summary>
/// Gets the data from an exact cell reference
/// </summary>
/// <param name="worksheet"></param>
/// <param name="column"></param>
/// <param name="row"></param>
/// <returns></returns>
public static CellData GetCellData(this GS2U_Worksheet worksheet, string column, int row)
{
int colInt = GoogleSheetsToUnityUtilities.GetIndexInAlphabet(column);
CellEntry entry = worksheet.GetCellEntry(colInt, row);
List <string> rows = worksheet.GetRowTitles();
List <string> cols = worksheet.GetColumnTitles();
CellData cellData = new CellData(entry.InputValue, rows[row - 1], cols[colInt - 1]);
return(cellData);
}
/// <summary>
/// Get the cell entry
/// </summary>
/// <param name="worksheet"></param>
/// <param name="column"></param>
/// <param name="row"></param>
/// <returns></returns>
private static CellEntry GetCellEntry(this GS2U_Worksheet worksheet, string column, int row)
{
CellQuery cellQuery = new CellQuery(worksheet.worksheetEntry.CellFeedLink);
int colInt = GoogleSheetsToUnityUtilities.GetIndexInAlphabet(column);
cellQuery.MinimumRow = (uint)row;
cellQuery.MaximumRow = (uint)row;
cellQuery.MinimumColumn = (uint)colInt;
cellQuery.MaximumColumn = (uint)colInt;
CellFeed cellFeed = SpreadSheetManager.service.Query(cellQuery) as CellFeed;
return((CellEntry)cellFeed.Entries[0]);
}