Excel中的Visual Basic图表 [英] Visual Basic Chart From Excel
问题描述
有没有人知道如何使用excel的两列数据并使用Visual Studio 2017将数据导入图表?我是一个真正的初学者,我父亲挑战我这样做,谢谢任何回答。
Does anyone know how to use two columns of data from excel and import the data into a chart using Visual Studio 2017? I am a true beginner and my father has challenged me to do this, Thank you to anyone who answers.
推荐答案
你好,
如果使用Excel 2007或更高版本,有一个支持图表创建的
免费完整功能库,唯一的缺点是样本都在C#中,但很容易转换。
If working with Excel 2007 or higher there is a free full feature library that supports chart creations, only downside is the samples are all in C# but would be easy to convert.
一个样本图表。我已经完成了一些没有图表样本的图书馆用于Microsoft
代码示例在这里 VB.NET。
One sample of a chart. I've done some no chart samples with the library for Microsoft code samples here in VB.NET.
以下是他们的帮助文件,图表创建方法。
Below is from their help file, methods for chart creation.
< img alt =""src ="https://social.msdn.microsoft.com/Forums/getfile/1089491">
其他方法是使用Excel自动化,这需要更多的代码,并且安装Excel,而上面的库不需要安装Excel。
Other method would be to use Excel automation which requires more code and that Excel be installed while the library above does not require Excel to be installed.
这篇关于Excel中的Visual Basic图表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!