0 votes
319 views
in Integrations by

2 Answers

0 votes
by (13.5k 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 242 views
0 votes
1 answer 319 views
0 votes
0 answers 64 views
0 votes
2 answers 440 views
asked Oct 16, 2017 in Coach Views by qaziMateen (120 points)
0 votes
0 answers 18 views
0 votes
1 answer 136 views
0 votes
0 answers 79 views
0 votes
0 answers 64 views
0 votes
0 answers 133 views
0 votes
1 answer 403 views
...