Log in to AnswerLog in to Follow
Pavan Suthar Jethmal
16Views
2Comments
Solved
[Advanced Excel] Reading MS Excel cell field if vb script/macro is applied
Question
Reactive
Component
Forge
Import/Export Data
OutSystems 11
Advanced Excel
Forge component by Carlos Freitas
Application Type
Reactive
Service Studio Version
11.10.0 (Build 34711)

Hello Team,

Greetings.

Hope everything is fine and well during the pandemic time.

I have a query regarding reading ms excel cell fields using outsystems is that - I have a dropdown feature in my excel file which shows/hide content (using vb script/macro ). I am able to read other non-macro /vb script content fields using ADVANCE EXCEL forge component. But not able to read macro/script connected field cell.

Is there a way to extract content fields, build with excel macro?

Cheers. Thank you in advance.

Capture.PNG

0
0
on 2020-12-09

Hi Pavan,

two suggestions

option 1- create an extra column in your excel  which maps to the one with the VB script code.

In Serv Studio read this new column instead of the other one

option 2-Regardless doing a vb script code in excel file to calculate a value, why not apply that rule for that column while reading the data in Serv Studio

Hope that it helps

0
0
on 2020-12-23

Apology Alexandre Yip for my delay response. It got work. Thanks. 

Cheers.


0
0
on 31th Jan
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.