public void ClearGoogleDocument() { SpreadsheetProxy proxy = new SpreadsheetProxy(new Credentials { username = "******", password = "******" }); proxy.InitWorkbook("phlavor-mixtures", "phlavor-mixtures.xlsx"); }
public void ReadGoogleDocument() { SpreadsheetProxy proxy = new SpreadsheetProxy(new Credentials { username = "******", password = "******" }); Dictionary <string, string>[] worksheet = proxy.GetWorkbookData("phlavor-mixtures"); Assert.AreEqual(worksheet.Length, 3); Assert.AreEqual(worksheet[0].Keys.Count, 5); }