excel-templates

Using Excel sheet as a template vs. a "real" Excel template in OpenXML

Does anyone have any good answer what kind of difference there is between using some arbitrary pre-formatted Excel 2007 *.xlsx file as a template, loading it in my C# app, and filling up some of its cells with data using the Microsoft OpenXML SDK versus creating specific Excel templates (*.xltx) files and using those as basis for...

softartisans excelwriter is telling me "binding mentioned in %%value couldn't be found in current group", but it is.

My template looks like this: %%group %%header %%value(section1.sectionName) %%=section1.col1(Optional) %%=section1.col2(Optional) %%=section1.col3(Optional) %%footer %%endgroup I create my table like so: Dim dtMain As New DataTable dtMain.Columns.Add("sectionName") For i As Integer = 1 To 3 dtMain.Columns.Add("col"...