Loop through sub directories in directory

Question

I have a directory 'Folder' with many subdirectories inside this directory. Inside every subdirectory there are many images. I want to loop through subdirectories in the 'Folder' directory, then loop through all images in every directory to export the images out to Excel, with images from each subdirectory in one Excel worksheet.

For e.g. if I have ten subdirectories, I should have one Excel workbook with ten Excel worksheets, then in each Excel worksheet there will be images from each subdirectory.

This is what I have tried but images only appeared on Worksheet1 instead of all the worksheets:

   public void ExportToExcel()
        {
            //for export
            ExcelPackage objExcelPackage = new ExcelPackage();   //create new workbook

            string[] filesindirectory = Directory.GetDirectories(Server.MapPath("~/Folder"));
            int count = 0;
            int count1 = 0;
            int x = 25;
            int finalValue = 0;

            foreach (string subdir in filesindirectory)
            {                      
                count++;
                ExcelWorksheet ws = objExcelPackage.Workbook.Worksheets.Add("Worksheet" + count); //create new worksheet

            foreach (string img in Directory.GetFiles(subdir))
            {
                count1++;
                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(count1.ToString(), myImage);
                // Row, RowoffsetPixel, Column, ColumnOffSetPixel
                if (count1 > 1)
                {
                    pic.SetPosition(finalValue, 0, 2, 0);
                    finalValue += (x + 1); // Add 1 to have 1 row of empty row
                }
                else
                {
                    pic.SetPosition(count1, 0, 2, 0);
                    finalValue = (count1 + x) + 1; // Add 1 to have 1 row of empty
                }
            }
            }

            var filepath = new FileInfo(@"C:\Users\user\Desktop\Test\" + datetime.ToString("dd-MM-yyyy_hh-mm-ss") + ".xlsx");
            objExcelPackage.SaveAs(filepath);
        }

How to loop through each sub directories in a directory, then loop through all images from each sub directory using C#?

Answer 1

Janne Matikainen answer is correct but you need to know how to modify in your code...

First change your code this line

 string[] filesindirectory = Directory.GetFiles(Server.MapPath("~/Folder"));

to

 string[] filesindirectory = Directory.GetDirectories(Server.MapPath("~/Folder"));

Secondly you need to search file in your sub folder path which is your

foreach (string subdir in filesindirectory)

subdir is your path for your directory.

Just do back the same thing what you did to get the files

foreach (string img in  Directory.GetFiles(subdir))

After you finish the foreach subdirectory

foreach (string img in  Directory.GetFiles(subdir)) 
{
   // Your Code
}
// Reset the Count1
count1 = 0;

Reset it because you are increasing for dynamic row generating for each sheet.
Then you at new sheet and you didn't reset it.
It will continue the count as per previous sheet.

To get the folder name you can easily get it by split.
Before you create the worksheet you do as per below.

string[] splitter = subdir.Split('\\');
string folderName = splitter[splitter.Length - 1];

Take NOTES if the folderName contain some symbol it might not able to set it to excel worksheet and also the name cannot be too long.
Please ensure that you replace with supportable symbol for excel worksheet

Answer 2

This should list all files starting from C:\Images and go through all subdirs and their subdirs as well.

public void ExportToExcel()
{
    //for export
    var objExcelPackage = new ExcelPackage(); //create new workbook

    this.ListFiles(objExcelPackage, 0, Server.MapPath("~/Folder"));

    var filepath = new FileInfo(@"C:\Users\user\Desktop\Test\" + datetime.ToString("dd-MM-yyyy_hh-mm-ss") + ".xlsx");
    objExcelPackage.SaveAs(filepath);
}

public void ListFiles(ExcelPackage objExcelPackage, int worksheetIndex, string path)
{
    var imageCount = 0;
    var x = 25;
    var finalValue = 0;

    var files = Directory.GetFiles(path).Select(s => new FileInfo(s));

    if (files.Any())
    {
        //create new worksheet
        var ws = objExcelPackage.Workbook.Worksheets.Add("Worksheet" + (++worksheetIndex)); 

        foreach (var file in files)
        {
            imageCount++;

            var TEST_IMAGE = new System.Web.UI.WebControls.Image();
            var myImage = System.Drawing.Image.FromFile(img);
            var pic = ws.Drawings.AddPicture(imageCount.ToString(), myImage);

            // Row, RowoffsetPixel, Column, ColumnOffSetPixel
            if (imageCount > 1)
            {
                pic.SetPosition(finalValue, 0, 2, 0);
                finalValue += (x + 1); // Add 1 to have 1 row of empty row
            }
            else
            {
                pic.SetPosition(imageCount, 0, 2, 0);
                finalValue = (imageCount + x) + 1; // Add 1 to have 1 row of empty
            }
        }
    }

    foreach (var dir in Directory.GetDirectories(path))
    {
        this.ListFiles(objExcelPackage, worksheetIndex, dir);
    }
}