private void btnExport_Click(object sender, EventArgs e) { using (SaveFileDialog sfd = new SaveFileDialog()) { sfd.Filter = "Excel Files | *.xlsx"; if (sfd.ShowDialog() == DialogResult.OK) { try { if (sfd.FileName != "" && sfd.FileName.EndsWith(".xlsx")) { var excelProvider = new ExcelProvider(); var fileBytes = excelProvider.ExportQuery("Trustee Report List", _TrusteeReportResults.AsQueryable(), new ExcelStyleSheet()); File.WriteAllBytes(sfd.FileName, fileBytes); Process.Start(sfd.FileName); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnExport_Click(object sender, EventArgs e) { using (SaveFileDialog sfd = new SaveFileDialog()) { sfd.Filter = "Excel Files | *.xlsx"; if (sfd.ShowDialog() == DialogResult.OK) { try { if (sfd.FileName != "" && sfd.FileName.EndsWith(".xlsx")) { var excelProvider = new ExcelProvider(); var fileBytes = excelProvider.ExportQuery("BuildingPMDebtor", FilterData(), new ExcelStyleSheet()); File.WriteAllBytes(sfd.FileName, fileBytes); Process.Start(sfd.FileName); // MessageBox.Show("Saved Succesfully", "Report", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnExport_Click(object sender, EventArgs e) { using (SaveFileDialog sfd = new SaveFileDialog()) { sfd.Filter = "Excel Files | *.xlsx"; if (sfd.ShowDialog() == DialogResult.OK) { try { if (sfd.FileName != "" && sfd.FileName.EndsWith(".xlsx")) { var excelProvider = new ExcelProvider(); var results = _AllResults.Select(a => new TransactionSearchModel { BuildingPath = a.BuildingPath, TransactionDate = a.TransactionDate, AccountNumber = a.AccountNumber, LinkAccount = (a.LinkAccount == "\0\0\0\0\0\0\0") ? string.Empty : a.LinkAccount, //Pastel handles null values as \0\0\0\0\0\0\0 Reference = a.Refrence, Description = a.Description, Amount = a.Amount }).AsQueryable(); var fileBytes = excelProvider.ExportQuery("Transaction Search", results, new ExcelStyleSheet()); File.WriteAllBytes(sfd.FileName, fileBytes); Process.Start(sfd.FileName); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }