On my page I have an attached Excel spreadsheet file. I want to show its contents on the page. But also I want to use some additional rendering with it.
The Excel macro shows the spreadsheet as a table where I have little to no control.
Instead I would prefer to generate a table based on the data. For example I would like to make a link to image based on user name. The address is generated with a simple pattern with user name within it. In the spreadsheet I want to keep just the username but the generated table should show image for the URL.
I thought about using Report Table macro as it seems to let me highly customize the final table. But I wasn't able to make it use spreadsheet data. I tried Local Reporter but nothing seemed to work.
Is there any way?
