In order to genrate an XLSX file without deep diving into Open XML SDK 2 and/or SpreadsheetML details we have decided to do the following:
As an example, we think of a "download" web service, which on a client's request with parameters returns an XLSX file as file attachment.
After some research and Internet crawling, we've come to the conclusion that the best tool for creation of XLSX template is... Microsoft Office Excel. Thus, we suggest the following procedure for creating a template:
xl/worksheets/sheet*.xml
,
xl/drwaings/drawing*.xml
and
xl/charts/chart*.xml
with the corresponding XSLT files.
P.S. We know about SQL Server Reporting Services, which is a powerfull tool that allows to solve most of our reporting tasks. We, however, talking about a lightweight service that: