1

I am working on a small project and need some quick help here. I have an excel worksheet with following fields,

Id, Name, Image

I want to grab only the Image and loop through all the image rows and extract its data into an Excel sheet

Is this possible somehow?

I have this: Edit I have a button on which I am uploading one Excel file, and there is only one excel file. This file has a column named Image which has some url. Now, when I upload an Excel file, I want to download the image from url mentioned in Excel file and update the url in it.

var excel = new ExcelPackage(FileUpload2.FileContent);
var dta = excel.ToDataTable();
DataView view = new DataView(dta);
DataTable dt = view.ToTable("Id","Name","Image");
for(int i = 0; i <= dt.Rows.Count; i++)
 {
   for(int j = 0; j <= dt.Columns.Count; j++)
   {
         // what to write here??                
   }
 }

I am using OfficeOpenXML for my excel operations.

Rohan Rao
  • 2,505
  • 3
  • 19
  • 39

0 Answers0