1. i want to read .xls file without help of MS office.
2. How to get used Range in .xls file
1. Use the static Infragistics.Excel.Workbook.Load method to read an existing .xls file.
2. Currently, there is no easy way to determine the range of cells with data in a worksheet. I would recommend submitting a feature request for this: http://devcenter.infragistics.com/Protected/RequestFeature.aspx. You can also check out the code posted by me in this thread: http://forums.infragistics.com/forums/t/2042.aspx. It explains how to manually count rows and columns with data. It can be modified slightly to determine the bounds of the worksheet.