How to count number of Excel files from a folder using c#?

Question

I need to count the number of excel files,pdf files from a directory.

I have Counted the total number of files from a directory using

 System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(@"D:\");
 int count = dir.GetFiles().Length;

Any Suggestion?

Jeff Mercado · Accepted Answer · 2011-05-27T11:21:11.587

5

Here's a LINQ solution.

var extensions = new HashSet<string>(StringComparer.OrdinalIgnoreCase)
{
    ".xls",
    ".xlsx",
    ".pdf",
};
var baseDir = @"D:\";
var count = Directory.EnumerateFiles(baseDir)
                     .Count(filename =>
                                extensions.Contains(Path.GetExtension(filename)));

edited May 27 '11 at 11:21

answered May 27 '11 at 05:48

Jeff Mercado

129,526
32
251
272

1

+1 nice use of EnumerateFiles. Also "why wouldn't it ever be possible" made me smile. – Conrad Frix May 27 '11 at 05:52
@Conrad: Yeah, it's just one of those things that always gets to me. It always strikes a nerve when I hear the words, "is it possible?" when there are tools we use every day that does "the impossible." But that part is gone now. :) – Jeff Mercado May 27 '11 at 11:23

score 2 · Answer 2 · answered May 27 '11 at 05:38

2

Use SearchPattern in GetFiles method.

dir.GetFiles("*.XLS");

answered May 27 '11 at 05:38

Umesh CHILAKA

1,466
14
25

score 1 · Answer 3 · answered May 27 '11 at 05:43

1

int count = 0;
foreach (string file in Directory.GetFiles(@"D:\"))
{
    if (file.EndsWith(".pdf") || file.EndsWith(".xls"))
    {
        count++;
    }
}

answered May 27 '11 at 05:43

aligray

2,812
4
26
35

score 0 · Answer 4 · edited May 27 '11 at 05:45

0

   var count = System.IO.Directory.GetFiles(@"D:\")
               .Count(p => Path.GetExtension(p) == ".xls");

edited May 27 '11 at 05:45

Zach Johnson

23,678
6
69
86

answered May 27 '11 at 05:39

Aravind

4,125
1
28
39

can you compare strings like that? Shouldn't be .Equals()? – surfen May 27 '11 at 05:44
1

@surfen: if it were Java it would need to be `.equals()`; but in C# it doesn't matter. See http://stackoverflow.com/questions/1659097/c-string-equals-vs – Zach Johnson May 27 '11 at 05:47

score 0 · Answer 5 · answered May 27 '11 at 05:40

0

String[] excelFiles=Directory.GetFiles("C:\\", "*.xls");

answered May 27 '11 at 05:40

crypted

10,118
3
39
52

score 0 · Answer 6 · answered May 27 '11 at 05:42

0

int count = Directory.GetFiles(path).Count(f =>(f.EndsWith(".xls") || f.EndsWith(".xlsx")));

answered May 27 '11 at 05:42

abhilash

5,605
3
36
59

score 0 · Answer 7 · answered May 27 '11 at 05:45

0

simple

int count = dir.GetFiles("*.txt").Length + dir.GetFiles("*.pdf").Length

answered May 27 '11 at 05:45

Binil

6,445
3
30
40

How to count number of Excel files from a folder using c#?

7 Answers7