private void GetListBT_Click(object sender, RoutedEventArgs e) { try { By xPathTitleOfTable = By.XPath(@"//div[@class='Xxx__Table__Row']/div"); List <IWebElement> titleElements = AddToolsSe.getXpathElements(xPathTitleOfTable, ref Drv); ExcelMO._Worksheet workSheetFirst = MakeXLS.CreateExcelSingleSheet(ref appl); MakeXLS.MakeTitle(ref titleElements, ref workSheetFirst); string DataOfTable = @"//div[@aria-label='row'][1]/div"; int countColumn = AddToolsSe.getXpathElements(By.XPath(DataOfTable), ref Drv).Count; MakeXLS.MakeData(ref Drv, DataOfTable, countColumn, ref workSheetFirst); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void OpenXlsFile_BT_Click(object sender, RoutedEventArgs e) { try { string fullFnPath = ""; if (ds == null) { ds = new DataSet(); } if (ds == null) { dt = new DataTable(); } MakeXLS.Open_Xls_File(ref ds, ref fullFnPath); dt = ds.Tables[0]; XlsFilePath_TB.Text = fullFnPath; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SaveToXlsBT_Click(object sender, RoutedEventArgs e) { MakeXLS.SaveXls(@"D:\", "eWeb", ref appl); }