public void ExportToExcel() { //for export ExcelPackage objExcelPackage = new ExcelPackage(); //create new workbook string[] filesindirectory = Directory.GetFiles(Server.MapPath("~/Image")); int count = 0; ExcelWorksheet ws = objExcelPackage.Workbook.Worksheets.Add("Worksheet" + count); //create new worksheet foreach (string img in filesindirectory) { count++; System.Web.UI.WebControls.Image TEST_IMAGE = new System.Web.UI.WebControls.Image(); System.Drawing.Image myImage = System.Drawing.Image.FromFile(img); var pic = ws.Drawings.AddPicture(count.ToString(), myImage); // Row, RowoffsetPixel, Column, ColumnOffSetPixel pic.SetPosition(1, 0, 2, 0); } } var filepath = new FileInfo(@"C:\Users\user\Desktop\Test\" + datetime.ToString("dd-MM-yyyy_hh-mm-ss") + ".xlsx"); objExcelPackage.SaveAs(filepath); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)