package excel;
import java.util.*;
import javax.servlet.http.*;
import org.apache.poi.hssf.usermodel.*;
import org.springframework.web.servlet.view.document.*;
public class HomePage extends AbstractExcelView {
protected void buildExcelDocument(
Map model,
HSSFWorkbook wb,
HttpServletRequest req,
HttpServletResponse resp) throws Exception {
HSSFSheet sheet;
HSSFRow sheetRow;
HSSFCell cell;
// Go to the first sheet
// getSheetAt: only if wb is created from an existing document
//sheet = wb.getSheetAt( 0 );
sheet = wb.createSheet("Spring");
sheet.setDefaultColumnWidth((short) 12);
// write a text at A1
cell = getCell(sheet, 0, 0);
setText(cell, "Spring-Excel test");
List words = (List) model.get("wordList");
for (int i = 0; i < words.size(); i++) {
cell = getCell(sheet, 2 + i, 0);
setText(cell, (String) words.get(i));
}
}
}
|