如何使用Nodej创建Excel文件？ [英] How to create an Excel File with Nodejs?

问题描述

我是一个nodejs程序员。现在我有一个数据表，我想以Excel文件格式保存。我该怎么做呢？

我发现了一些Node库。但大多数是Excel分析器，而不是Excel Writers。我正在使用Linux服务器。因此需要可以在Linux上运行的东西。如果您有任何有用的图书馆，请让我知道。或者有没有办法将CSV文件转换成xls文件（以编程方式）？

解决方案

我只是想出了一个简单的出路。这个工作 -

只需创建一个带有Tabs作为分隔符的文件（与CSV类似，但用Tab替换逗号）。保存扩展名.XLS。该文件可以在Excel中打开。

有些代码可以帮助 -

  var fs = 'FS'）; 
 var writeStream = fs.createWriteStream（file.xls）; 
 
 var header =Sl No+\t+Age+\t+Name+\\\
; 
 var row1 =0+\t+21+\t+Rob+\\\
; 
 var row2 =1+\t+22+\t+bob+\\\
; 
 
 writeStream.write（header）; 
 writeStream.write（row1）; 
 writeStream.write（row2）; 
 
 writeStream.close（）; 
  

这将以XLS文件格式创建文件。如果您尝试使用XLSX而不是XLS，它不起作用。

I am a nodejs programmer . Now I have a table of data that I want to save in Excel File format . How do I go about doing this ?

I found a few Node libraries . But most of them are Excel Parsers rather than Excel Writers .I am using a Linux Server . Hence need something that can run on Linux . Please let me know if there are any helpful libraries that you know of .

Or is there a way I can convert a CSV file to an xls file ( programmatically ) ?

解决方案

I just figured a simple way out . This works -

Just create a file with Tabs as delimiters ( similar to CSV but replace comma with Tab ). Save it with extension .XLS . The file can be opened in Excel .

Some code to help --

var fs = require('fs');
var writeStream = fs.createWriteStream("file.xls");

var header="Sl No"+"\t"+" Age"+"\t"+"Name"+"\n";
var row1 = "0"+"\t"+" 21"+"\t"+"Rob"+"\n";
var row2 = "1"+"\t"+" 22"+"\t"+"bob"+"\n";

writeStream.write(header);
writeStream.write(row1);
writeStream.write(row2);

writeStream.close();

This creates the file in XLS file format . It doesnt work if you try XLSX instead of XLS .

这篇关于如何使用Nodej创建Excel文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！