模板格式:
#region 带模板带出excel
public HttpResponseMessage ExportExcelModel(dynamic obj)
{
int num = 0;
long formId = obj.id;
string selectedModel = obj.selectedModel;
string tempFile = HttpContext.Current.Server.MapPath("~/ExcelModel/" + selectedModel).ToString();//获取模板路径
var formData = "你的数据";
if (formData.Count() != 0)
{
var dic = new Dictionary<string, string>();
Workbook workbook = new Workbook();
workbook.Open(tempFile);
Cells cells = workbook.Worksheets[0].Cells;
DataTable dt = cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true);
string filePathId = formData[0].formName + formId * 4564;// 防止表单名称重复,加上表单的唯一值id
string saveFilePath = HttpContext.Current.Server.MapPath("~/SaveExcel/" + filePathId).ToString(); // 保存表格
try // 为空的时候会提示找不到文件夹
{
ClearDownloadDirectory(saveFilePath, ""); // 保证每次导出时zip文件都是最新的
}
catch { }
if (!Directory.Exists(saveFilePath))
{