无需安装 Excel 即可将 Delphi TDataSet 导出到原生 XLS 的开源组件或单元

本文介绍了无需安装 Excel 即可将 Delphi TDataSet 导出到原生 XLS 的开源组件或单元的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

您可能知道存在一个免费和开源的 Delphi 代码来将 TDataSet 导出为原生 XLS 格式吗?here 之前有人问过这个问题，但我正在寻找免费的解决方案.

Do you possibly know about the existence of a free and open sourced Delphi code to export TDataSet to native XLS format? The question was previously asked here, yet I am looking for a free solution.

正如在例如 TeeChart.TeeStore.TSeriesDataXLS.SaveToStream 中观察到的那样，编写本机 XLS 导出函数并不是一门火箭科学，但我很难找到一个现有的解决方案，这肯定会节省一些时间和金钱(对于商业组件，这将10-20%).

As observed in for example TeeChart.TeeStore.TSeriesDataXLS.SaveToStream writing a native XLS export function is not a rocket science, yet I struggle to find an existing solution, which would definitely save some time and money (for commercial component which would be used in 10-20%).

如果这样的导出代码允许更改颜色和文本样式，那将是有益的，但对我个人而言，这并不重要.

It would be beneficial if such export code would allow color and text style changes, but for me personally it is not crucial.

推荐答案

我使用了 Max. 的组件 mxExport.它是免费的，并且有源代码可用.它现在处于离线状态的页面 (www.maxcomponents/) 但您可以在其他地方:

I have used the components mxExport from Max. It's free and with source code avaible. The page it's now offline (www.maxcomponents/) but you can find the components in other places:

• 托里
• FTP ClubDelphi(Max的所有组件库)李>
• ...

• Torry
• FTP ClubDelphi (all components libraries of Max)
• ...

检查组件:mxExports 和 mxNativeExcel.

Check components: mxExports and mxNativeExcel.

问候.