I did it by using a perl module, Spreadsheet::ParseExcel which can be used to convert the xls file to a text file. Then used QT to read in the text file and format accordingly.