I have been given a huge excel file with a lot of data and formulas, and I need to access the functions implemented in it to create a web service running on MacOSX. At first I tried to use the POI to access its functionality with Java, but unfortunately, the POI does not support some functions, such as MINVERSE, TRANSPOSE, MMULT and others, and it was especially difficult for me to implement them (also see this question ).
Is there a programmatic way to access an Excel worksheet? I found RCOMClient for R, but it looks like it runs onl on Windows. Perl, Python, R, Octave, C ++, Java, or whatever, if that’s fine, provided that it provides full functionality according to Excel formulas.
Python Excel : why Python Excel is NOT an option for my problem. The textbook says that:
A relative link is only useful if you have external knowledge about which cells can be used as a source. Many formulas found in Excel files include function calls and several links and are not useful and may be too difficult to evaluate. The full computing engine is not included in xlrd.
Unfortunately, I need very good support for the Excel engine.
source
share