/// <summary>
/// Exports the list to excel.
/// </summary>
/// <param name="shopList">The shop list.</param>
private static void ExportListToExcel(ShopList shopList)
{
FileExporter.ExcelExporter exporter = new FileExporter.ExcelExporter();
CarlosAg.ExcelXmlWriter.Workbook book = exporter.Generate(shopList);
SaveFileDialog sfd = new SaveFileDialog();
sfd.FileName = "ShopList.xls";
sfd.Filter = "Excel XML Documents (*.xls)|*.xls";
if (sfd.ShowDialog() == DialogResult.OK)
{
String filename = sfd.FileName;
if (!filename.EndsWith("xls"))
{
filename += "xls";
}
try
{
book.Save(filename);
//File.Open(filename, FileMode.OpenOrCreate);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
/// <summary>
/// Exports the list to excel.
/// </summary>
/// <param name="shopList">The shop list.</param>
private void ExportListToExcel(ShopList shopList)
{
FileExporter.ExcelExporter exporter = new FileExporter.ExcelExporter();
CarlosAg.ExcelXmlWriter.Workbook book = exporter.Generate(shopList);
SaveFileDialog sfd = new SaveFileDialog();
sfd.FileName = "ShopList.xls";
sfd.Filter = "Excel XML Documents (*.xls)|*.xls";
if (sfd.ShowDialog() == DialogResult.OK)
{
String filename = sfd.FileName;
if (!filename.EndsWith("xls"))
{
filename += "xls";
}
try
{
book.Save(filename);
using (Process prc = new Process())
{
Process.Start(filename);
}
}
catch (Exception ex)
{
this.ShowMessage(ex.Message);
}
}
}
/// <summary>
/// Exports the list to excel.
/// </summary>
/// <param name="shopList">The shop list.</param>
private static void ExportListToExcel(ShopList shopList)
{
FileExporter.ExcelExporter exporter = new FileExporter.ExcelExporter();
CarlosAg.ExcelXmlWriter.Workbook book = exporter.Generate(shopList);
SaveFileDialog sfd = new SaveFileDialog();
sfd.FileName = "ShopList.xls";
sfd.Filter = "Excel XML Documents (*.xls)|*.xls";
if (sfd.ShowDialog() == DialogResult.OK)
{
String filename = sfd.FileName;
if (!filename.EndsWith("xls"))
{
filename += "xls";
}
try
{
book.Save(filename);
//File.Open(filename, FileMode.OpenOrCreate);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}