private XlsFile Export(DataSet data)
{
using (FlexCelReport Report = new FlexCelReport(true))
{
Report.AddTable(data);
Report.SetUserFunction("Images", new ImagesImp());
XlsFile Xls = new XlsFile(true);
Xls.Open(Path.Combine(DataPath, "Features Page.template.xls"));
Report.Run(Xls);
return(Xls);
}
}
public void AutoRun()
{
using (FlexCelReport ordersReport = SharedData.CreateReport())
{
ordersReport.SetValue("Date", DateTime.Now);
ordersReport.SetUserFunction("Orders", new OrdersImp(SharedData.GetOrders()));
string DataPath = Path.Combine(Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), ".."), "..") + Path.DirectorySeparatorChar;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
ordersReport.Run(DataPath + "User Defined Functions.template.xls", saveFileDialog1.FileName);
if (MessageBox.Show("Do you want to open the generated file?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Process.Start(saveFileDialog1.FileName);
}
}
}
}