public async Task CreateDeleteSheet()
{
ExcelTestConfiguration testConfig = await ExcelTestConfiguration.GetInstance();
ExcelRequestContext ctx = new ExcelRequestContext(testConfig.Url);
testConfig.SetupRequestContext(ctx);
string name = "S" + Guid.NewGuid().ToString("N").Substring(0, 8);
Worksheet sheet = ctx.Workbook.Worksheets.Add(name);
ctx.Load(sheet);
await ctx.Sync();
this.TestContext.WriteLine("Created sheet");
TestUtility.DumpWorksheet(this.TestContext, sheet);
string id = sheet.Id;
sheet.Delete();
ctx.Load(ctx.Workbook.Worksheets);
await ctx.Sync();
bool found = false;
this.TestContext.WriteLine("After delete sheet {0}", id);
foreach (Worksheet s in ctx.Workbook.Worksheets.Items)
{
TestUtility.DumpWorksheet(this.TestContext, s);
if (s.Id == id)
{
found = true;
}
}
Assert.IsFalse(found, "Expect not found={0}", found);
}
private static async Task <ExcelTestConfiguration> CreateConfigurationInstanceForGraph(bool useProdEnvironment, string filename)
{
ExcelTestConfiguration ret = new ExcelTestConfiguration();
string clientId = "";
string refreshToken = "";
string clientSecret = "";
if (useProdEnvironment)
{
clientId = "8563463e-ea18-4355-9297-41ff32200164";
refreshToken = "AAABAAAAiL9Kn2Z27UubvWFPbm0gLVfeKP2hZcZ86a6lp2m4bh3dqnZBSxRvzCvCxo9KFBV1u9PmnK85adjyZvkRyEkITe5o9yrHbdf7TkS3OXzn1V3_KaOLQnvQDwezFlGSoDmx_oBb-R09ayJ_X1ukk6W8nLgjmxQU4-f4xtGEjNjin-VXtjsPoQ6oecBByZOWwaTrA1q4ypcBC2U3N0JSKI3wsrdt6BOpI1HPlR0iNLN0EdLNCO4FanLRj9pX9I3rDuOTl4ij6eaTNBj9VUhMjuJAKsWgqbWU3BnElF_WApmxVk3dKSqqoozgHSPW8quU7Zzl1xfEF3N04lzguXgzbrMvfPUQsqnb30BM8O-wBUOuoVlAcok-moYZhmPgc6Nrx6b8ecBMIQxpBGVHnQjDdDwZF1yhI_sQS5cw8mjkegAXnQAjcJDZd6kHr68007ab_5EoX_0XmzqBsFhwzXI2fD3yI6qsLsPlk9MwBXZrKitj_0FFP6YbHrO-hOdJGqlcXsagoPhKt2jTccdTPdDemXzcGojNOzO94Od2OD93Ask0U2RxvIglOv44AylPMhcu_ZNmg415E0FbpQFPo2zHl31mZKeYuTPHJOEHsh03jpTeZGCeNgM9m2N0cxQdmNzkpucVgeLw_lkYksRIOJu7xR7rwx7B4wIcbVOKjp6wSMchM_UgAA";
}
else
{
clientId = "09d9cc54-6048-4c79-b468-99aa29c6e98d";
refreshToken = "AAABAAAAo3ZCPl0FaU2WWRdLWLHpeuZwRI99asNFFGqI5jrtOaZrpea7p2Tjv7lBqu9pLvvEeWZ8Cqt-7ZsIDrUwRG0fA7NN087iBjX1sfs90I-uTROatDX4iMls7CFUwqO6SmUvsugPFIBQL9g3Gab956jIJJd9IyN5Zds24Ff-WJwb07ISCzq4akW8VtJOn54aRilOQbbsGGDUX4AeYb_Lazre3J3LAG_O8egjPrYrhf-ks9OjUzePoyxrntxGGs9h_wWIVnFPyaXaStNvik4MoihmPNAo6DzWekTKD8EjY7FlwiQKYnLyEGBVb1rilFHMX2WW6up0uoCQ-JOAiT3zXJ2FX2tnjBzt4JCLsTYxl4QSHu6BMRwzHNPK-LOOSNleLa3k0chaFpIjhpC7i_C0z-aRiSJXfw9BN_ZEOd79XXWcEdhsiNfQutFYRY9eNIn8SaS-fCt_yqD46JE2yIeE0FjK9X89qE2vLiOLKPJJcwtraLEiyKTsAlYrVSldsBX4bv-j7sQOwAHb62Ys2rBAFXGfErEEW1xN-G3j2sNe9jSlJAZWvzWKyhP6N4Z4VM1-Wp4LRpFykclpVI5EiKJzq90hgBytEj9bXKIj3Iqn2Tmd1rJfHTfvrqcdi2cSjaAcSKygzu4jWr2DXNZ1PPi50bz7tsE2_dxYzpIYOJtgFaboV2YgAA";
}
GraphApiFileInfo fileInfo = await GraphApiUtility.GetFileInfo(useProdEnvironment, filename, clientId, clientSecret, refreshToken);
ret.ClientId = clientId;
ret.RefreshToken = refreshToken;
ret.AccessToken = fileInfo.AccessToken;
ret.Url = fileInfo.FileWorkbookUrl;
return(ret);
}
private static ExcelTestConfiguration CreateConfigurationInstanceForWacDevMachine()
{
ExcelTestConfiguration ret = new ExcelTestConfiguration();
ret.Url = "http://shaozhu-ttvm8.redmond.corp.microsoft.com/th/WacRest.ashx/transport_wopi/Application_Excel/wachost_/Fi_anonymous~AgaveTest.xlsx/ak_1%7CGN=R3Vlc3Q=&SN=MTQ3NzYwMzQ5Mw==&IT=NTI0NzY0ODQ4NzI5ODI1NTE3Mw==&PU=MTQ3NzYwMzQ5Mw==&SR=YW5vbnltb3Vz&TZ=MTExOQ==&SA=RmFsc2U=&LE=RmFsc2U=&AG=VHJ1ZQ==&RH=yowrURj8H-VliWbIQ9aPYap80Goy0B5oU0dfzY7WEwM=/_api";
return(ret);
}
public async Task GetRangeValue()
{
ExcelTestConfiguration testConfig = await ExcelTestConfiguration.GetInstance();
ExcelRequestContext ctx = new ExcelRequestContext(testConfig.Url);
testConfig.SetupRequestContext(ctx);
Range r = ctx.Workbook.Worksheets.GetItem("Sheet1").GetRange("A1:B2");
ctx.Load(r);
await ctx.Sync();
TestUtility.Dump2DArray(this.TestContext, r.Values);
}
public async Task GetWorksheets()
{
ExcelTestConfiguration testConfig = await ExcelTestConfiguration.GetInstance();
ExcelRequestContext ctx = new ExcelRequestContext(testConfig.Url);
testConfig.SetupRequestContext(ctx);
ctx.Load(ctx.Workbook.Worksheets);
await ctx.Sync();
foreach (var worksheet in ctx.Workbook.Worksheets.Items)
{
TestUtility.DumpWorksheet(this.TestContext, worksheet);
}
}
public static async Task <ExcelTestConfiguration> GetInstance()
{
ExcelTestConfiguration ret = s_instance;
if (ret == null)
{
// ret = CreateConfigurationInstanceForWacDevMachine();
ret = await CreateConfigurationInstanceForGraph(useProdEnvironment : false, filename : "AgaveTest.xlsx");
// ret = await CreateConfigurationInstanceForGraph(useProdEnvironment: true, filename: "AgaveTest.xlsx");
s_instance = ret;
}
return(ret);
}