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.