# [Tex/LaTex] Include data from LibreOffice Calc or MS Excel

exceltables

I'd like to use LibreOffice Calc or MS Excel to create and edit spreadsheets and include these in LaTeX (LuaLaTeX would be fine, too). It is necessary for me to get calculated values like SUM(C2:C5) as well.

So far I've tried odsfile and exceltex. Where odsfile didn't work at all, exceltex did work but ignored calculated values.

Has anyone successfully tried to include spreadsheet data with calculated values?

Update

This question is not the same as "I'd like a easy interface for LaTeX-Tables", as I look for a more comprehensive solution. We use spreadsheets for modeling our problems. When we refine our models, I'd like to update the TeX-based reports without exporting/importing many tables.

That said, odsfile works pretty much as I wanted to.

Thanks for your comments and suggestiongs so far. Do you know any other solutions like odsfile?

In excel use the concatenation command to translate the cells to have the & inserted to the left at a mirror of the columns somewhere to the right of your columns.