Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

C# Regex that matches Excel file extensions

Tags:

c#

regex

excel

I need a regex for my file upload to choose only Excel files I tried using this as my pattern(below)

Regex reg = new Regex("^.\.(xls|xlsx)");

Unfortunately I can't escape the "\." part of the the pattern.

like image 390
zxc Avatar asked Oct 09 '13 05:10

zxc


People also ask

What C is used for?

C programming language is a machine-independent programming language that is mainly used to create many types of applications and operating systems such as Windows, and other complicated programs such as the Oracle database, Git, Python interpreter, and games and is considered a programming foundation in the process of ...

What is the full name of C?

In the real sense it has no meaning or full form. It was developed by Dennis Ritchie and Ken Thompson at AT&T bell Lab. First, they used to call it as B language then later they made some improvement into it and renamed it as C and its superscript as C++ which was invented by Dr. Stroustroupe.

Is C language easy?

C is a general-purpose language that most programmers learn before moving on to more complex languages. From Unix and Windows to Tic Tac Toe and Photoshop, several of the most commonly used applications today have been built on C. It is easy to learn because: A simple syntax with only 32 keywords.

Is C programming hard?

C is more difficult to learn than JavaScript, but it's a valuable skill to have because most programming languages are actually implemented in C. This is because C is a “machine-level” language. So learning it will teach you how a computer works and will actually make learning new languages in the future easier.


2 Answers

A better method would be to use Path.GetExtension, then compare the results:

var filepath = @"C:\path\to\file.xls";
var extension = Path.GetExtension(filepath).ToUpper();

if (extension == ".XLS" || extension == ".XLSX") {
    // is an Excel file
}

To answer the original question, to match filepaths with.xls or .xlsx as a file extension, use the following regex:

var regex = new Regex(@".*\.xlsx?$");
like image 158
Brian Kintz Avatar answered Oct 04 '22 22:10

Brian Kintz


Just add another \ or add the @ in front of the string like so: "^.\\.(xls|xlsx)" or @"^.\.(xls|xlsx)"

Also, I am assuming that you shall be matching the extension of the file with that regex, and not the actual file name itself, since that regex will match anything which starts with .xls or .xlsx.

like image 32
npinti Avatar answered Oct 04 '22 22:10

npinti