Question

用jxl修改excel文件时，怎么复制插入某行

Answer 1

HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(newpath));

HSSFSheet sheet = workbook.getSheetAt(0); //获取工作表

HSSFCell cell = sheet.getRow(j).getCell((short) i);
cell.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setCellValue(value); //往单元格放值

i与j分别代表所在的列与行，

Answer 2

能否在工作表被保护的状态下插入行或列？怎么设置？