I've been using
csvtools to read data from CSV files. Is there any way to read data directly from a ODS file, to put the data into a LaTeX document?
I don't think there is a LaTeX package for reading ODS (OpenDocument Spreadsheet) files directly. CSV files are text-based are therefore readable and parse-able by (La)TeX. However, ODS are (AFAIK) ZIP-ed XML files, which are a lot more complicated. You need to convert the ODS files first to CSV and then include it as such. This might be possible in the command line. More complex sheets (which don't fit in the CSV format) are not supported I guess.
In general LaTeX and OpenOffice/MS Office do not work well together and you can't simply move freely from one to the other.