cancel
Showing results for 
Search instead for 
Did you mean: 

Dashboard - Excel sheet with macros data need to show in Dashboard

Former Member
0 Kudos

1)      Excel file with 3 sheets.

2)      Excel uses macros and data from sheet1 and sheet2 places output in sheet3.

3)      On Dashboard some single values components will be used for analysis and that

Interactive data from single value components need to be taken out of dashboard.

4)      Need to do calculations with sheet3 data. (single value components data and sheets3 data)

  1. i.e No calculation within the Dashboard Excel sheet should be done.

   Final calculated/Analyzed data need to be shown on Dashboard and able to export the data to Excel after Analysis.

   with no manual loading of data from import or export option in dashboard .

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Santosh,

Dashoard desgn (Xcelsius) will not support Macros, but we can import the spreadsheet but it will disable all of them during runtime.

Based on your requirement i can suggest you an alternative solution. If you are more familiar with Macros then create a macro which throws your output data (spreadsheet 3 data) in to an XML file.

Access this xml file through the XML data button or XML Maps button.

Hope this idea might help you

Regards,

Anjani Kumar C.A.