How to read excel file using Freemarker function

[bestfri...@gmail.com]

Hi

Could you please help me ,how to read excel using freemarker function with sample WI or any tuitorial using it?

i found the below in usr guide but i m not sure how to use the below in real scenario.

read_excel_cells(file_id, cells,format): returns content of a given cell (row, column) of a worksheet of an excel file downloaded on RunMyProcess. file_id is identifier of the file on RunMyProcess, cells is a json structure : [{"worksheet":"worksheet1","cells":[{"row":"4","col":"3"}]}] or [{"worksheet":"worksheet1","cells":[{"row":"3","col":"1"},{"row":"3","col":"2"},{"row":"3","col":"3"}]}] or [{"worksheet":"worksheet1","cells":[{"row":"4","col":"1"},{"row":"4","col":"2"},{"row":"4","col":"3"}]},{"worksheet":"worksheet2","cells":[{"row":"2","col":"1"},{"row":"2","col":"2"},{"row":"2","col":"3","format":"%.3f"}]}], format is optional : "format":"%d" or "format":"%.5f" (5 numbers after decimal : cf. java number format).... To extract result, syntax will look like : ${myresult.worksheet1["4"]["2"]}

[Gareth Thiveux]

Hi,

As you've mentionned, it's a freemarker function, it's to be used within a process and cannot be used in a Web Interface.

You should then plug a composite API to your interface, call this function within the composite API, and use the computed result of the Composite API in your interface.

Here's the tutorial about Composite API : https://sites.google.com/a/runmyprocess.com/user-guide-runmyprocess/3---developer-guide/web-interface/how-to-design/create-a-composite-api

Regards,

Gareth THIVEUX

Pre-Sales Consultant / Consultant Avant-Vente

 Fujitsu RunMyProcess

22 rue Chauchat, 75009 Paris - France (GMT+1)

contact  : gthi...@runmyprocess.com

mobile  : +33 (0)6 86 47 46 79

website : Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

2013/8/23 <bestfri...@gmail.com>

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/c1c54450-58d0-42c9-ac60-8d921712cd42%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.