Better than everI've found that the pandas package in python handles with excel files and produces tables in csv too, so it can be used to read excel files as input, process a little and output csv tables which can be read by LyX as external documents (child)
The panorama becomes interesting! Alex