1. Apache POI
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExcelExample {
public static void main(String[] args) {
try (Workbook workbook = new XSSFWorkbook()) {
Sheet sheet = workbook.createSheet("Sheet1");
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("Hello, Excel!");
try (FileOutputStream fileOut = new FileOutputStream("example.xlsx")) {
workbook.write(fileOut);
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
2. EasyExcel
import com.alibaba.excel.EasyExcel;
import java.util.ArrayList;
import java.util.List;
public class ExcelExample {
public static void main(String[] args) {
List<Data> dataList = getDataList();
String fileName = "example.xlsx";
EasyExcel.write(fileName, Data.class).sheet("Sheet1").doWrite(dataList);
}
private static List<Data> getDataList() {
List<Data> dataList = new ArrayList<>();
dataList.add(new Data("John", 25));
dataList.add(new Data("Jane", 30));
return dataList;
}
}
3. JExcelApi
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import java.io.File;
public class ExcelExample {
public static void main(String[] args) {
try {
WritableWorkbook workbook = Workbook.createWorkbook(new File("example.xls"));
WritableSheet sheet = workbook.createSheet("Sheet1", 0);
Label label = new Label(0, 0, "Hello, Excel!");
sheet.addCell(label);
workbook.write();
workbook.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
