英文:
How can I write stream data to an Excel file using ExcelJS?
问题
我想使用这段代码将流数据写入Excel文件，但它只创建了一个空文件。我是否漏掉了什么？
const excel = require("exceljs");
async function processUpload(stream, filename) {
let counter = 0;
const options = {
filename,
useStyles: true,
useSharedStrings: true,
};
const workbook = new excel.stream.xlsx.WorkbookWriter(options);
const worksheet = workbook.addWorksheet("Sheet1");
stream.on("data", (row) => {
counter++;
worksheet.addRow(row);
});
stream.on("end", () => {
workbook.commit().then(() => {
console.log("Workbook committed and uploaded to GCS.", counter);
return filename;
});
});
stream.on("error", (err) => console.error(err));
}
如有需要，可以提供更多帮助。
英文:
I want to write stream data the Excel file using this code but it just creates an empty file. Am I missing anything here?
const excel = require("exceljs");
async function processUpload(stream, filename) {
let counter = 0;
const options = {
filename,
useStyles: true,
useSharedStrings: true,
};
const workbook = new excel.stream.xlsx.WorkbookWriter(options);
const worksheet = workbook.addWorksheet("Sheet1");
stream.on("data", (row) => {
counter++;
worksheet.addRow(row);
});
stream.on("end", () => {
workbook.commit().then(() => {
console.log("Workbook committed and uploaded to GCS.", counter);
return filename;
});
});
stream.on("error", (err) => console.error(err));
}
答案1
得分: 1
所以我运行了你的代码，并发现你需要指定列。假设你接收的数据是带有以下键的 JSON 对象：
{
name: 'John',
age: 23,
department: 'sales'
}
然后你可以这样做：
worksheet.columns = [
{ key: 'name', header: 'Name', width: 6 },
{ key: 'age', header: 'Age', width: 6 },
{ key: 'department', header: 'Department', width: 6 }
]
其中 key 应该是 JSON 字段名，header 将是 Excel 表格中的列标题，你可以选择它成为任何你想要的内容。
英文:
So I ran your code and figured that you need to specify the columns. Let say the data your are receiving is json objects with following keys
{
name: 'John',
age: 23,
department: 'sales'
}
Then you can do the following
worksheet.columns = [
{ key: 'name', header: 'Name', width: 6 },
{ key: 'age', header: 'Age', width: 6 },
{ key: 'department', header: 'Department', width: 6 }
]
Where key should be the json field name. And header will be the column header in excel sheet and you can choose it to be whatever you want
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论