NPOI 添加行

                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);
                    }

                }

 

posted on 2013-08-03 22:15  gwazy  阅读(6523)  评论(1编辑  收藏  举报

导航