How to control excel pagination?

hakulee

I would like to ask, when java generates Excel, the data is obtained from the database. Assuming that 100 pieces of data are obtained, how to control, so that Excel prints only 40 pieces per page and prints three pages? ?

zt103b

Use pagination
Control it

tellyou

〉 Java generates Excel

What is used to generate jxl, poi? Or did you write .xls directly, or did you generate a file called .csv? ? ?

hakulee

It is to find 100 records from the database and write them to the excel file. Now it has been written. There are already 100 records in excel. Now the excel file is printed out on paper. How to make each paper only have a maximum of 40 records Record, can it be achieved with java!
Shouldn't it be clear this time? My expressiveness may be poor, mainly because I don't understand it! !! !!

冰中之狐

Divided into 3 Sheets? ?

hakulee

Can you use only one sheet! ? Why do you need to separate sheets?

tellyou

I ask you, what is your "excel file" extension? What java framework is used to generate?

POI, such as HSSFWorkbook, HSSFSheet or JXL, such as Workbook?

I wo n’t say that, post the code

hakulee

"Excel file" extension is .xls, using struts framework,
public String createExcel (String str, String flag) throws BaseException {
Ranch
BaseSQLHandler baseSQLHandler = new BaseSQLHandler (false);
BaseDBConnection connection = baseSQLHandler.getBaseDBConnection ();

// create a new workbook
HSSFWorkbook workBook = new HSSFWorkbook ();
HSSFDataFormat format = workBook.createDataFormat ();

hakulee

import org.apache.poi.hssf.usermodel. *;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.hssf.util.Region;

hakulee

This time should be clear?