I have fixed cells values which are replaced when I open template. It works.
Then I should add dynamic columns(sometimes 5, sometimes 10, and so on...) it depends on how many weeks I have in database.
5 columns for each week. And each week is filled from the same procedure, just different weekID parameter.
And this cells should be refreshed when user clicks the button.
Is it possible to add the same connections with different command text(only different week id in sp call) for each set of values?
Should i add this with closedXML and refresh them with macro on button click or should I completly add them with macro?
In last case I have to add all weekIDs that macro would know for how many weeks it must call stored procedure and create columns values.