HSSFRow rowdata = sheet.createRow(n);
int i = (n-1)+((t-1)*number);
if(i < size)
{
SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
Scorecard card = cards.get(i);
HSSFCell cell0 = rowdata.createCell(0);
HSSFRichTextString text0 = new HSSFRichTextString(card.getCard());
cell0.setCellValue(text0);
cell0.setCellStyle(styledata);
HSSFCell cell1 = rowdata.createCell(1);
// HSSFRichTextString text1 = new HSSFRichTextString(card.getPassword());
cell1.setCellValue(card.getPassword());
cell1.setCellStyle(styledata);
HSSFCell cell2 = rowdata.createCell(2);
// HSSFRichTextString text2 = new HSSFRichTextString(card.getScore().toString());
cell2.setCellValue(card.getScore());
cell2.setCellStyle(styledata);
HSSFCell cell3 = rowdata.createCell(3);
HSSFRichTextString text3 = new HSSFRichTextString(sdf.format(card.getEffectiveTimeStart()));
cell3.setCellValue(text3);
cell3.setCellStyle(styledata);
HSSFCell cell4 = rowdata.createCell(4);
HSSFRichTextString text4 = new HSSFRichTextString(sdf.format(card.getEffectiveTimeEnd()));
cell4.setCellValue(text4);
cell4.setCellStyle(styledata);
}
}
}