Enumerate folders and files


#1

Hi,

I want to make an excel file that I show it to folder, and then it find all the files (in subfolders too) in the folder, and then it will write them on a sheet, make a file list on the sheet. But I couldn’t make the file.

Can you help me ?

Thanks for your helps.


#2

Hi, thanks for your consideration.

You can use Aspose.Excel to do it. Following is a simple sampe. You can extend it to meet your need.

using System;
using System.IO;
using Aspose.Excel;
namespace FileEnum
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
Excel excel = new Excel();

string[] dirs = Directory.GetDirectories(args[0]);

string[] files = Directory.GetFiles(args[0]);

excel.Worksheets[0].Cells.ImportArray(dirs, 0, 0, true);
excel.Worksheets[0].Cells.ImportArray(files, 0, 1, true);

excel.Save(“d:\files.xls”, FileFormatType.Default);
}
}
}