public static void CreateWorkbook(DataSet ds, String path)
{
try
{
if (ds.Tables.Count > 0)
{
WorkbookEngine we = new WorkbookEngine();
we.CreateWorkbook(ds);
we.SaveWorkbook(path);
}
}
catch (Exception e)
{
IntegratorBatch.ExceptionLogger.Fatal("Impossible de créer le fichier Excel:" + path, e);
throw e;
}
}
private void btnExportar_Click(object sender, EventArgs e)
{
if (dataSet1.Tables.Count == 0)
{
MessageBox.Show(
"No hay datos en la sección de resultados. Realice una consulta antes de intentar exportar",
"No se puede exportar", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
try
{
var fs = new StreamWriter(saveFileDialog1.FileName);
fs.Write(WorkbookEngine.CreateWorkbook(dataSet1));
fs.Close();
}
catch (Exception ex)
{
Log.ShowAndLog(ex);
}
}
}