public static async Task DoOpenWorkbookAsync(IDialogContext context, string workbookName)
{
try
{
// Add extension to filename, if needed
var filename = workbookName.ToLower();
if (!(filename.EndsWith(".xlsx")))
{
filename = $"{filename}.xlsx";
}
// Get meta data for the workbook
var item = await ServicesHelper.OneDriveService.GetItemMetadataAsync("", filename);
await ServicesHelper.LogOneDriveServiceResponse(context);
context.UserData.SetValue("WorkbookId", item.Id);
context.ConversationData.SetValue("WorkbookName", item.Name);
context.ConversationData.SetValue("WorkbookWebUrl", item.WebUrl);
context.UserData.RemoveValue("Type");
context.UserData.RemoveValue("Name");
context.UserData.RemoveValue("CellAddress");
context.UserData.RemoveValue("TableName");
context.UserData.RemoveValue("RowIndex");
// Get the first worksheet in the workbook
var worksheets = await ServicesHelper.ExcelService.ListWorksheetsAsync(
item.Id,
ExcelHelper.GetSessionIdForRead(context),
"$top=1");
await ServicesHelper.LogExcelServiceResponse(context);
context.UserData.SetValue("WorksheetId", worksheets[0].Name);
// Respond
await context.PostAsync($"We are ready to work with **{worksheets[0].Name}** in {ExcelHelper.GetWorkbookLinkMarkdown(context)}");
}
catch (Exception ex)
{
await context.PostAsync($"Sorry, something went wrong when I tried to open the **{workbookName}** workbook on your OneDrive for Business ({ex.Message})");
}
}
