文件下载冻结，未在Linux上完成

发布于 2025-01-25 00:55:53 字数 891 浏览 3 评论 0原文

我正在使用“ node.js”，“ express”和“ sheetJs”静态文件。

import crypto from 'crypto';
import * as XLSX from 'xlsx';
import path from 'path';
import * as fs from 'fs';
...
const exportToExcelFile = async (data) => {
  ...
  const worksheet = XLSX.utils.json_to_sheet(data);

  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Data');

  const buf = XLSX.write(workbook, { bookType: 'xlsx', type: 'buffer' });
  fs.writeFileSync(resolvedFilename, buf);

  return `${process.env.APP_URL}/public/downloads/${date}/${filename}`;
}

但是，在Windows中，文件生成和下载完美地工作，但是，当应用程序在Linux服务器上运行时，文件的生成了，但是下载冻结并且未完成。

[下载Congelado] [1]

如果我将“缓冲区”类型更改为“二进制”，则下载在Windows和Linux上工作，但是，在尝试打开文件时，Excel都会显示损坏的文件消息。

  const buf = XLSX.write(workbook, { bookType: 'xlsx', type: 'binary' });

关于它可能是什么的想法或建议？

原文

I'm using "Node.js", "express" and "SheetJS" so that an endpoint that saves the data (from an array of objects) in an XLSX file and returns the url of the file to be downloaded by another endpoint as a static file.

import crypto from 'crypto';
import * as XLSX from 'xlsx';
import path from 'path';
import * as fs from 'fs';
...
const exportToExcelFile = async (data) => {
  ...
  const worksheet = XLSX.utils.json_to_sheet(data);

  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Data');

  const buf = XLSX.write(workbook, { bookType: 'xlsx', type: 'buffer' });
  fs.writeFileSync(resolvedFilename, buf);

  return `${process.env.APP_URL}/public/downloads/${date}/${filename}`;
}

In Windows, the file generation and download work perfectly, however, when the application is running on the linux server the file is generated, however, the download freezes and does not finish.

[Download congelado][1]

If I change the 'buffer' type to 'binary', the download works on windows and linux, however, in both when trying to open the file, Excel shows a corrupted file message.

  const buf = XLSX.write(workbook, { bookType: 'xlsx', type: 'binary' });

Any ideas or suggestions of what it could be?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

生活了然无味 2025-02-01 00:55:54

如果您在写作后关闭文件会有所帮助吗？

const fs = require("fs/promises");
(async function() {
  var file = await fs.open(resolvedFilename, "w");
  await file.write(buf);
  await file.close();
})();

Does it help if you close the file after writing?

const fs = require("fs/promises");
(async function() {
  var file = await fs.open(resolvedFilename, "w");
  await file.write(buf);
  await file.close();
})();

回复收藏 0 原文