以下是JavaFX中导出Excel的核心代码:
private HSSFWorkbook workbook;
/* Build Operation Button Area */
Button exportBn = ButtonBuilder.create().text("导出Excel").prefWidth(80).prefHeight(30).build();
exportBn.setDefaultButton(true);
exportBn.setOnAction(new EventHandler<ActionEvent>() {
@Override
public void handle(ActionEvent event) {
updateQueryResultAllRecords();
FileChooser fileChooser = new FileChooser();
fileChooser.setTitle("LaundryService");
fileChooser.setInitialFileName("laundryrecords.xls");
fileChooser.getExtensionFilters().add(new FileChooser.ExtensionFilter("XLS Files", "*.xls"));
File file = fileChooser.showSaveDialog(mRecordDetailStage);
if(file != null){
exportExcel(file.getAbsolutePath());
}
}
});
private void exportExcel(String fileName) {
// Declare a work sheet
workbook = new H