0 votes
281 views
in Integrations by

2 Answers

0 votes
by (11.7k points)
BP-3 has a very good toolkit for working with xls, with advanced formatting capabilities
0 votes
by (340 points)
Hi,

There are multiple ways to come to a solution. My particular use case was to read an excel file content using BAW V.19 on the Cloud

The way I resolved this was to upload the document some how into the server (which is hard because in the cloud I dont have access to servers nor file paths), then was to access the file using apache poi and finally extract the data. Here the steps:

First, I had to identify how to upload a document in the BPM ECM to handle the document. This is the easieast part but tricky, because depending on the toolkit you can use multiple components, in my case I used a Document Explorer. Once uploaded I catch the documentId from the document uploaded event

Second I had to use a Content Integration Task to access the document, I passed the document Id and then I get the documentObject

Third, I built a java application with POI: For this step you can import the poi jars in your process app and use the api methods to access the content, but in my case I built a java app (its easier to debug and faster to code) once was ready I packed into a jar and imported in the process app. All I had to do is to pass the content to a method that I created, documentObject.content, from that content you can create an Input Stream which can be used to create a Workbook object under POI

Hope this info helps and if details needed don't hesitate on asking

-Jose

Related questions

0 votes
1 answer 227 views
0 votes
1 answer 291 views
0 votes
0 answers 62 views
0 votes
2 answers 427 views
asked Oct 16, 2017 in Coach Views by qaziMateen (120 points)
0 votes
0 answers 16 views
0 votes
0 answers 5 views
0 votes
1 answer 132 views
0 votes
0 answers 76 views
0 votes
0 answers 60 views
0 votes
0 answers 124 views
0 votes
1 answer 381 views

515 questions

423 answers

81 comments

1.6k users

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
...