Re: Reading MS Excel 2010 document (149 Views)
Reply
Occasional Advisor
Posts: 8
Registered: ‎02-28-2014
Message 1 of 3 (186 Views)
Accepted Solution

Reading MS Excel 2010 document

Hello Experts, I have a requirement to create a VuGen script which opens an excel file from a shared folder. Reads the content of the file and validates it. 

I am using LR 11.03.

 

This script is meant to be run by BPM for monitoring purpose. Therefore I cannot use VBScript or VB to launch open the document and read the content as BPM wont render the excel. 

 

I want to know if there are appropriate MS libraries that I can use in COM/DCOM protocol. Vugen Protocol advisor seemingly did not help.

 

Appreciate your respones.

 

Thanks,

Alaksh

 

Frequent Advisor
Posts: 33
Registered: ‎11-29-2013
Message 2 of 3 (158 Views)

Re: Reading MS Excel 2010 document

I haven't done any scripting for BPM, but you should be able to run a Java vuser if all you need to do is open an Excel file and validate the contents?

 

Have a look at Apache POI for reading and validating Excel files (both .xls and 2007+ .xlsx files):  http://poi.apache.org/spreadsheet/index.html

Occasional Advisor
Posts: 8
Registered: ‎02-28-2014
Message 3 of 3 (149 Views)

Re: Reading MS Excel 2010 document

Thanks Hakan.

 

Works like a charm on VuGen and running successfully on BPM.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.