Using Calc components from within a server environment

[marklawford]

Hi,

we are building a web application which imports data held in spreadsheets supplied by our distributed user base. Trouble is that often, the sheets have formulae embedded in them, which breaks our POI-HSSF parsing engine.

One thought we had (in addition to supplying a macro to make the sheet safe) is to look at using the Calc API to make the sheet safe after upload and before import where the provider failed to do so.

Can we access and run the Calc API from within a server evironment? Obviously, we can't see dialogs popping up on our linux server, so it would have to be seemless.

Is there a way of accessing the Calc API from within a server environment and does the API allow for copy and paste values?