Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have created a web service that provides me with sales data from our corporate ERP system. We are going to use this to drive some "dashboards" showing this data graphically.

For testing/ evaluation I would like to use a web service like a custom function to populate individual fields in a spreadsheet. I can't see how to d this easily in MS Excel (2007) but wonders if OpenOffice Calc has a capability.

My hope/expectation is that I type in a call the web service in each cell and e web service reply (a sales number relating to the web service call is returned and displayed in the cell.

My web service is called something like this: http://server:8080/SalesHistory?Year=2011&Month=10&Region=Europe&Channel=Web

As you can guess, this will return the value of sales for October'11 for the region/sales channel stated.

share|improve this question
add comment

3 Answers

I'm pretty sure you will have to do a little bit of programming (which can be done in e.g. Python, C++ or Java, or maybe even OOo/LibO Basic) to create your own Calc function. If you like to use Python, search the web for "python uno bridge" (or replace "python" with your favourite language).

(BTW: something similar is also possible in MS Excel really...)

share|improve this answer
add comment

I believe you can create a "Job" with Google Refine that can process data through a web service and drop it into the file format of your choice. Not sure what already exists for Open Document formats. Watch the videos here for more info:

http://code.google.com/p/google-refine/

share|improve this answer
add comment

Check out the new WEBSERVICE and FILTERXML functions in LibreOffice 4.2: http://lodahl.blogspot.de/2013/12/libreoffice-now-has-built-in-xml-parser.html

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.