Import Excel sheet with Images and save in database using Aspose.Cells library in ASP.Net

Question

Hello SirHow to import the excel sheet with images and save the data in database using asp netPlease help meThanks

dharmendr · Accepted Answer

Refer below linkshttpsarchivecodeplexcompexportexcelgridviewhttpsforumsaspnett1464349aspxImportimagefromexceltodatatable

democloud · Answer

Hello SirBelow is the updated code    protected void Button2Clickobject sender EventArgs e            try                    int i  0            string filename  ServerMapPath34Folderbook1xlsx34            Instantiating a Workbook object and open the uploaded file            Workbook workbook  new Workbookfilename            Obtaining the reference of first worksheet by passing its sheet index            Worksheet worksheet  workbookWorksheets0            MemoryStream ms  new MemoryStream            Picture pic  null            int firstRow  0            int firstColumn  1            int lastRow  6            int lastColumn  5            int imageColumn  4            Exporting the contents to DataTable            DataTable dataTable  worksheetCellsExportDataTablefirstRow firstColumn lastRow lastColumn true            Byte bytes  null            foreach DataRow dr in dataTableRows                            foreac

Import Excel sheet with Images and save in database using Aspose.Cells library in ASP.Net

Company

Explore

Follow us

Contact Us