CODEWITHSUNDEEP
c#.netvisual-studio
SplatXX3
SplatXX3

Reputation: 21

How can I read/write to an Excel template (.xltx) from C#?

I have ReportTemplate.xltx in my Visual Studio solution/project. How can I read and write data from my ExcelReport.DataGrid using my ReportTemplate.xltx template in my solution?

Basically I want to put the data in my datagrid into a new excel file using my report template.

How can I do that?

Upvotes: 0

Views: 893

Answers (1)

Philipp Schmid
Philipp Schmid

Reputation: 5828

The Open XML SDK from Microsoft allows you to work with the XSLX files using c# without requiring Excel to be installed.

I assume it also covers XLTX files (but I haven't confirmed it myself).

Upvotes: 1

Related Questions