本文整理匯總了Java中org.apache.poi.xssf.usermodel.XSSFSheet.setColumnWidth方法的典型用法代碼示例。如果您正苦於以下問題：Java XSSFSheet.setColumnWidth方法的具體用法？Java XSSFSheet.setColumnWidth怎麽用？Java XSSFSheet.setColumnWidth使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類org.apache.poi.xssf.usermodel.XSSFSheet的用法示例。
在下文中一共展示了XSSFSheet.setColumnWidth方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。
示例1: copySheets
import org.apache.poi.xssf.usermodel.XSSFSheet; //導入方法依賴的package包/類
/**
* @param newSheet the sheet to create from the copy.
* @param sheet the sheet to copy.
* @param copyStyle true copy the style.
*/
public static void copySheets(XSSFSheet newSheet, XSSFSheet sheet, boolean copyStyle) {
int maxColumnNum = 0;
Map<Integer, XSSFCellStyle> styleMap = (copyStyle) ? new HashMap<Integer, XSSFCellStyle>() : null;
for (int i = sheet.getFirstRowNum(); i <= sheet.getLastRowNum(); i++) {
XSSFRow srcRow = sheet.getRow(i);
XSSFRow destRow = newSheet.createRow(i);
if (srcRow != null) {
Util.copyRow(sheet, newSheet, srcRow, destRow, styleMap);
if (srcRow.getLastCellNum() > maxColumnNum) {
maxColumnNum = srcRow.getLastCellNum();
}
}
}
for (int i = 0; i <= maxColumnNum; i++) {
newSheet.setColumnWidth(i, sheet.getColumnWidth(i));
}
//Util.copyPictures(newSheet,sheet) ;
}
示例2: setColumnSizes
import org.apache.poi.xssf.usermodel.XSSFSheet; //導入方法依賴的package包/類
private void setColumnSizes(XSSFSheet sheet, List<String> spreadsheetHeader) {
int i = 0;
for (String headerColumn : spreadsheetHeader) {
sheet.setColumnWidth(i, DEFAULT_COLUMN_SIZE);
i++;
}
}
示例3: putTables
import org.apache.poi.xssf.usermodel.XSSFSheet; //導入方法依賴的package包/類
@SuppressWarnings("unchecked")
private void putTables(XSSFWorkbook wb, XSSFSheet sh, Context context) throws Exception {
XSSFCellStyle cellHeadStyle = wb.createCellStyle();
cellHeadStyle.setFillForegroundColor( new XSSFColor( SimpleUtils.getColorRGB4POIColor( "#f5f5f5" ) ) );
cellHeadStyle.setFillPattern( FillPatternType.SOLID_FOREGROUND );
cellHeadStyle.setBorderBottom( BorderStyle.THIN );
cellHeadStyle.setBorderTop( BorderStyle.THIN );
cellHeadStyle.setBorderRight( BorderStyle.THIN );
cellHeadStyle.setBorderLeft( BorderStyle.THIN );
XSSFFont cellHeadFont = wb.createFont();
cellHeadFont.setBold(true);
cellHeadStyle.setFont( cellHeadFont );
sh.setColumnWidth(0, 12000);
int row = 0;
Row nowRow = sh.createRow(row);
Cell cell1 = nowRow.createCell(0);
cell1.setCellStyle(cellHeadStyle);
cell1.setCellValue( "KPI" );
Cell cell2 = nowRow.createCell(1);
cell2.setCellStyle(cellHeadStyle);
cell2.setCellValue( "Maximum" );
Cell cell3 = nowRow.createCell(2);
cell3.setCellStyle(cellHeadStyle);
cell3.setCellValue( "Target" );
Cell cell4 = nowRow.createCell(3);
cell4.setCellStyle(cellHeadStyle);
cell4.setCellValue( "Minimum" );
Cell cell5 = nowRow.createCell(4);
cell5.setCellStyle(cellHeadStyle);
cell5.setCellValue( "Current score" );
Cell cell6 = nowRow.createCell(5);
cell6.setCellStyle(cellHeadStyle);
cell6.setCellValue( "Previous score" );
Cell cell7 = nowRow.createCell(6);
cell7.setCellStyle(cellHeadStyle);
cell7.setCellValue( "Change(%)" );
row++;
List<PeriodTrendsData<KpiVO>> periodDatas = (List<PeriodTrendsData<KpiVO>>)context.get("periodDatas");
for (PeriodTrendsData<KpiVO> periodData : periodDatas) {
nowRow = sh.createRow(row);
cell1 = nowRow.createCell(0);
cell1.setCellValue( periodData.getCurrent().getName() );
cell2 = nowRow.createCell(1);
cell2.setCellValue( periodData.getCurrent().getMax() );
cell3 = nowRow.createCell(2);
cell3.setCellValue( periodData.getCurrent().getTarget() );
cell4 = nowRow.createCell(3);
cell4.setCellValue( periodData.getCurrent().getMin() );
cell5 = nowRow.createCell(4);
cell5.setCellValue( BscReportSupportUtils.parse2( periodData.getCurrent().getScore() ) );
cell6 = nowRow.createCell(5);
cell6.setCellValue( BscReportSupportUtils.parse2( periodData.getPrevious().getScore() ) );
cell7 = nowRow.createCell(6);
cell7.setCellValue( BscReportSupportUtils.parse2( periodData.getChange() ) );
row++;
}
nowRow = sh.createRow(row);
cell1 = nowRow.createCell(0);
cell1.setCellValue( "Current period: " + (String)context.get("currentPeriodDateRange") + " , Previous period: " + (String)context.get("previousPeriodDateRange") );
}