C#操作Excel(NPOI)

[{"title":"（ 41 个子文件 6.73MB ） C#操作Excel(NPOI)","children":[{"title":"NPOI","children":[{"title":"3. 项目实践","children":[{"title":"3.3生成一张工资单.mht <span style='color:#111;'> 519.47KB </span>","children":null,"spread":false},{"title":"3.2生成九九乘法表.mht <span style='color:#111;'> 407.03KB </span>","children":null,"spread":false},{"title":"3.4从Excel中抽取文本.mht <span style='color:#111;'> 591.19KB </span>","children":null,"spread":false},{"title":"3.5巧妙使用Excel Chart.mht <span style='color:#111;'> 857.20KB </span>","children":null,"spread":false},{"title":"3.1基于_xls模板生成Excel文件.mht <span style='color:#111;'> 483.14KB </span>","children":null,"spread":false},{"title":"3.6导入Excel文件.mht <span style='color:#111;'> 669.77KB </span>","children":null,"spread":false}],"spread":true},{"title":"2. 使用NPOI生成xls文件","children":[{"title":"2.1.2 创建DocumentSummaryInformation和SummaryInformation.mht <span style='color:#111;'> 704.85KB </span>","children":null,"spread":false},{"title":"2.1.6 创建页眉和页脚.mht <span style='color:#111;'> 531.20KB </span>","children":null,"spread":false},{"title":"2.1.1 创建Workbook和Sheet.mht <span style='color:#111;'> 481.14KB </span>","children":null,"spread":false},{"title":"2.1.3 创建单元格.mht <span style='color:#111;'> 417.72KB </span>","children":null,"spread":false},{"title":"2.1.4 创建批注.mht <span style='color:#111;'> 460.67KB </span>","children":null,"spread":false}],"spread":true},{"title":"2.2 单元格操作","children":[{"title":"2.2.7设置单元格的宽度和高度.mht <span style='color:#111;'> 427.15KB </span>","children":null,"spread":false},{"title":"2.2.1设置格式.mht <span style='color:#111;'> 566.90KB </span>","children":null,"spread":false},{"title":"2.2.2 单元格合并.mht <span style='color:#111;'> 433.89KB </span>","children":null,"spread":false},{"title":"2.2.6设置单元格的背景和图案.mht <span style='color:#111;'> 466.24KB </span>","children":null,"spread":false},{"title":"2.2.5设置单元格字体.mht <span style='color:#111;'> 492.31KB </span>","children":null,"spread":false},{"title":"2.2.4设置单元格边框.mht <span style='color:#111;'> 434.21KB </span>","children":null,"spread":false},{"title":"2.2.3单元格对齐相关设置.mht <span style='color:#111;'> 486.29KB </span>","children":null,"spread":false}],"spread":true},{"title":"2.3 使用Excel公式","children":[{"title":"2.3.7Lookup函数.mht <span style='color:#111;'> 421.76KB </span>","children":null,"spread":false},{"title":"2.3.4字符串相关函数.mht <span style='color:#111;'> 391.09KB </span>","children":null,"spread":false},{"title":"2.3.6CountIf和SumIf函数.mht <span style='color:#111;'> 388.05KB </span>","children":null,"spread":false},{"title":"2.3.5IF函数.mht <span style='color:#111;'> 403.09KB </span>","children":null,"spread":false},{"title":"2.3.9通过NPOI获得公式的返回值.mht <span style='color:#111;'> 389.78KB </span>","children":null,"spread":false},{"title":"2.3.1基本计算.mht <span style='color:#111;'> 366.24KB </span>","children":null,"spread":false},{"title":"2.3.3日期函数.mht <span style='color:#111;'> 386.83KB </span>","children":null,"spread":false},{"title":"2.3.2SUM函数.mht <span style='color:#111;'> 419.26KB </span>","children":null,"spread":false},{"title":"2.3.8随机数函数.mht <span style='color:#111;'> 359.73KB </span>","children":null,"spread":false}],"spread":true},{"title":"2.6 高级功能","children":[{"title":"2.6.1调整表单显示比例.mht <span style='color:#111;'> 464.99KB </span>","children":null,"spread":false},{"title":"2.6.2设置密码.mht <span style='color:#111;'> 473.52KB </span>","children":null,"spread":false},{"title":"2.6.5锁定列.mht <span style='color:#111;'> 479.60KB </span>","children":null,"spread":false},{"title":"2.6.3组合行、列.mht <span style='color:#111;'> 445.44KB </span>","children":null,"spread":false},{"title":"2.6.8生成下拉式菜单.mht <span style='color:#111;'> 512.07KB </span>","children":null,"spread":false},{"title":"2.6.6设置初始视图的行、列.mht <span style='color:#111;'> 413.30KB </span>","children":null,"spread":false},{"title":"2.6.7数据有效性.mht <span style='color:#111;'> 441.82KB </span>","children":null,"spread":false}],"spread":true},{"title":"1.认识NPOI.mht <span style='color:#111;'> 423.63KB </span>","children":null,"spread":false},{"title":"2.4 创建图形","children":[{"title":"2.4.1画线.mht <span style='color:#111;'> 422.38KB </span>","children":null,"spread":false},{"title":"2.4.5插入图片.mht <span style='color:#111;'> 411.25KB </span>","children":null,"spread":false},{"title":"2.5打印相关设置.mht <span style='color:#111;'> 501.53KB </span>","children":null,"spread":false},{"title":"2.4.3画圆形.mht <span style='color:#111;'> 357.00KB </span>","children":null,"spread":false},{"title":"2.4.2画矩形.mht <span style='color:#111;'> 357.09KB </span>","children":null,"spread":false},{"title":"2.4.4画Grid.mht <span style='color:#111;'> 404.00KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]