Prompt a console utility for reading and editing tabular files (xls, csv, etc.)

Question

linux

Hello cheaters!
There is a Debian server
. The task is to read the values ​​of the required cells from an Excel compatible file and, preferably, with the results of calculating formulas. And it will be absolutely delicious if you can also write new values ​​\u200b\u200bin the desired cell.
Advise the console utility if such exists.

Thanks in advance.

Answer 1

To work with Excel files in the same python, for example, there is this - pypi.python.org/pypi/xlutils .
And there are no problems with CSV at all - parsing is the simplest there.

Answer 2

you understand that vryatli exists. You can only edit the new xlsx format - since there is xml. Here zhlya it under php is .
Do it easier. Ask to upload a csv file from Excel - and play with it as you like.