void ExportSheet(string sheetId, string sheetName)
{
Debug.Log($"sheetName: {sheetName}");
EditorUtility.DisplayProgressBar("Reading From Google Sheet ", $"Sheet: {sheetName}", GetProcess());
var gstuSearch = new GSTU_Search(sheetId, sheetName, "A1", "Z10000");
SpreadsheetManager.Read(gstuSearch, ReadSheetCallback);
}
private void UpdateRespectBuildings(Action onComplete)
{
SpreadsheetManager.Read(new GSTU_Search(m_sheetName, m_respectWorksheetName), sheet =>
{
SetData(sheet, m_respectConfigs, m_startRespectRow);
Debug.Log("[Balance Mapper] Respect Configs Updated");
UpdateDollarsBuildings(onComplete);
});
}
private void UpdateDollarsBuildings(Action onComplete)
{
SpreadsheetManager.Read(new GSTU_Search(m_sheetName, m_dollarsWorksheetName), sheet =>
{
SetData(sheet, m_dollarsConfigs, m_startDollarsRow);
Debug.Log("[Balance Mapper] Dollars Configs Updated");
onComplete?.Invoke();
});
}
private void ExportSheet(string sheetId, string sheetName, string startCell, string endCell, bool buildText)
{
isBuildText = buildText;
Debug.Log($"sheetName: {sheetName}");
EditorUtility.DisplayProgressBar("Reading From Google Sheet ", $"Sheet: {sheetName}", GetProcess());
var gstuSearch = new GSTU_Search(sheetId, sheetName, startCell, endCell);
SpreadsheetManager.Read(gstuSearch, ReadSheetCallback);
}
public void btn_LoadWarehouse()
{
DestroyAllWarehouseObjects();
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, warehouseItemsWorksheet), ImportWarehouseInventoryData);
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, warehouseInfoWorksheet), LoadWarehouseInfo);
AllCanvasTool.instance.EnableCanvas(defaultCanvasName, true);
}
public void ReadInstancesSheet(string googleKey, string sheet, bool isPrivate)
{
if (isPrivate)
{
SpreadsheetManager.Read(new GSTU_Search(googleKey, sheet), onSheetInstancesRead);
}
else
{
SpreadsheetManager.ReadPublicSpreadsheet(new GSTU_Search(googleKey, sheet), onSheetInstancesRead);
}
}
void UpdateStats()
{
if (sheetStatus == SheetStatus.PRIVATE)
{
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, associatedWorksheet), UpdateAllAnimals);
}
else if (sheetStatus == SheetStatus.PUBLIC)
{
SpreadsheetManager.ReadPublicSpreadsheet(new GSTU_Search(associatedSheet, associatedWorksheet), UpdateAllAnimals);
}
}
public void btn_CreateNewWarehouse()
{
DestroyAllWarehouseObjects();
warehouseXDim = float.Parse(warehouseXDimInput.text);
warehouseYDim = float.Parse(warehouseYDimInput.text);
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, warehouseItemsWorksheet),
CreateWarehouseInfo);
CreateWarehouseBounds();
AllCanvasTool.instance.EnableCanvas(defaultCanvasName, true);
}
public void ChooseMessage()
{
if (Luck == true)
{
SpreadsheetManager.Read(new GSTU_Search(GSheet, "ManagersLuck"), UpdateText);
}
if (Cash == true)
{
SpreadsheetManager.Read(new GSTU_Search(GSheet, "Cash"), UpdateText);
}
if (Selection == true)
{
SpreadsheetManager.Read(new GSTU_Search(GSheet, "Selection"), UpdateText);
}
}
public void btn_UploadWarehouseData()
{
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, warehouseItemsWorksheet), UpdateWarehouseData);
}
/// <summary>
/// Finds the cell we need to update and then updates the information
/// If the spreadsheet is cashed then no need to do the read and can just pass into the update
/// </summary>
private void UpdateAnimalHealth()
{
SpreadsheetManager.Read(new GSTU_Search(animal.associatedSheet, animal.associatedWorksheet), UpdateAnimalHealth);
}
private void Read()
{
SpreadsheetManager.Read(new GSTU_Search(sheetId, worksheetName), UpdateJson);
}
public void btn_UpdateObjectBounds()
{
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, warehouseItemsWorksheet), UpdateInvidualObjectBoxDim);
}
public void btn_LoadWarehouse()
{
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, associatedWorksheet), ImportWarehouseData);
}
public void btn_UpdateWarehouseInformation()
{
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, associatedWorksheet), UpdateWarehouseData);
}
void UpdateStats(UnityAction <GstuSpreadSheet> callback, bool mergedCells = false)
{
SpreadsheetManager.Read(new GSTU_Search(animal.associatedSheet, animal.associatedWorksheet), callback, mergedCells);
}
/// <summary>
/// Finds and updates the rows data based on an entry row data, in this example i am using the name as the unique id to find the starting cell for the row
/// If the spreadsheet is cashed then no need to do the read and can just pass into the update
/// </summary>
void UpdateAnimalInformationOnSheet()
{
SpreadsheetManager.Read(new GSTU_Search(animal.associatedSheet, animal.associatedWorksheet), UpdateAnimalInformation);
}
void Awake()
{
SpreadsheetManager.Read(new GSTU_Search("1CN1DYKG_ZcYQxbzcMlCx-TCWbpGhlV8olewa0P106J4", "Monde2"), Bado);
DontDestroyOnLoad(gameObject);
}
public void Sync()
{
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, associatedWorksheet), OnSheetLoaded);
}
void UpdateStats()
{
SpreadsheetManager spreadsheetManager = new SpreadsheetManager();
SpreadsheetManager.Read(new GSTU_Search(associatedSheet, associatedWorksheet), UpdateEverything, false);
}