Currently lyx deals with *.xls files only, while the Excel world rather turns around .xlsx files. It would be great if lyx could be extended including the file handler where ssconvert appears to faithfully extract data from *.xlsx files.
I am not subscribed to the devel list, so please copy me in if you need any more information on this from my side. Many thanks, J.