使用Delphi读取Excel电子表格 [英] Reading Excel spreadsheets with Delphi

问题描述

我需要使用Delphi 2010读取和写入Excel电子表格。没什么好想的。只需读取和写入来自不同工作表中特定单元格和范围的值。需要在没有安装Excel和不支持Excel 2007的情况下工作。

I need to read from and write to Excel spreadsheets using Delphi 2010. Nothing fancy. Just reading and writing values from specific cells and ranges on different sheets. Needs to work without having Excel installed and support Excel 2007.

我看过的一些东西：

• 我尝试使用 ADO ，可以很好地选择整个工作表中的所有内容，但是读取特定的单元格或范围并没有多大运气。

• I've tried using ADO, which works OK for selecting everything in an entire sheet, but I haven't had much luck reading specific cells or ranges.

NativeExcel 看起来很有希望，但是它似乎并未处于积极的发展中，他们也没有回复电子邮件。

NativeExcel looked promising, but it doesn't seem to be in active development, and they don't respond to e-mails.

Axolot 有一个几个产品。主要产品似乎功能齐全，但价格昂贵。他们有一个精简版，但是不支持Delphi 2010。

Axolot has a couple of products. The main product seems to be very functional, but is pricey. They have a lite version, but it doesn't support Delphi 2010.

有什么建议吗？免费会很棒，但是我愿意接受商业解决方案，只要它可靠且受到良好支持即可。

Any recommendations? Free would be great, but I'm open to a commercial solution as long as it's reliable and well supported.

推荐答案

TMS Flexcel -我知道它看起来像Excel的报告组件（它做得很好，并且是您工具箱中非常方便的工具），但是它还包括用于读取和显示Excel文件的组件。 Adrian Gallero对Excel API（包括Excel 2007）的了解程度给我留下了深刻的印象。

TMS Flexcel - I know it looks like a reporting component for Excel (which it does very well and is a very handy tool to have in your toolkit) but it also includes components for reading and displaying Excel files. I've been very impressed with how well Adrian Gallero seems to know the Excel API, including Excel 2007.

http://www.tmssoftware.com/site/flexcel.asp

不免费当然，但我认为75欧元是很划算的。

Not free of course, but at 75 Euros I think it's good value.

这篇关于使用Delphi读取Excel电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！