hi Prayank: to Question 1:it seems there's no flex's API to read XLS file...
to Question 2:filtering data function is certainly available,but flex did not provide data filter component.u should write codes to accomplish that.if u'll use sever side Java code to read database,how about using SQL to filter datas,in my opinion,this method saves alot of Flex codes but of course is a little bit lazy,and will cost extra time to complete the filtering. to Question 3:yes~i had done this before too,i directly changed XLS file to mdb files(Access'file) and use JDBC-ODBC drive to connect database. all the best~ P.S:if u find ways to read XLS file directly from flex app,i will be grateful if u tell me about it~