在 Seaside 等 Web 应用程序框架中使用 Excel 文件
我一直在阅读有关海边的文章，并且喜欢它的声音，但我找不到处理数据文件的简单方法，主要是导入 Excel。当然，csv 文件会更直接，但是有没有什么方法可以导入各种 Excel 格式（xls、xlsx）而无需编写自己的文件解析例程？
我听说需要打开 Excel 文件是选择 .NET 这样的基于 Windows 的系统的一个很好的理由，你们觉得怎么样？
Ive been reading about seaside and like the sound of it but i cant see an easy way for handling data files, primarily importing Excel. Of course csv files would be more straight forward, but are there any ways to import the various Excel formats (xls,xlsx) without writing your own file parsing routines?
I've heard that the need to open Excel files would be a good reason to choose a windows based system like .NET, what do you guys think?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
有多种 Smalltalk 实现支持 Seaside，并且可以很好地集成到 Windows 平台中：Dolphin Smalltalk 、VA Smalltalk 和 Cincom Smalltalk.我认为可以使用其中任何一个来调用 Excel。
您可以调用各种命令行工具，将 XLS 文件转换为您可以轻松使用的文件解析（如 CSV）。
但是，我认为最优雅的解决方案（也是从最终用户的角度来看）是 Magic/Replace 之一。
There are various Smalltalk implementation that support Seaside and that have an excellent integration into the Windows platform: Dolphin Smalltalk, VA Smalltalk, and Cincom Smalltalk. I assume that it is possible to call Excel with any of these.
There are various command line tools available that you could call to convert an XLS file to something you can easily parse (like CSV).
However, I think the most elegant solution (also from an end-user perspective) is the one of Magic/Replace.
只是回答你问题的第二部分：不，这不是一个很好的理由。您绝对不想将 Office 作为服务器进程运行（我从未尝试过使用 OpenOffice，但这应该会更好一些）。
它不稳定，并且存在您必须注意的许可证问题。
Just an answer on the second part of your question: no that is not a good reason. You definitely do not want to run Office as a server proces (I never tried with OpenOffice, but that should work somewhat better).
It is not stable and there are license issues you have to be aware of.
我开发了一个 Seaside 应用程序，可以在 Linux 上读取和写入 Excel 表格。这就是我所做的……
就是这样。它甚至不慢，只要确保 OOo 在后台持续运行即可。
I've worked on a Seaside app that read and wrote excel sheets on Linux. Here's what I did …
And that's it. It wasn't even slow, just make sure that OOo is running constantly in the background.