private void CreateWarehouseInfo(GstuSpreadSheet sheet) { SpreadsheetManager.Write(new GSTU_Search(associatedSheet, warehouseInfoWorksheet, "A2"), new ValueRange(warehouseXDim.ToString()), null); SpreadsheetManager.Write(new GSTU_Search(associatedSheet, warehouseInfoWorksheet, "B2"), new ValueRange(warehouseYDim.ToString()), null); }
/// <summary> /// Adds the new animal to the spreadsheet online at the location defined as start cell, if no start cell defined will write from A1 /// </summary> void WriteToSheet() { List <string> list = new List <string>(); list.Add(animal.name); list.Add(animal.health.ToString()); list.Add(animal.attack.ToString()); list.Add(animal.defence.ToString()); SpreadsheetManager.Write(new GSTU_Search(animal.associatedSheet, animal.associatedWorksheet, "G10"), new ValueRange(list), null); }
private void UpdateWarehouseData(GstuSpreadSheet sheet) { //Begin wiping old data-------------------------------------------------------------------------------------------------- BatchRequestBody updateRequest = new BatchRequestBody(); foreach (var warehouseUUID in sheet.columns["UUID"]) { if (warehouseUUID.value != "UUID") { updateRequest.Add(sheet[warehouseUUID.value, "Box Dim"].AddCellToBatchUpdate(associatedSheet, warehouseItemsWorksheet, "")); updateRequest.Add(sheet[warehouseUUID.value, "Position"].AddCellToBatchUpdate(associatedSheet, warehouseItemsWorksheet, "")); updateRequest.Add(sheet[warehouseUUID.value, "UUID"].AddCellToBatchUpdate(associatedSheet, warehouseItemsWorksheet, "")); } } updateRequest.Send(associatedSheet, warehouseItemsWorksheet, null); //End wiping old data------------------------------------------------------------------------------------------------------- //Begin importing new data-------------------------------------------------------------------------------------------------- List <List <string> > warehouseObjectImportList = new List <List <string> >(); foreach (KeyValuePair <string, WarehouseObject> pair in objectsInWarehouse) { List <string> temp = new List <string>() { pair.Value.UUID, pair.Value.objTransform.localScale.ToString(), pair.Value.objTransform.position.ToString() }; warehouseObjectImportList.Add(temp); } SpreadsheetManager.Write(new GSTU_Search(associatedSheet, warehouseItemsWorksheet, "A2"), new ValueRange(warehouseObjectImportList), null); //End importing new data---------------------------------------------------------------------------------------------------- }
public void submit_information() { string time = System.DateTime.Now.ToString("h:mm:ss"); list.Add(time); name_field = _name.text; print(name_field); lastName_field = lastName.text; print(lastName_field); mail_field = mail.text; print(mail_field); enterprise_field = enterprise.text; print(enterprise_field); list.Add(name_field); list.Add(lastName_field); list.Add(mail_field); list.Add(enterprise_field); SpreadsheetManager.Write(new GSTU_Search(associatedSheet, associatedWorkSheet, "A" + k), new ValueRange(list), null); k++; list.Clear(); SceneManager.LoadScene(1); }