如何在我的visual basic Windows窗体应用程序（2015）中的网格视图中显示现有的2016 exel文件 [英] How do I display existing 2016 exel files in a grid view within my visual basic windows form application (2015)I

问题描述

我只想显示电子表格数据，没有别的



我尝试过：



我使用OLEDb适配器和Microsoft office interop来尝试显示excel数据，但我用来帮助我的所有代码都留下了一些错误。我相信对我来说主要的困难是大多数建议都支持旧版本的Excel和Visual studio

解决方案

我建​​议看看OpenXML SDK或者这样的组件作为EPPlus，

[ ^ ]。



EPPlus非常易于使用，不需要任何Office组件安装。

I just want to display the spreadsheet data, nothing else

What I have tried:

I have used OLEDb adapters and Microsoft office interop to try and display the excel data but all the code I have used to assist me leaves a few errors . I believe the main struggle for me is that most of the advice supports older versions of Excel and Visual studio

解决方案

I would suggest looking at the OpenXML SDK or a component such as EPPlus,
[^].

EPPlus is very easy to work with and does not require any Office components to be installed.

这篇关于如何在我的visual basic Windows窗体应用程序（2015）中的网格视图中显示现有的2016 exel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！