public void Excel() { string outName = "";// table.TableName; Workbook workBook = new Workbook(); workBook.Worksheets.Clear(); workBook.Worksheets.Add(outName);//New Worksheet是Worksheet的name Worksheet ws = workBook.Worksheets[0]; workBook.Worksheets[0].AutoFitColumns(); var modulars = ProjectCache.Design_ModularOrFuns.Where(p => p.ParentPremID == 0).ToList(); var k = 0; for (int i = 0; i < modulars.Count(); i++) { k++; var modular = modulars[i]; #region 主表 //(1)字段 var ttt = HtmlHelpersProject.PageFormEleTypes(modular).Where(p => p.PageFormEleSort != 1 && p.PageFormEleSort != 100 && p.PageFormEleSort != null && p.FormEleType != 8) .OrderBy(p => p.Page01FormEleSort); //PageFormEleSort = p.Page01FormEleSort; p.PageFormElePos = p.Page01FormElePos; p.FormEleType var DispNameCn = string.Join(",", ttt.Select(p => p.NameCn)); //(2)查询条件 var mmm = HtmlHelpersProject.QueryFormEleTypes(modular).Where(p => p.PageFormEleSort != null); var queryNameCn = string.Join(",", mmm.Select(p => p.NameCn)); //按钮 ws.Cells[k, 0].PutValue(modular.ModularName); ws.Cells[k, 1].PutValue(DispNameCn); ws.Cells[k, 2].PutValue(queryNameCn); #endregion #region 子模块 var modularsChilds = ProjectCache.Design_ModularOrFuns.Where(p => p.ParentPremID == modular.Design_ModularOrFunID).ToList(); for (var j = 0; j < modularsChilds.Count; j++) { k++; modular = modularsChilds[j]; ttt = HtmlHelpersProject.PageFormEleTypes(modular).Where(p => p.PageFormEleSort != 1 && p.PageFormEleSort != 100 && p.PageFormEleSort != null && p.FormEleType != 8) .OrderBy(p => p.Page01FormEleSort); //PageFormEleSort = p.Page01FormEleSort; p.PageFormElePos = p.Page01FormElePos; p.FormEleType DispNameCn = string.Join(",", ttt.Select(p => p.NameCn)); //(2)查询条件 mmm = HtmlHelpersProject.QueryFormEleTypes(modular).Where(p => p.PageFormEleSort != null); queryNameCn = string.Join(",", mmm.Select(p => p.NameCn)); //按钮 ws.Cells[k, 0].PutValue(modular.ModularName); ws.Cells[k, 1].PutValue(DispNameCn); ws.Cells[k, 2].PutValue(queryNameCn); } #endregion } workBook.Worksheets[0].AutoFitColumns(); workBook.Save("C:\\aaa.xls"); }