/// <summary> /// 仅仅加载显示xlsx /// </summary> private void OnlyLoadXlsx() { viewModel.BusyWindowVisibility = Visibility.Visible; System.Threading.ThreadStart start = delegate() { System.Threading.Thread.Sleep(20); try { viewModel.PicGridVisibility = Visibility.Collapsed; viewModel.AxFramerControlVisibility = Visibility.Collapsed; viewModel.SpreadsheetControlVisibility = Visibility.Visible; Task task = Task.Run(() => { Dispatcher.BeginInvoke(new Action(() => { DevExpress.Spreadsheet.IWorkbook workbook = spreadsheetControl1.Document; workbook.Options.Culture = new System.Globalization.CultureInfo("en-US"); workbook.LoadDocument(viewModel.CurrentMyFolderData.FilePath); })); }); } catch (Exception ex) { Dispatcher.Invoke(new Action(() => { viewModel.BusyWindowVisibility = Visibility.Collapsed; })); } }; System.Threading.Thread t = new System.Threading.Thread(start); t.IsBackground = true; t.Start(); }
public String getSheetName(int index) { DevExpress.Spreadsheet.IWorkbook workbook = this.spreadsheetControl.Document; if (workbook.Worksheets.Count >= index) { return(workbook.Worksheets[index - 1].Name); } return(null); }
private void layout2_Load(object sender, EventArgs e) { Ex = this.layout2; workbook = Ex.SpreadsheetControl1.Document; Ex.Execute_Click += (o,ev) => { int check = 0; var Data = (Excel.GetTableFromExcel(Ex.SpreadsheetControl1)).AsEnumerable(); List<thoikhoabieu> list = new List<thoikhoabieu>(); try { list = (from s in Data select new thoikhoabieu { maca = s.Field<String>("maca"), magv = s.Field<String>("magv"), mahp = s.Field<String>("mahp"), malop = s.Field<String>("malop"), manganh = s.Field<String>("manganh"), siso = Convert.ToInt32(s["siso"]), tuanhocbatdau = Convert.ToInt32(s["tuanhocbatdau"]), tuanhocketthuc = Convert.ToInt32(s["tuanhocketthuc"]), }).ToList(); if (list.Count > 0) { foreach (thoikhoabieu ob in list) { check = (new ClassRoomBUS.ThoikhoabieuBUS()).Insert(ob); if (check == 0) { DevExpress.XtraEditors.XtraMessageBox.Show("Chưa có dữ liệu nào trong Bảng"); return; } } } else { DevExpress.XtraEditors.XtraMessageBox.Show("Chưa có dữ liệu nào trong Bảng"); return; } } catch (Exception ex) { var k = ex.Message; } //for (int i = 0; i < table.Rows.Count;i++ ) //{ // DataRow row = table.Rows[i]; // for(int j = 0; j < table.Columns.Count;j++) // { // System.Diagnostics.Debug.Write(row[j].ToString()); // } //} DevExpress.XtraEditors.XtraMessageBox.Show("Đã Cập nhật vào Cơ Sở Dữ Liệu"); }; }
public List <Sheet> getAllExcelSheets() { List <Sheet> Sheets = new List <Sheet>(0); DevExpress.Spreadsheet.IWorkbook workbook = this.spreadsheetControl.Document; foreach (DevExpress.Spreadsheet.Worksheet worksheet in workbook.Worksheets) { Sheets.Add(new Sheet(worksheet.Index + 1, worksheet.Name)); } return(Sheets); }
public List <String> getSheetNames() { List <String> names = new List <String>(0); DevExpress.Spreadsheet.IWorkbook workbook = this.spreadsheetControl.Document; foreach (DevExpress.Spreadsheet.Worksheet worksheet in workbook.Worksheets) { names.Add(worksheet.Name); } return(names); }
public void Protect(bool protect) { DevExpress.Spreadsheet.IWorkbook workbook = this.spreadsheetControl.Document; if (!workbook.IsProtected && protect) { workbook.Protect("Password", true, true); } else { workbook.Unprotect("Password"); } }
protected DevExpress.Spreadsheet.Worksheet getWorksheet(string sheetName) { DevExpress.Spreadsheet.IWorkbook workbook = this.spreadsheetControl.Document; foreach (DevExpress.Spreadsheet.Worksheet worksheet in workbook.Worksheets) { if (worksheet.Name.Equals(sheetName)) { return(worksheet); } } return(null); }
private void DisplayTemplateExcelFile() { if (string.IsNullOrEmpty(_templateFilePath)) { return; } if (System.IO.File.Exists(_templateFilePath)) { DevExpress.Spreadsheet.IWorkbook workbook = spreadsheetControl1.Document; workbook.LoadDocument(_templateFilePath); } }
private void SpreadsheetControl1_DocumentLoaded(object sender, EventArgs e) { System.Windows.Threading.Dispatcher x = System.Windows.Threading.Dispatcher.CurrentDispatcher; System.Threading.ThreadStart start = delegate() { System.Threading.Thread.Sleep(500); Dispatcher.Invoke(new Action(() => { try { DevExpress.Spreadsheet.IWorkbook workbook = spreadsheetControl1.Document; int sheetCount = workbook.Worksheets.Count; foreach (var searchStr in viewModel.CurrentMyFolderData.UnChekedWordInfos.Select(y => y.Name).ToList()) { for (int k = 0; k < sheetCount; k++) { var worksheet = workbook.Worksheets[k]; IEnumerable <DevExpress.Spreadsheet.Cell> searchResult = worksheet.Search(searchStr); foreach (DevExpress.Spreadsheet.Cell cell in searchResult) { string str = cell.DisplayText; cell.Fill.BackgroundColor = System.Drawing.ColorTranslator.FromHtml("#ffff00"); MatchCollection mc = Regex.Matches(cell.DisplayText, searchStr, RegexOptions.IgnoreCase); if (mc.Count > 0) { foreach (System.Text.RegularExpressions.Match m in mc) { //赋值range var itemDetailInfo = viewModel.CurrentMyFolderData.UnChekedWordInfos.FirstOrDefault(y => y.Name == searchStr).UnChekedWordInLineDetailInfos.Where(z => z.TypeTextFrom == "Text" && z.XlsxHasValue == false).FirstOrDefault(); if (itemDetailInfo != null) { itemDetailInfo.WorkSheetIndex = k; itemDetailInfo.Cell = cell; itemDetailInfo.XlsxHasValue = true; } } } } } } } catch (Exception ex) { } viewModel.BusyWindowVisibility = Visibility.Collapsed; })); }; System.Threading.Thread t = new System.Threading.Thread(start); t.IsBackground = true; t.Start(); }
/// <summary> /// Sauve le fichier ouvert sous un autre nom. /// </summary> /// <param name="filePath">L'url du nouveau fichier</param> /// <param name="overwrite"></param> /// <returns> /// OperationState.CONTINUE si l'opération a réussi /// OperationState.STOP sinon /// </returns> public OperationState SaveAs(String filePath, bool overwrite) { try { DevExpress.Spreadsheet.IWorkbook workbook = this.spreadsheetControl.Document; using (FileStream stream = new FileStream(filePath, FileMode.Create, FileAccess.ReadWrite)) { workbook.SaveDocument(stream, DevExpress.Spreadsheet.DocumentFormat.Xlsx); } return(OperationState.CONTINUE); } catch (Exception) { return(OperationState.STOP); } }
/// <summary> /// Ouvre le fichier dont l'url est passé en paramètre. /// </summary> /// <param name="filePath">L'url du fichier à ouvrir</param> /// <param name="progID">Le type de fichier à ouvrir</param> /// <returns> /// OperationState.CONTINUE si l'opération a réussi /// OperationState.STOP sinon /// </returns> public OperationState Open(string filePath) { try { ThrowEvent = false; DevExpress.Spreadsheet.IWorkbook workbook = this.spreadsheetControl.Document; using (FileStream stream = new FileStream(filePath, FileMode.Open)) { workbook.LoadDocument(stream, DevExpress.Spreadsheet.DocumentFormat.Xlsx); this.spreadsheetControl.Options.Save.CurrentFileName = filePath; } ThrowEvent = true; return(OperationState.CONTINUE); } catch (Exception) { ThrowEvent = true; return(OperationState.STOP); } }