private void btExcel_Click(object sender, EventArgs e) { SaveFileDialog save = new SaveFileDialog(); save.Filter = "(*.xlsx)|*.xlsx"; save.DefaultExt = ".xlsx"; save.AddExtension = true; if (save.ShowDialog(this) == DialogResult.OK) { waitForm.ShowWaitForm(); WorkWithExcel excel = new WorkWithExcel(); if (State == EnumReportState.RevenueOfMonth) { excel.ExportExcelReports(table, 2, "Reprot of Monthly", "Report of Monthly", save.FileName); } else if (State == EnumReportState.Price) { excel.ExportExcelReports(table, 2, "Reprot of Product Price", "Reprot of Product Price", save.FileName); } else if (State == EnumReportState.Quantiy) { excel.ExportExcelReports(table, 2, "Reprot of Product Quantily", "Reprot of Product Quantily", save.FileName); } else if (State == EnumReportState.ProductTypes) { excel.ExportExcelReports(table, 2, "Reprot of Product Types", "Reprot of Product Types", save.FileName); } else if (State == EnumReportState.RevenueOfDays) { excel.ExportExcelReports(table, 2, "Reprot of Days", "Report of Days", save.FileName); } waitForm.CloseWaitForm(); } }
// // Export to Excel private void btExcel_Click(object sender, EventArgs e) { SaveFileDialog save = new SaveFileDialog(); save.Filter = "(*.xlsx)|*.xlsx"; save.DefaultExt = ".xlsx"; save.AddExtension = true; if (save.ShowDialog(this) == DialogResult.OK) { waitForm.ShowWaitForm(); WorkWithExcel excel = new WorkWithExcel(); get_productsTableAdapter.Fill(computerStoreDataSet.get_products); excel.ExportExcelReports(computerStoreDataSet.get_products, 2, "Reprot of Products", "Reprot of Products", save.FileName); waitForm.CloseWaitForm(); } }