/// <summary>
/// Recebe um DataTable e exporta para excel
/// </summary>
/// <param name="source">DataTable com os registros</param>
/// <param name="fileName">Caminho onde deseja salvar os registros</param>
/// <param name="fileName">Abrir arquivo ou não.</param>
public static void ExportaParaExcel(DataTable dt, string fileName, bool open)
{
ExportaExcel.ExportaParaExcel(dt, fileName, open, true);
//SaveFileDialog saveDialog = new SaveFileDialog();
//if (string.IsNullOrEmpty(fileName))
//{
// saveDialog.DefaultExt = "xls";
// saveDialog.Filter = "Microsoft Excel (.xls)|*.xls|Todos Arquivos (*.*)|*.*";
// saveDialog.AddExtension = true;
// saveDialog.RestoreDirectory = true;
// saveDialog.Title = "Onde você deseja salvar o arquivos?";
// saveDialog.InitialDirectory = @"C:\Temp";
// if (saveDialog.ShowDialog() == DialogResult.OK)
// fileName = saveDialog.FileName;
//}
//if (!string.IsNullOrEmpty(fileName))
//{
// Microsoft.Office.Interop.Excel.Application excel = null;
// Microsoft.Office.Interop.Excel.Workbook wb = null;
// object missing = Type.Missing;
// Microsoft.Office.Interop.Excel.Worksheet ws = null;
// Microsoft.Office.Interop.Excel.Range rng = null;
// try
// {
// excel = new Microsoft.Office.Interop.Excel.Application();
// wb = excel.Workbooks.Add();
// ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.ActiveSheet;
// for (int Idx = 0; Idx < dt.Columns.Count; Idx++)
// {
// ws.Range["A1"].Offset[0, Idx].Value = dt.Columns[Idx].ColumnName;
// }
// for (int Idx = 0; Idx < dt.Rows.Count; Idx++)
// {
// ws.Range["A2"].Offset[Idx].Resize[1, dt.Columns.Count].Value = dt.Rows[Idx].ItemArray;
// }
// excel.ActiveWorkbook.SaveCopyAs(fileName);
// excel.DisplayAlerts = false;
// excel.Quit();
// if (open == true)
// AbrirExcel(fileName);
// }
// catch (Exception ex)
// {
// MessageBox.Show("Error accessing Excel: " + ex.ToString());
// }
//}
}
public static void ExportaParaExcel(DataTable dt, string fileName, bool open, bool ajustarLarguraColunas, string titulo)
{
ExportaExcel.ExportaParaExcel(dt, fileName, open, ajustarLarguraColunas, null, null, titulo);
}
