Question

2
Replies
2326
Views
UdayShankarN Member since 2016 2 posts
Wipro
Posted: March 1, 2019
Last activity: March 2, 2019
Closed

Parsing Excel Sheet using MSOParseExcelFile extracts formula along with cell data

Hello ,

We are facing problem parsing Excel Sheet using MSOParseExcel control. It extracts formula along with cell data. We follow OOTB method by using an excel template and the activity MSOParseExcelFile. The value of the cells which we read are actually populated based on a formula from a different sheet. After parsing. the clipboard properties contains the formula appended with the cell value instead of cell value alone.

Any help will be greatly appreciated.

Regards

Uday

Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn