共享备案网站,网页制作软件是哪个,网络科技公司 网站建设,中小企业网站制作不了如何使用Java设置电子表格的打印区域。(How to set the print area of a spreadsheet using Java.)问题描述 (Problem Description)如何使用Java设置电子表格的打印区域。解决方案 (Solution)以下是使用Java设置电子表格打印区域的程序。import java.io.File;import java.io.Fi…如何使用Java设置电子表格的打印区域。(How to set the print area of a spreadsheet using Java.)问题描述 (Problem Description)如何使用Java设置电子表格的打印区域。解决方案 (Solution)以下是使用Java设置电子表格打印区域的程序。import java.io.File;import java.io.FileOutputStream;import org.apache.poi.xssf.usermodel.XSSFPrintSetup;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class SettingPrintAreaToSpreadSheet {public static void main(String[] args)throws Exception {//Create a Work BookXSSFWorkbook workbook new XSSFWorkbook();XSSFSheet spreadsheet workbook.createSheet(Print Area);//set print area with indexesworkbook.setPrintArea(0, //sheet index0, //start column5, //end column0, //start row5 //end row);//set paper sizespreadsheet.getPrintSetup().setPaperSize(XSSFPrintSetup.A4_PAPERSIZE);//set display grid lines or notspreadsheet.setDisplayGridlines(true);//set print grid lines or notspreadsheet.setPrintGridlines(true);FileOutputStream out new FileOutputStream(new File(C:/poiexcel/printarea.xlsx));workbook.write(out);out.close();System.out.println(printarea.xlsx written successfully);}}输出 (Output)
