NPOI读取操作excel

1、读取using (FileStream stream = new FileStream(@"c:\客户资料.xls", FileMode.Open, FileAccess.Read))
            {
                HSSFWorkbook workbook = new HSSFWorkbook(stream);
                MessageBox.Show(workbook.GetSheetName(0));
            }
读取字符串类型数据MessageBox.Show(sheet.GetRow(3).GetCell(4).StringCellValue); 读取数字类型数据NumericCellValue。判断单元格数据类型：读取GetCell(4).CellType，与HSSFCell类中定义的常量比较即可。判断使用区域：结束行号：LastRowNum。
写入Excel：HSSFWorkbook workbook = new HSSFWorkbook();
            HSSFSheet sheet = workbook.CreateSheet();
            HSSFRow row = sheet.CreateRow(0);
            row.CreateCell(0, HSSFCell.CELL_TYPE_STRING).SetCellValue("Hello");
            row.CreateCell(1, HSSFCell.CELL_TYPE_NUMERIC).SetCellValue(3.14);
            using (FileStream stream = new FileStream(@"c:\1.xls", FileMode.OpenOrCreate, FileAccess.ReadWrite))
            {
                workbook.Write(stream);
            }
读取excel：HSSFWorkbook workbook = new HSSFWorkbook(stream);
                    for (int i = 0; i < workbook.NumberOfSheets;i++ )
                    {
                        HSSFSheet sheet = workbook.GetSheetAt(i);
                        for (int rowIndex = sheet.FirstRowNum; rowIndex < sheet.LastRowNum; rowIndex++)
                        {
                            HSSFRow row = sheet.GetRow(rowIndex);
                            for (int cellIndex = row.FirstCellNum; cellIndex < row.LastCellNum; cellIndex++)
                            {
                                textBox1.AppendText(row.GetCell(cellIndex).ToString());
                            }
                        }
                    }

 

转载于:https://www.cnblogs.com/huangshuhua/p/6405646.html