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();
}
