设置Excel单元格的二进制格式

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileOutputStream;
import java.io.IOException;

public class ExcelBinaryFormatExample {
    public static void main(String[] args) {
        // 创建工作簿和工作表
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet("Binary Data");

        // 创建二进制数据
        byte[] binaryData = {0x48, 0x65, 0x6C, 0x6C, 0x6F, 0x20, 0x57, 0x6F, 0x72, 0x6C, 0x64};

        // 创建单元格并设置二进制数据
        Row row = sheet.createRow(0);
        Cell cell = row.createCell(0);
        cell.setCellValue(binaryData);

        // 设置单元格格式为二进制
        CellStyle binaryStyle = workbook.createCellStyle();
        DataFormat dataFormat = workbook.createDataFormat();
        binaryStyle.setDataFormat(dataFormat.getFormat("@"));
        cell.setCellStyle(binaryStyle);

        // 保存Excel文件
        try (FileOutputStream outputStream = new FileOutputStream("binary_data.xlsx")) {
            workbook.write(outputStream);
            System.out.println("Excel文件已成功创建。");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}