I have a client that is asking for an Excel file to be "validated" before (client side) it is uploaded to the server through an ASP.NET web app. The validation would consist of checking for a number of columns and then checking that the values in each of the rows for each column meets spec.
Is it possible to open a excel file on the client side and check its contents?
I'm guessing not. The only thing I could come up with is possible an ActiveX control on a page that the client would "allow" to access the local file and perform the validations through that control.