Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
James_Smith
Contributor
Contributor

Unable to create Straight Table using macro

Hello,

I would like to create a Straight Table using data from Excel.

However, when I load the data with the macro, it is always loaded as separate listboxes and not a table.

Why does this happen? I've google everywhere, but cannot find anything similar.

 

 

LOAD A, 
     B, 
     C, 
     D, 
     E, 
     F, 
     G, 
     H, 
     I, 
     J, 
     K, 
     L, 
     M
FROM
[C:\*.xlsx]
(ooxml, no labels, table is [Equipment list]);

 

 

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

There is no macro-code else just a normal script to load from an Excel. If this loaded you will have a table within the data-model which you could display within the UI in a table-chart.

View solution in original post

1 Reply
marcus_sommer

There is no macro-code else just a normal script to load from an Excel. If this loaded you will have a table within the data-model which you could display within the UI in a table-chart.