public void CreateExcelReport(string templateID, int userID)
{
var template = Storage.Select <Template>(templateID);
entityID = template.Entity.ID.ToString();
var table = Storage.Select <BusinessContent>(entityID).GetTable(userID);
if (!Frame.IsNeedAllInstances.Checked)
{
var instancesID = GetInstancesID();
DataRow[] rows = table.AsEnumerable().Where(x => instancesID.Contains(x["objID"].ToString())).ToArray();
table = rows.CopyToDataTable();
}
string file = template.FileName;
using (var stream = new MemoryStream())
{
var builder = new ReportViewExcelBuilder();
builder.Create(stream, Teleform.Reporting.GroupReport.Make(template, table));
Response.Clear();
Response.ContentType = "text/html";
Response.AddHeader("content-disposition", string.Format("attachment;fileName={0}.xlsx", file));
Response.ContentEncoding = Encoding.UTF8;
Response.BinaryWrite(stream.ToArray());
Response.Flush();
Response.End();
}
}
public void ExcelReport(IQueryable <Rest> rests)
{
DataTableClass dt = new DataTableClass(rests);
using (var stream = new MemoryStream())
{
//var builder = new ExcelReportBuilder();
var builder = new ReportViewExcelBuilder();
builder.Create(stream, dt.dt);
Response.Clear();
Response.ContentType = "text/html";
Response.AddHeader("content-disposition", "attachment;fileName=RestReport" + DateTime.Now.ToString("_dd_MM_yyyy") + ".xlsx");
Response.ContentEncoding = Encoding.UTF8;
Response.BinaryWrite(stream.ToArray());
Response.Flush();
Response.End();
}
// XLWorkbook wb = new XLWorkbook();
// wb.Worksheets.Add(dt.dt, "WorksheetName");
// var work = wb.Worksheets;
// var z = "C:\\Users\\" + wb.Author + "\\Downloads\\RestReport" + DateTime.Now.ToString("_dd_MM_yyyy") + ".xlsx";
//wb.SaveAs("C:\\Users\\" + wb.Author + "\\Downloads\\RestReport" + DateTime.Now.ToString("_dd_MM_yyyy") + ".xlsx");
//ViewBag.Rests = db.GetRests();
//return RedirectToAction("Index");
}
