public Parcel(PropertyInfo p, ListFeed memberList) { this.Number = p.parcelNumber; this.Owner = p.ownerName1; this.Address = p.address; this.City = p.city; this.Zip = p.zipCode; this.Legal = p.legal; this.Subdivision = !string.IsNullOrWhiteSpace(p.subdivDescr) ? p.subdivDescr : GetSubdivision(); this.Filing = GetFiling(); this.IsAnnexed = GetAnnex(); Membership m = GetLienInfo(memberList); this.IsMember = !string.IsNullOrWhiteSpace(m.MemberId) ? true : false; this.GrantFiled = !string.IsNullOrWhiteSpace(m.GrantFiled) ? m.GrantSigned : ""; this.GrantSigned = !string.IsNullOrWhiteSpace(m.GrantSigned) ? m.GrantSigned : ""; this.MemberId = !string.IsNullOrWhiteSpace(m.MemberId) ? m.MemberId : ""; // mailing addres this.MailAddress1 = !string.IsNullOrWhiteSpace(p.mailAddress1) ? p.mailAddress1 : ""; this.MailAddress2 = !string.IsNullOrWhiteSpace(p.mailAddress2) ? p.mailAddress2 : ""; this.MailAddressCity = !string.IsNullOrWhiteSpace(p.mailCity) ? p.mailCity : ""; this.MailAddressState = !string.IsNullOrWhiteSpace(p.mailState) ? p.mailState : ""; this.MailAddressZip = !string.IsNullOrWhiteSpace(p.mailZipCode) ? FormatZipCode(p.mailZipCode) : ""; // owner this.Owner1 = this.Owner; this.Owner2 = !string.IsNullOrWhiteSpace(p.ownerName2) ? p.ownerName2 : ""; }
/// <summary> /// Inserts a new row in the specified worksheet. /// </summary> /// <param name="service">an authenticated SpreadsheetsService object</param> /// <param name="entry">the worksheet into which the row will be inserted</param> /// <returns>the inserted ListEntry object, representing the new row</returns> private static ListEntry InsertRow(SpreadsheetsService service, WorksheetEntry entry) { AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery query = new ListQuery(listFeedLink.HRef.ToString()); ListFeed feed = service.Query(query); ListEntry firstRow = feed.Entries[0] as ListEntry; ListEntry newRow = new ListEntry(); Console.WriteLine(); Console.WriteLine("Inserting a new row..."); foreach (ListEntry.Custom element in firstRow.Elements) { Console.Write("Enter the value of column \"{0}\": ", element.LocalName); String elementValue = Console.ReadLine(); ListEntry.Custom curElement = new ListEntry.Custom(); curElement.LocalName = element.LocalName; curElement.Value = elementValue; newRow.Elements.Add(curElement); } ListEntry insertedRow = feed.Insert(newRow); Console.WriteLine("Successfully inserted new row: \"{0}\"", insertedRow.Content.Content); return(insertedRow); }
/// <summary> /// Retrieves and prints a list feed of the specified worksheet. /// </summary> /// <param name="service">an authenticated SpreadsheetsService object</param> /// <param name="entry">the worksheet to retrieve</param> /// <param name="reverseRows">true if the rows in the worksheet should /// be reversed when returned from the server</param> private static void RetrieveListFeed(SpreadsheetsService service, WorksheetEntry entry, bool reverseRows) { AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); Console.WriteLine(); Console.WriteLine("This worksheet's list feed URL is:"); Console.WriteLine(listFeedLink.HRef); ListQuery query = new ListQuery(listFeedLink.HRef.ToString()); if (reverseRows) { query.OrderByPosition = true; query.Reverse = true; } ListFeed feed = service.Query(query); Console.WriteLine(); Console.WriteLine("Worksheet has {0} rows:", feed.Entries.Count); foreach (ListEntry worksheetRow in feed.Entries) { ListEntry.CustomElementCollection elements = worksheetRow.Elements; foreach (ListEntry.Custom element in elements) { Console.Write(element.Value + "\t"); } Console.WriteLine(); } }
List <string> GetColumnTitles(ListFeed feed) { List <string> titles = new List <string>(); if (titleRowActual < 0) { ListEntry row = feed.Entries[0] as ListEntry; foreach (ListEntry.Custom element in row.Elements) { titles.Add(element.LocalName); } } else { ListEntry row = feed.Entries[titleRowActual] as ListEntry; foreach (ListEntry.Custom element in row.Elements) { titles.Add(element.Value); } } return(titles); }
/// <summary> /// updates a rows information based on the instance of dataname found in the worksheet /// </summary> /// <param name="worksheet"></param> /// <param name="rowNumber">The number of the row to be modified</param> /// <param name="newData"></param> public static void ModifyRowData(this GS2U_Worksheet worksheet, int rowNumber, Dictionary <string, string> newData) { if (worksheet.GetWorksheetSize().y < rowNumber) { Debug.Log("Worksheet is smaller than rowNumber to edit"); return; } ListFeed feed = worksheet.LoadListFeedWorksheet(); ListEntry row = (ListEntry)feed.Entries[rowNumber - 1]; foreach (var entry in newData) { bool found = false; foreach (ListEntry.Custom element in row.Elements) { if (element.LocalName.ToLower() == entry.Key.ToLower()) { element.Value = entry.Value; found = true; break; } } if (!found) { Debug.LogError("No field found for " + entry.Key); } } row.Update(); }
private string ToGoogleTable() { WorksheetFeed wsFeed = TargetTable.Worksheets; WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[0]; // Define the URL to request the list feed of the worksheet. AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); // Fetch the list feed of the worksheet. ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString()); ListFeed listFeed = service.Query(listQuery); CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink); CellFeed cellFeed = service.Query(cellQuery); CellEntry cellEntry = new CellEntry(1, 1, "oid"); cellFeed.Insert(cellEntry); cellEntry = new CellEntry(1, 2, "value"); cellFeed.Insert(cellEntry); cellEntry = new CellEntry(1, 3, "type"); cellFeed.Insert(cellEntry); ProgressBarSetStartParams(progressBar1, ListData[ListData.Count - 1].Count); tabControlShow(progressBar1); tabControlShow(label3); for (int i = 0; i < ListData[ListData.Count - 1].Count; i++) { IncrementProgressbar(progressBar1); IncrementGeneralLabel(string.Format("Выполнено {0}/{1}", i + 1, ListData[ListData.Count - 1].Count)); service.Insert(listFeed, ListData[ListData.Count - 1].GetCustom(i)); } tabControlShow(progressBar1, false); tabControlShow(label3, false); return("Данные записаны"); }
internal WorksheetRow(ListFeed feed) { // TODO need to pre-init listEntry columns _feed = feed; _entry = new ListEntry(); _unsaved = true; }
public bool Process() { Debug.WriteLine("start AddMissionResultEntry"); WorksheetEntry sheet = GetWorksheet("Mission"); if (sheet == null) { _finishCallback(false); return(false); } ListFeed listFeed = _wrapper.Query(sheet); //ListEntry listRow = new ListEntry(); ListEntry row = (ListEntry)listFeed.CreateFeedEntry(); foreach (var it in _info.KeyValue) { row.Add(it); } listFeed.Insert(row); _finishCallback(true); return(true); }
private Dictionary <string, JobInfo> getGoogleDocsJobs() { Dictionary <string, JobInfo> jobs = new Dictionary <string, JobInfo>(); WorksheetEntry ws = this.getDataWorksheet(); AtomLink feedLink = ws.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery listQuery = new ListQuery(feedLink.HRef.ToString()); ListFeed feed = this.service.Query(listQuery); foreach (ListEntry row in feed.Entries) { string key = null; string col1 = null; string col2 = null; foreach (ListEntry.Custom element in row.Elements) { if (key == null) { key = element.Value; } else if (col1 == null) { col1 = element.Value; } else if (col2 == null) { col2 = element.Value; } } jobs.Add(key, new JobInfo(key, col1, col2)); } return(jobs); }
public bool Process() { Debug.WriteLine("start AddMaterialChangeEntry"); WorksheetEntry sheet = GetWorksheet("Materials"); if (sheet == null) { _finishCallback(false); return(false); } sheet = CheckColumns(sheet, LogData.MaterialChangeInfo.SpreadsheetColumnTitle()); ListFeed listFeed = _wrapper.Query(sheet); //ListEntry listRow = new ListEntry(); ListEntry row = (ListEntry)listFeed.CreateFeedEntry(); foreach (var it in _info.KeyValue) { row.Add(it); } listFeed.Insert(row); _finishCallback(true); return(true); }
public void ListQuery(WorksheetEntry worksheet) { // Define the URL to request the list feed of the worksheet. AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); // Fetch the list feed of the worksheet. ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString()); //listQuery.MinPublication = new DateTime(2013, 9, 18); //listQuery.ModifiedSince = new DateTime(2013, 9, 18); listQuery.StartDate = new DateTime(2013, 9, 18); ListFeed listFeed = this.Service.Query(listQuery); Console.WriteLine("Results {0}", listFeed.Entries.Count); for (int rowIdx = 0; rowIdx < 10; rowIdx++) { // TODO: Choose a row more intelligently based on your app's needs. ListEntry row = (ListEntry)listFeed.Entries[rowIdx]; // Update the row's data. foreach (ListEntry.Custom element in row.Elements) { Console.WriteLine(element.LocalName + " : " + element.Value); Console.ReadLine(); } } }
private ListFeed GetWorksheetFeed(WorksheetEntry pWorksheetEntry) { AtomLink wListFeedLink = pWorksheetEntry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery wquery = new ListQuery(wListFeedLink.HRef.ToString()); ListFeed w2feed = tService.Query(wquery); return(w2feed); }
private void UpdateListFeed() { WorksheetEntry worksheet = (WorksheetEntry)worksheetFeed.Entries[0]; AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString()); listFeed = spreadsheetsService.Query(listQuery); }
public IEnumerable <ListEntry> GetAllRows() { AtomLink listFeedLink = WorksheetEntry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString()); ListFeed feed = service.Query(listQuery); return(feed.Entries.Select(e => (ListEntry)e)); }
protected TranslationModule FromWorksheet(string project, WorksheetEntry worksheet) { // Define the URL to request the list feed of the worksheet. AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); // Fetch the list feed of the worksheet. ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString()); ListFeed listFeed = this.Service.Query(listQuery); Console.WriteLine("Results {0}", listFeed.Entries.Count); List <string> languages = new List <string>(); var dicts = new Dictionary <string, Dictionary <string, string> >(); var comments = new Dictionary <string, string>(); //language information is in first row var firstRow = (ListEntry)listFeed.Entries[0]; for (int column = 1; column < firstRow.Elements.Count; column++) { var lang = firstRow.Elements[column].LocalName; languages.Add(lang); dicts.Add(lang, new Dictionary <string, string>()); } var tp = new TranslationModule(project, "en", languages.ToArray()); for (int rowIdx = 1; rowIdx < listFeed.Entries.Count; rowIdx++) { ListEntry row = (ListEntry)listFeed.Entries[rowIdx]; string comment = null; string key = row.Elements[0].Value; // first column is the key // Update the row's data. for (int column = 1; column < row.Elements.Count; column++) { var element = row.Elements[column]; //in list based feeds localname always correponds to first row if (element.LocalName.ToLower() == "comment") { comment = element.Value; } else { tp.Add(new Segment(element.LocalName, key, element.Value)); } } foreach (var seg in tp.ByKey[key]) { seg.Comment = comment; } } return(tp); }
static void Main(string[] args) { Thread.CurrentThread.CurrentCulture = new CultureInfo("es-ES"); // CHARACTERS List <string> charactersAndUpgradesStrings = new List <string>(); ListFeed list = GDriveManager.GetSpreadsheet(DriveUrl, 1); foreach (ListEntry row in list.Entries) { string name = row.Elements[0].Value; float multiplier = float.Parse(row.Elements[1].Value); int health = int.Parse(row.Elements[2].Value); int klid = int.Parse(row.Elements[3].Value); float klidRegen = float.Parse(row.Elements[4].Value); float speed = float.Parse(row.Elements[5].Value); float whoaPower = float.Parse(row.Elements[6].Value); float mass = float.Parse(row.Elements[7].Value); int spellSlots = int.Parse(row.Elements[8].Value); int price = int.Parse(row.Elements[9].Value); charactersAndUpgradesStrings.Add(String.Format("\n\n//{0}\nWhoaCharacter {0} = new WhoaCharacter({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9});\ncharacters.Add({0});", name, multiplier, health, whoaPower, speed, mass, klid, klidRegen, spellSlots, price)); } ListFeed upgradesList = GDriveManager.GetSpreadsheet(WhoaPlayerProperties.DRIVE_DOCUMENT_URL, 2); foreach (ListEntry row in upgradesList.Entries) { int id = int.Parse(row.Elements[0].Value); if (id == -1) { upgrade.Effects.Add(parseEffect(row)); } else { currentlyUpgradedCharacter = characters[id]; string name = row.Elements[1].Value; int maxLevel = int.Parse(row.Elements[2].Value); int basePrice = int.Parse(row.Elements[3].Value); float priceMultiplier = float.Parse(row.Elements[4].Value); upgrade = new CharacterUpgrade(name, maxLevel, basePrice, priceMultiplier); upgrade.Effects.Add(parseEffect(row)); currentlyUpgradedCharacter.AddUpgrade(upgrade); } } ReplaceAutoGenerated(WhoaScriptsFolderPath + "WHOATESTING.txt", charactersAndUpgradesStrings); // Keep the console window open in debug mode. Console.WriteLine("Press any key to exit."); Console.ReadKey(); }
protected void button2_Click(object sender, EventArgs e) { if (spreadsheetName.Length > 0) { if (listView2.SelectedIndex > -1) { wrkSheetName = listView2.SelectedItem.Text; } else { return; } SpreadsheetsService GoogleExcelService; GoogleExcelService = new SpreadsheetsService("Spreadsheet-Abhishek-App"); GoogleExcelService.setUserCredentials("*****@*****.**", "Lucknow@"); // ListQuery query = new ListQuery("0AmYgMIof-5mgdGM2OGxoTmUyc3JRTFlMZ1BTUG5SOVE", "1", "public", "values"); // ListQuery query = new ListQuery("https://docs.google.com/a/laitkor.com/spreadsheet/ccc?key=0AttN4WWVg0qodF9RSG8tOXptV0RwZm1LOWFJQ3g0Mnc#gid=0", "1", "public", "values"); //ListFeed myFeed = GoogleExcelService.Query(query); SpreadsheetQuery query = new SpreadsheetQuery(); SpreadsheetFeed myFeed = GoogleExcelService.Query(query); foreach (SpreadsheetEntry mySpread in myFeed.Entries) { if (mySpread.Title.Text == spreadsheetName) { WorksheetFeed wfeed = mySpread.Worksheets; foreach (WorksheetEntry wsheet in wfeed.Entries) { if (wsheet.Title.Text == wrkSheetName) { AtomLink atm = wsheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery Lquery = new ListQuery(atm.HRef.ToString()); ListFeed LFeed = GoogleExcelService.Query(Lquery); myTable = new DataTable(); DataColumn DC; foreach (ListEntry LmySpread in LFeed.Entries) { DataRow myDR = myTable.NewRow(); foreach (ListEntry.Custom listrow in LmySpread.Elements) { DC = myTable.Columns[listrow.LocalName] ?? myTable.Columns.Add(listrow.LocalName); myDR[DC] = listrow.Value; } myTable.Rows.Add(myDR); } dataGridView1.DataSource = myTable; dataGridView1.DataBind(); } } } } } //System.Windows.Forms.MessageBox.Show("Data Reading is Completed"); ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Data Reading is Completed');", true); }
public void getValues(string sheetName, DataSet dataSet) { var tableName = sheetName; if (dataSet.Tables[tableName] == null) { tableName = sheetName + "_"; } if (dataSet.Tables[tableName] == null) { throw new ArgumentException("Neither " + sheetName + " nor " + sheetName + "_ tables could be found in the passed dataset!!!"); } DataColumnCollection columnNames = dataSet.Tables[tableName].Columns; WorksheetEntry entry = (WorksheetEntry)m_worksheets[sheetName]; if (entry == null) { string message = sheetName + " not found in " + m_spreadsheetName; Trace.WriteLine(message); throw new ArgumentNullException(message); } AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery query = new ListQuery(listFeedLink.HRef.ToString()); ListFeed feed = m_service.Query(query); Trace.WriteLine("Found " + feed.Entries.Count + " rows of data in " + sheetName); if (feed.Entries.Count > 0) { ListEntry worksheetRow = (ListEntry)feed.Entries[0]; ListEntry.CustomElementCollection elements = worksheetRow.Elements; for (int j = 0; j < feed.Entries.Count; ++j) { worksheetRow = (ListEntry)feed.Entries[j]; elements = worksheetRow.Elements; DataRow workRow = dataSet.Tables[tableName].NewRow(); for (int i = 0; i < elements.Count; ++i) { string value = "" + elements[i].Value; Type type = columnNames[i].DataType; if (type == System.Type.GetType("System.Double") && string.IsNullOrWhiteSpace(value)) { value = "0"; } if (type == System.Type.GetType("System.Int32") && string.IsNullOrWhiteSpace(value)) { value = "0"; } workRow[columnNames[i].ColumnName] = value; } dataSet.Tables[tableName].Rows.Add(workRow); } } return; }
private List <DatablockDetectionInfo> ParseSpreadsheet(SpreadsheetEntry spreadsheet) { WorksheetFeed wsFeed = spreadsheet.Worksheets; if (wsFeed.Entries.Count == 0) { return(null); } var worksheet = (WorksheetEntry)wsFeed.Entries[0]; if (worksheet.Rows < 2) { return(null); } // Define the URL to request the list feed of the worksheet. AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); // Fetch the list feed of the worksheet. var listQuery = new ListQuery(listFeedLink.HRef.ToString()); ListFeed listFeed = sheetsAPI.Service.Query(listQuery); var headers = new List <string>(); spreadsheetRows = listFeed.Entries; nameColumnIndex = -1; var row = (ListEntry)spreadsheetRows[0]; for (int index = 0; index < row.Elements.Count; index++) { ListEntry.Custom element = row.Elements[index]; if (element.LocalName.Equals("name", StringComparison.OrdinalIgnoreCase)) { nameColumnIndex = index; } headers.Add(element.LocalName); } List <DatablockDetectionInfo> datablockTypes = AutoDetectDatablockType(headers); if (datablockTypes == null) { Debug.Log("Unable to auto detect datablock type"); return(null); } return(datablockTypes); }
private static bool UpdateLinkInfo(WorksheetEntry wsEntry, List <LinkInfo> linkToUpdate) { bool updated = false; try { LinkInfo firstLinkInfo = linkToUpdate.First(); AtomLink listFeedLink = wsEntry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString()); listQuery.SpreadsheetQuery = "sourcemodelid = \"" + firstLinkInfo.SourceModelId + "\""; ListFeed listFeed = sheetsService.Query(listQuery); if (listFeed.Entries.Count > 0) { foreach (ListEntry row in listFeed.Entries) { string itemSourceId = row.Elements[Array.IndexOf(googleHeaders, "ItemSourceID")].Value; var linkFound = from linkInfo in linkToUpdate where linkInfo.SourceItemId.ToString() == itemSourceId select linkInfo; if (linkFound.Count() > 0) { try { LinkInfo linkInfo = linkFound.First(); row.Elements[Array.IndexOf(googleHeaders, "ItemType")].Value = linkInfo.ItemType.ToString(); row.Elements[Array.IndexOf(googleHeaders, "SourceName")].Value = linkInfo.SourceModelName; row.Elements[Array.IndexOf(googleHeaders, "SourcePath")].Value = linkInfo.SourceModelPath; row.Elements[Array.IndexOf(googleHeaders, "DestinationPath")].Value = linkInfo.DestModelPath; row.Elements[Array.IndexOf(googleHeaders, "ItemSourceName")].Value = linkInfo.SourceItemName; row.Elements[Array.IndexOf(googleHeaders, "ItemDestinationID")].Value = linkInfo.DestItemId.ToString(); row.Elements[Array.IndexOf(googleHeaders, "ItemDestinationName")].Value = linkInfo.DestItemName; row.Elements[Array.IndexOf(googleHeaders, "ItemDestinationImage1")].Value = linkInfo.DestImagePath1; row.Elements[Array.IndexOf(googleHeaders, "ItemDestinationImage2")].Value = linkInfo.DestImagePath2; row.Elements[Array.IndexOf(googleHeaders, "LinkModified")].Value = linkInfo.LinkModified; row.Elements[Array.IndexOf(googleHeaders, "LinkModifiedBy")].Value = linkInfo.LinkModifiedBy; row.Update(); } catch (Exception ex) { string message = ex.Message; } } } updated = true; } } catch (Exception ex) { MessageBox.Show("Failed to update the link information.\n" + ex.Message, "Update Link Information", MessageBoxButton.OK, MessageBoxImage.Warning); } return(updated); }
public WorksheetValues GetList(WorksheetEntry worksheet) { AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString()); ListFeed listFeed = _service.Query(listQuery); var values = listFeed.Entries.Select(row => ((ListEntry)row).Elements.Cast <ListEntry.Custom>().ToDictionary(el => el.LocalName, el => el.Value)); return(new WorksheetValues() { Values = values }); }
private void ClearSheet(string workbookName) { var page1 = (WorksheetEntry)GetWorkbookSheets(workbookName)[0]; if (page1 == null) { throw new ApplicationException("Worksheet not found"); } AtomLink listFeedLink = page1.Links.FindService(GDataSpreadsheetsNameTable.CellRel, null); ListFeed listFeed = spreadsheetService.Query(new ListQuery(listFeedLink.HRef.ToString())); CellFeed cells = spreadsheetService.Query(new CellQuery(listFeedLink.HRef.ToString())); int ctr = 0; CellEntry toUpdateA; CellEntry toUpdateB; AtomFeed batchFeed = new AtomFeed(cells); // This is for the header row ctr = (int)cells.ColCount.Count; // Skip all of this if there are no cells with values in them other than those in the header row if (cells.Entries.Count > ctr) { // Process through all of the cells that have a value in them starting at the cell below the Header while (true) { toUpdateA = (CellEntry)cells.Entries[ctr]; toUpdateA.Cell.InputValue = ""; toUpdateA.BatchData = new GDataBatchEntryData("A", GDataBatchOperationType.update); batchFeed.Entries.Add(toUpdateA); ctr++; if (ctr >= cells.Entries.Count) { break; } toUpdateB = (CellEntry)cells.Entries[ctr]; toUpdateB.Cell.InputValue = ""; toUpdateB.BatchData = new GDataBatchEntryData("B", GDataBatchOperationType.update); batchFeed.Entries.Add(toUpdateB); ctr = ctr + 1; if (ctr >= cells.Entries.Count) { break; } } // Erase all cells CellFeed batchResultFeed = (CellFeed)spreadsheetService.Batch(batchFeed, new Uri(cells.Batch)); } }
public void SelectWorkSheet(string sSheetName) { WorksheetQuery worksheetQuery = new WorksheetQuery(m_oLink.HRef.ToString()); worksheetQuery.Title = sSheetName; m_oWorksheetFeed = m_oAccount.Service.Query(worksheetQuery); m_oWorksheet = (WorksheetEntry)m_oWorksheetFeed.Entries[0]; AtomLink listFeedLink = m_oWorksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString()); m_oListFeed = m_oAccount.Service.Query(listQuery); }
// grab your spreadsheet's ID / "key" from the URL to access your doc... // make sure stop as soon as you hit an ampersand, those are additional URL parameters we don't need public static ListFeed GetSpreadsheet(string spreadsheetID, int gridId) { // We need this fake certificate to trick Mono's security to use HTTPS... doesn't work in webplayer's security sandbox InsecureSecurityCertificatePolicy.Instate(); SpreadsheetsService service = new SpreadsheetsService("UnityConnect"); string url = "https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/" + gridId + "/public/values"; ListQuery listQuery = new ListQuery(url); ListFeed feed = service.Query(listQuery); return(feed); }
private Membership GetLienInfo(ListFeed memberList) { Membership m = new Membership(); foreach (ListEntry entry in memberList.Entries) { if (entry.Elements[8].Value.ToString().Replace("-", "") == this.Number) { m.GrantFiled = entry.Elements[6].Value.ToString(); m.GrantSigned = entry.Elements[5].Value.ToString(); m.MemberId = entry.Elements[0].Value.ToString(); } } return(m); }
/// <summary> /// Reads the Google Spreadsheet and generates/updates the StringSet asset files /// </summary> public void Generate() { ListFeed test = GDocService.GetSpreadsheet(GoogleLink); var languageMap = new Dictionary <string, StringSet>(); var keys = CreateInstance <StringSet>(); languageMap.Add("Keys", keys); var ignore = new HashSet <string>(_ignoreColumns); foreach (ListEntry row in test.Entries) { keys.Add(row.Title.Text); foreach (ListEntry.Custom element in row.Elements) { string lang = element.LocalName; if (ignore.Contains(lang)) { continue; } if (!languageMap.ContainsKey(lang)) { languageMap[lang] = CreateInstance <StringSet>(); } languageMap[lang].Add(element.Value); } } string folderPath = _saveFolder ? AssetDatabase.GetAssetPath(_saveFolder) : "Assets/Resources/Lang"; foreach (var lang in languageMap) { var method = "Generating"; string path = string.Format("{0}/{1}.asset", folderPath, lang.Key); var language = AssetDatabase.LoadAssetAtPath <StringSet>(path); if (language) { method = "Updating"; language.Copy(lang.Value); EditorUtility.SetDirty(language); } else { AssetDatabase.CreateAsset(lang.Value, path); } Debug.Log(string.Format("{0} language files for: {1}", method, lang.Key)); } EditorApplication.SaveAssets(); AssetDatabase.SaveAssets(); }
Dictionary <string, SerializedNestedStrings> generateLanguageDict(ListFeed sheet) { var firstRow = (ListEntry)sheet.Entries.FirstOrDefault(); var returnDict = new Dictionary <string, SerializedNestedStrings>(); foreach (ListEntry.Custom element in firstRow.Elements) { if (element.LocalName.Equals(KeyIdentifier)) { continue; } returnDict[element.LocalName] = new SerializedNestedStrings(); } return(returnDict); }
/// <summary> /// Add a new row of data to the bottom of the worksheet /// </summary> /// <param name="worksheet"></param> /// <param name="newData"></param> public static void AddRowData(this GS2U_Worksheet worksheet, Dictionary <string, string> newData) { ListFeed feed = worksheet.LoadListFeedWorksheet(); ListEntry newRow = new ListEntry(); foreach (var entry in newData) { newRow.Elements.Add(new ListEntry.Custom() { LocalName = entry.Key.ToLower(), Value = entry.Value.ToLower() }); } SpreadSheetManager.service.Insert(feed, newRow); }
public NameValueCollection getInfo(Boolean debug = false) { NameValueCollection parameters = new NameValueCollection(); WorksheetEntry entry = (WorksheetEntry)worksheets["Info"]; AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null); ListQuery query = new ListQuery(listFeedLink.HRef.ToString()); ListFeed feed = service.Query(query); foreach (ListEntry worksheetRow in feed.Entries) { ListEntry.CustomElementCollection elements = worksheetRow.Elements; parameters.Add(elements[0].Value, elements[1].Value); } return(parameters); }
/// <summary> Reads the Google Spreadsheet and generates/updates the StringSet asset files </summary> public void Generate() { ListFeed test = GDocService.GetSpreadsheet(GoogleLink); var languageMap = new Dictionary <string, Dictionary <string, string> >(); var ignore = new HashSet <string>(_ignoreColumns); foreach (ListEntry row in test.Entries) { var keyEntry = row.Elements.OfType <ListEntry.Custom>() .FirstOrDefault(e => e.LocalName.ToLower() == _defaultLanguage.ToLower()); if (keyEntry == null) { continue; } var key = keyEntry.Value; foreach (ListEntry.Custom element in row.Elements) { string lang = element.LocalName; if (ignore.Contains(lang)) { continue; } if (!languageMap.ContainsKey(lang)) { languageMap[lang] = new Dictionary <string, string>(); } languageMap[lang].Add(key, element.Value); } } var baseFolder = Path.Combine(Application.streamingAssetsPath, "lang"); if (!Directory.Exists(baseFolder)) { Directory.CreateDirectory(baseFolder); } foreach (var lang in languageMap) { File.WriteAllText(Path.Combine(baseFolder, lang.Key + LanguageManager.FileExtension), JsonConvert.SerializeObject(lang.Value, Formatting.Indented)); Log.Info("Generating language files for: {0}", lang.Key); } AssetDatabase.SaveAssets(); AssetDatabase.Refresh(); }