如何实现,EXCEL画表格问题?

Question

如何使生成的EXCEL表格打印的时候有表格线

Answer 1

建意使用Excel模板+VBA可以搞定.

Answer 2

HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet();
HSSFRow row = sheet.createRow((short) 0);
HSSFCell cell = row.createCell((short) 0);
HSSFCellStyle style0 = workbook.createCellStyle();
HSSFFont font0 = workbook.createFont();

sheet.setColumnWidth((short) 0,(short) (13*256)); 
sheet.setColumnWidth((short) 1,(short) (31*256)); 
sheet.setColumnWidth((short) 2,(short) (6.5*256)); 
sheet.setColumnWidth((short) 3,(short) (6.5*256)); 
sheet.setColumnWidth((short) 4,(short) (31*256));
row.setHeight((short) (850));

font0.setFontHeightInPoints((short) 20);
font0.setFontName("宋体");
font0.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
style0.setFont(font0);
style0.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style0.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

cell.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
cell.setCellValue("档案信息");
cell.setCellStyle(style0); row = sheet.createRow((short) 1);
row.setHeight((short) 350);
cell = row.createCell((short) 0);
cell.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
cell.setCellValue("档案编号");