哪个宝石支持在ruby中导入/导出到xlsx文件 [英] Which gem support Import/Export to xlsx file in ruby

问题描述

我需要使用ruby代码读取和写入Excelx文件，
用电子表格试用不支持xlsx格式，
Roo也是读取文件而不写入xlsx。

I need to read and write to Excelx file with ruby code, Tried with spreadsheet it does not support xlsx format, Roo is also to read the file and not write to xlsx.

有没有可以写入Excelx的gem / plugin？

Is there any gem/plugin which will write to Excelx?

推荐答案

编写/导出xlsx文件的任务，Axlsx是我发现的功能最完整的库。不过，它不支持读取/导入xlsx文件。

For the task of writing/exporting xlsx files, Axlsx is the most feature complete library I've found. It does not support reading/importing xlsx files, though.

https://github.com/randym/axlsx

以下是作者的说明：

xlsx生成带有图表，图像，自动列宽，
可自定义样式和完整模式验证。 Axlsx优于
，可帮助您生成美丽的Office Open XML电子表格文档
，而无需了解整个ECMA规范。查看
README，了解一些简单的例子。最重要的是，您可以
在序列化之前验证您的xlsx文件，以便确定
生成的任何内容将在客户端的计算机上加载。

xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.

这篇关于哪个宝石支持在ruby中导入/导出到xlsx文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！