how to write a validate function for reading only excel file in xls and xlsx format

Question

How can i write a function to validate if file uploaded is not in excel file format ".xls or .xlsx" it will prompt error message. Any help would be appreciated.

What i've tried so far. Below function will prompt error message too if read excel file in .xlsx format .

function verifyFile()
{

       if(document.mainform.ATTACH_FILE.value.search(/\.(xls)$/) == -1) {
        alert("Invalid filename extension!");
        return false;
    }
}

Expected result : accept both .xls and .xlsx format, prompt messsage if other than these format.

try changing your regex to this: `\.(xlsx?)$` – bruchowski Jan 28 '15 at 04:02 — bruchowski, Jan 28 '15 at 04:02

score 3 · Answer 1 · edited May 23 '17 at 12:06

3

You dont need regex to do that.

   var extension = document.mainform.ATTACH_FILE.split(".").pop();

   if (['xls','xlsx'].indexOf(extension) < 0) { 
        alert("Invalid filename extension!");
        return false;
   }

Check other examples in this answer

edited May 23 '17 at 12:06

Community

1
1

answered Jan 28 '15 at 04:06

levi

22,001
7
73
74

how to write a validate function for reading only excel file in xls and xlsx format

1 Answers1