static void SaveExcel()
{
FileInfo fi = null;
fi = new FileInfo(@"D:\CurrentDevelopment\Cresa\test.xlsx");
var stream = new MemoryStream(File.ReadAllBytes(fi.FullName));
Cresa.Services.Excel.ExcelReader reader = new Services.Excel.ExcelReader();
var template = reader.ReadExcel(stream);
var srv = new Cresa.Services.Excel.ListingExcelService("");
var excelBytes = srv.Export(template, "48013");
File.WriteAllBytes(@"D:\CurrentDevelopment\Cresa\out.xlsx", excelBytes);
}
static void CreateExcel()
{
string type = "";
OracleRepository rep = new OracleRepository();
MemoryStream stream =(MemoryStream) rep.LoadListingDocument("701", out type);
Cresa.Services.Excel.ExcelReader reader = new Services.Excel.ExcelReader();
var template = reader.ReadExcel(stream);
var srv = new Cresa.Services.Excel.ListingExcelService("");
var excelBytes = srv.Export(template, "48013");
File.WriteAllBytes(@"D:\CurrentDevelopment\Cresa\out.xlsx", excelBytes);
}
static void LoadExcel()
{
FileInfo fi = null;
fi = new FileInfo(@"D:\CurrentDevelopment\Cresa\out.xlsx");
var stream = new MemoryStream(File.ReadAllBytes(fi.FullName));
Cresa.Services.Excel.ExcelReader reader = new Services.Excel.ExcelReader();
var data = reader.ReadExcel(stream);
// var sheets = data.Where(x => x.SheetName == "Sale").ToList();
foreach (var sheet in data)
{
var srv = new Cresa.Services.Excel.ListingExcelService(sheet.SheetName.Trim());
srv.Import(sheet, "test");
Console.WriteLine(data);
}
}
public JsonResult ImportExcel( HttpPostedFileBase file)
{
OracleRepository repo = new OracleRepository();
object model;
// Check if the file is excel
if (file.ContentLength <= 0 )
{
model = (object)"You uploaded an empty file";
return Json(model);
}
if (file.ContentType != "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
model = (object)"Please upload a valid excel file of version 2007 and above";
return Json(model);
}
var reader = new Cresa.Services.Excel.ExcelReader();
MemoryStream ms = new MemoryStream();
file.InputStream.CopyTo(ms);
var data= reader.ReadExcel(ms);
foreach(var sheet in data)
{
var srv = new Cresa.Services.Excel.ListingExcelService(sheet.SheetName);
if (srv.Import(sheet, HttpContext.User.Identity.Name))
{
model = (object)"Import complete";
return Json(model);
}
}
model= (object)"Unable to import file.";
return Json(model);
}
public ActionResult ExportListing(string id)
{
string type = "";
OracleRepository rep = new OracleRepository();
MemoryStream stream = (MemoryStream)rep.LoadListingDocument("701", out type);
Cresa.Services.Excel.ExcelReader reader = new Services.Excel.ExcelReader();
var template = reader.ReadExcel(stream);
var srv = new Cresa.Services.Excel.ListingExcelService("");
var excelBytes = srv.Export(template, id);
Response.AddHeader("Content-Disposition","attachment; filename=Cresa - Industrial Market Availabilities.xlsx");
return new FileContentResult(excelBytes,
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
}
