I'm a db guy making my first foray into formatted Excel documents and am being asked to populate a sheet similar to the image below. I'm looking for general guidance to understanding the Excel-specific terminologies I'll need to understand. I'll be using VS2013 and VSOTs and already see generally how to connect the db to the sheet (data will be driven from a SQL db). But populating the rows where merged and formatted cells are involved is a little less clear (pointers to relevant tutes would be a big help).
I think I'll want a better understanding of the ins and outs of template documents [note how the overall document is a collection of 3 sub documents with a header and footer - it didn't fit but grand totals are down there] or should I expect a loop within the app to simply paint each row according to the relevant formatting?
The relevant bit here is plugging db-based data into the formatted regions according to the sample - not merely linking SQL-based rows to Excel-based rows as is shown in most (all) samples i've come across so far.
[FOLLOWUP per questions]: Number of line items will vary. Subtotal calculations should be sheet-based given the possibility of post production, hand editing. The page shown is for one of several dozen different 'regions' so the banner itself is also dynamic. Basically you are looking at one week's worth of 'productions' - one titled 'Analyzing Decisions', another titled 'Public', the 3rd titled 'Seven Habits'. Then details of orders nested respectively. The number and titles of productions of any given week will vary.