Pavan Suthar Jethmal
Rank: #8792
14Views
1Comments
[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
69
Published on 27 Aug 2019
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
Copy link to comment
Alexandre Yip
Rank: #2517

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
Copy link to comment