Metadata generator - Overview sheet

Mar 31, 2014 at 1:29 PM
Hi Tanguy,

The only advantage I still have with my personal generator, is that it creates a link to each entity on the overview sheet.
If you decide to export all entities, the list of sheets can become quite long.
And just to make it 100% interactive, I also added a link back to the overview sheet on each separate sheet.

We use this code for making a link , Adding a link to sheet 1 cell A1 with a caption of Entity List
writer.WriteLine(@" <Cell ss:StyleID=""s16"" ss:HRef=""#{1}!A1""><Data ss:Type=""String"">{0}</Data></Cell>", "Entity List", "Entity_List");

PS : We also export name of the filtered view on the overview, might be usefull to add this too.

Sven Peeters
Mar 31, 2014 at 2:23 PM
Thanks for all these information Sven,

I will see when I have time to work on this