EPPlus - 如何使用模板 [英] EPPlus - How to use a template

问题描述

我最近发现EPPlus（ http://epplus.codeplex.com/ ）。
我已经在我的项目的所有风格的列标题的Excel .xlsx文件。
我看了他们的网站上，你可以使用模板。

I have recently discovered EPPlus (http://epplus.codeplex.com/). I have an excel .xlsx file in my project with all the styled column headers. I read on their site that you can use templates.

有谁知道如何或能够提供如何使用我的template.xlsx文件，EPPlus代码示例？我想能够简单地载入我的数据到行，而不与标题搞乱。

Does anyone know how or can provide code sample of how to use my template.xlsx file with EPPlus? I would like to be able to simply load my data into the rows without messing with the headings.

推荐答案

我最终的解决方案一起去：

The solution I ended up going with:

using System.IO;
using System.Reflection;
using OfficeOpenXml;

//Create a stream of .xlsx file contained within my project using reflection
Stream stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("EPPlusTest.templates.VendorTemplate.xlsx");            

//EPPlusTest = Namespace/Project
//templates = folder
//VendorTemplate.xlsx = file

//ExcelPackage has a constructor that only requires a stream.
ExcelPackage pck = new OfficeOpenXml.ExcelPackage(stream);

之后，你可以使用你想在从加载的.xlsx文件的ExcelPackage的所有方法模板。

After that you can use all the methods of ExcelPackage that you want on an .xlsx file loaded from a template.

这篇关于EPPlus - 如何使用模板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！