public void ProcessRequest(HttpContext context) { string tabData = context.Request["excelData"]; DataTable dt = ConvertCsvData(tabData); if (dt == null) { // Add some error-catching here... return; } string excelFilename = context.Request["filename"]; if (File.Exists(excelFilename)) { File.Delete(excelFilename); } if (excelFilename.Contains(".pdf")) { CreateExcelFile.CreatePDFDocument(dt, excelFilename, context.Response); } else { CreateExcelFile.CreateExcelDocument(dt, excelFilename, context.Response); } }
private void btnCreateExcel_Click(object sender, EventArgs e) { saveFileDialog1.FileName = "Sample.xlsx"; saveFileDialog1.Filter = "Excel 2007 files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; saveFileDialog1.FilterIndex = 1; saveFileDialog1.RestoreDirectory = true; saveFileDialog1.OverwritePrompt = false; if (saveFileDialog1.ShowDialog() != DialogResult.OK) { return; } string TargetFilename = saveFileDialog1.FileName; DataSet ds = CreateSampleData(); try { CreateExcelFile.CreateExcelDocument(ds, TargetFilename); } catch (Exception ex) { MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message); return; } Process p = new Process(); p.StartInfo = new ProcessStartInfo(TargetFilename); p.Start(); this.Close(); }