Export Multiple Images From Image Folder to Excel

See more:

C#

ASP.NET

image

export

hi, I have one image folder with multiple images inside. I want to export all images from this folder into excel, does anyone know how I can accomplish this?

I am able to export 1 image from that folder to excel but unable to export multiple images to excel.

This is my codes:

protected void EXPORT_BUTTON_Click(object sender, EventArgs e)
        {
         ExportToExcel();
        }

public void ExportToExcel()
        {
            string[] filesindirectory = Directory.GetFiles(Server.MapPath("~/Image"));

                    foreach (string img in filesindirectory)
                    {
                        using (StringWriter sw = new StringWriter())
                        {
                            using (HtmlTextWriter hw = new HtmlTextWriter(sw))
                            {
                        Table table = new Table();

                        System.Web.UI.WebControls.Image TEST_IMAGE = new System.Web.UI.WebControls.Image();
                        TEST_IMAGE.ImageUrl = "~/Image" + img;
                        TEST_IMAGE.ImageUrl = this.GetAbsoluteUrl(TEST_IMAGE.ImageUrl);
                        TableRow row = new TableRow();
                        row.Cells.Add(new TableCell());
                        row.Cells[0].Controls.Add(TEST_IMAGE);
                        table.Rows.Add(row);
                        table.RenderControl(hw);

                        //Export the Table to Excel.

                        Response.Clear();

                        Response.Buffer = true;

                        Response.AddHeader("content-disposition", "attachment;filename=Images.xls");

                        Response.Charset = "";

                        Response.ContentType = "application/vnd.ms-excel";

                        //Write the HTML string to Response.

                        Response.Write(sw.ToString());

                        Response.Flush();

                        Response.End();
                    }

                }
            }
        }

public override void VerifyRenderingInServerForm(Control control)
        {
            return;
        }

        private string GetAbsoluteUrl(string relativeUrl)
        {
            relativeUrl = relativeUrl.Replace("~/", string.Empty);

            string[] splits = Request.Url.AbsoluteUri.Split('/');

            if (splits.Length >= 2)
            {
                string url = splits[0] + "//";

                for (int i = 2; i < splits.Length - 1; i++)
                {
                    url += splits[i];

                    url += "/";
                }
                return url + relativeUrl;
            }
            return relativeUrl;
        }

Question: How to export multiple images from an image folder into Excel using C#?
Thanks for any help!