Validation for Excel File while uploading file

Just filter the extensions

string ExcelFile;
string[] FindFiles = Directory.GetFiles("C:\\What_ever_Folder\\", "*.xls");
foreach (int ExcelFile in FindFiles) {
 ComboBox1.Items.Add(ExcelFile);
}

vbturbo

Hi,

Thanks for your response

I want the validation should be done at client side than at server side

On server side this can be done, help me in clisnt side validation

Many Thanks

try this expression

([a-zA-Z-]:(\\w+)*\\[a-zA-Z0_9]+)?.xls

kosturdur

Hi,

I tried the expression you have given but not worked

I mean I tried

([a-zA-Z-]:(\\w+)*\\[a-zA-Z0_9]+)?.xls

This is quite urgent for me. Or If you have some other way of doing it.

I want the validation to perform on client side and message to display on screen rather than javascript alert

Many Thanks

Please help me

Hi

Try this

 [a-zA-Z].*\bxls\b

Or

[a-zA-Z0_9].*\\bxls\\b

Hi,

I have tried msdn code for mp3. It is not working

Do you some other alteranate to do this task

May be using Customvalidator or whatever

After my validation is done on client side than proper method should call on server side

Many Thanks

Validates anything with the extension .xls

Yes, I forgot to mention that I do not require javascript alerts

Many Thanks

Finds

xxx.xls
9.xls
my.xls

have you tryed the above examples ?

vbturbo

Hi

this pattern i've just tested with the System.Text.RegularExpressions
and is valid

        public bool IsValidExcelfile(string strIn)
        {
            string pattern = "[a-zA-Z0_9].*\\bxls\\b";
            Regex expression = new Regex(pattern);
            return expression.IsMatch(strIn);
        }

vbturbo

Hi,

Thanks for your reply,

No it is not working

I wrote

<asp:RegularExpressionValidator
  id="RegularExpressionValidator1" runat="server"
  ErrorMessage="Only Excel (.xls) files are allowed!"
  ValidationExpression="[a-zA-Z0_9].*\\bxls\\b"
 ControlToValidate="FileUpload1"></asp:RegularExpressionValidator>

I have selected the path
D:\dinesh\Project\1\Documents\Sample MTOs EE108 (DEWP-06-6100EK)(1).xls

and I get the error message
Only Excel (.xls) files are allowed


This is a small validation thing which I want

Please help me in resolving this issue. If this way it is not resolving than guide me some other way use anything else

But not javascript alerts

Many Thanks

Try validate before displaying the error message.
Your above code will never reach the validation part.

<asp:textbox id="textbox1" runat="server"/>
<asp:RegularExpressionValidator id="valRegEx" runat="server"
    ControlToValidate="textbox1"
    ValidationExpression=".*@.*\..*"
    ErrorMessage="* Your entry is not a valid e-mail address."
    display="dynamic">*
</asp:RegularExpressionValidator>

vbturbo

Thanks vbturbo,

This works fine

Is it possible that we check the modified or created date of the file is current date at the cleint side.

I mean before uploading the file

Great.

Many Thanks