NPOI 添加行

最新推荐文章于 2024-07-23 19:01:59 发布

weixin_34161083

最新推荐文章于 2024-07-23 19:01:59 发布

阅读量497

点赞数

文章标签： c#

                IRow sourceRow = sheet1.GetRow(3);
               
                for (int i = 0; i < dt.Rows.Count-1; i++)
                {

                    IRow row = sheet1.CreateRow(4 + i);
                    row.Height = sourceRow.Height;
                    for (int m = sourceRow.FirstCellNum; m < sourceRow.LastCellNum; m++)
                    {
                        ICell cell = row.CreateCell(m);
                        // cell.SetCellValue("0");
                        ICellStyle cellStyle = sourceRow.Cells[m].CellStyle;
                        cellStyle.Alignment = HorizontalAlignment.CENTER;
                        cell.CellStyle = cellStyle;

                        cell.SetCellType(sourceRow.Cells[m].CellType);
                    }

                }