Reading excel

, ,
1

Hi,
I need to read an excel and pass all values to my IS service. How can I do that?
I saw something by using file input, then use a java code to read and get all values, but its not working.
Thanks!

2

check: Apache POI, you need to load its jars into IS and write some Java code for it.

HTH,

3

Explore the code samples posted on the SAG tech community. You will find a code sample to read excel file/csv file.

4

There’s no code sample for this functionality. :frowning:

5

Please brief your requirement and functionality?

6

The user will upload an excel, I need to get cell values and work with it on IS.

7

Where does the user upload the excel, in a folder location or ???

Share the sample excel file so that I can write a pseudo code.

8

It will be uploaded on CAF using File Input

Here’s an excel sample…

I think that I need convert this values to a string list or a doc list, in java… and then pass this parameter to my IS service, right? But I don’t know how to get this values and put in a list.

Thanks!

excelsample.png
excelsample.png466×617 19.6 KB

9

I will try to share you the code sample ASAP.

Meanwhile try to download the below sample and do the changes:

[url]http://techcommunity.softwareag.com/ecosystem/communities/public/webmethods/products/caf/codesamples/20130305092051902/index.html[/url]

10

Hi Even i need to read an Excel file from IS folder and need to process it…I have downloaded the code but it is not working …