且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用Java/javascript和apache POI导出.xls文件时获取损坏的文件

更新时间:2023-11-25 15:03:04

如果其他人遇到相同的问题,则发布此解决方案,我通过base64将字节数组编码为字符串来解决此问题,如下所示.

Posting this solution if anyone else faces the same issue, I resolved this issue via base64 encoding the byte array to a string as below.

ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
 workbook.write(outputStream);
 String res = Base64.getEncoder().encodeToString(outputStream.toByteArray());

在javascript中,我从链接下方使用base64ToBlob方法对该字符串进行了解码

In javascript I decoded that string using base64ToBlob method from below link

https://***.com/a/20151856/2011294

function base64toBlob(base64Data, contentType) {
    contentType = contentType || '';
    var sliceSize = 1024;
    var byteCharacters = atob(base64Data);
    var bytesLength = byteCharacters.length;
    var slicesCount = Math.ceil(bytesLength / sliceSize);
    var byteArrays = new Array(slicesCount);

    for (var sliceIndex = 0; sliceIndex < slicesCount; ++sliceIndex) {
        var begin = sliceIndex * sliceSize;
        var end = Math.min(begin + sliceSize, bytesLength);

        var bytes = new Array(end - begin);
        for (var offset = begin, i = 0; offset < end; ++i, ++offset) {
            bytes[i] = byteCharacters[offset].charCodeAt(0);
        }
        byteArrays[sliceIndex] = new Uint8Array(bytes);
    }
    return new Blob(byteArrays, { type: contentType });
}