aspose.cells 带模板导出excel

模板格式:

 

#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))
                {