如何将带有公式的Excel数据导入datagridview [英] How to import excel data with formulae into datagridview

问题描述

我有一个excel文件，我需要导入到DGV。我使用oledb实现这一目标，但我无法导入带公式的单元格。有没有办法做到这一点。我读过将excel文件转换为xml然后导入可以工作的地方，任何人都可以说明如何做到这一点，如果有可能这样做吗？任何其他建议也表示赞赏。

I have an excel file which I need to import to DGV. I am using oledb to achieve this but I am not able to import cells with formulae. Is there any way to do this. I read somewhere that converting excel files to xml and then importing would work, can anyone please illustrate how to do this if at all it is possible to do it that way? Any other suggestion is also appreciated.

推荐答案

此视频可能会对您有所帮助 - http://www.youtube.com/watch?v=Bkad3lgUcKE [ ^ ]。



链接 - http://www.authorcode.com/import-data-from-excel-to-datagridview-in-c/ [ ^ ]

http://www.authorcode.com/import-data-from -excel-to-datagridview-in-c / [ ^ ]

This video might help you - http://www.youtube.com/watch?v=Bkad3lgUcKE[^].

Links - http://www.authorcode.com/import-data-from-excel-to-datagridview-in-c/[^]
http://www.authorcode.com/import-data-from-excel-to-datagridview-in-c/[^]

这篇关于如何将带有公式的Excel数据导入datagridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！