如何使用excel中的数据在c＃中创建图表 [英] How create chart in c# using data from excel

问题描述

如何使用excel中的数据在c＃中创建图表。我尝试着，但我不知道应该做些什么。需要帮助!!§



我想在c＃中创建图表（Microsoft Visual C＃2010 Express）。它是Windows窗体应用程序，我想从Excel表中获取数据，这是我的代码的一部分

How create chart in c# using data from excel . I try everithing but I don´t know what I should make . Need help !!§

I want create chart in c#(Microsoft Visual C# 2010 Express). It is Windows forms application and I want get data from Excel table this is part of my code

/////////////////// using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Drawing; 
using System.Linq; 
using System.Text; 
using System.Windows.Forms; 
using System.Data.OleDb; 

namespace WindowsFormsApplication1 
{ 
public partial class Form1 : Form 
{ public Form1() { InitializeComponent(); } private void chart1_Click(object sender, EventArgs e) { chart1.ChartAreas.Add("area"); chart1.ChartAreas["area"].AxisX.Minimum = 0; chart1.ChartAreas["area"].AxisX.Maximum = 20; chart1.ChartAreas["area"].AxisX.Interval =1 ; chart1.ChartAreas["area"].AxisY.Minimum = 0; chart1.ChartAreas["area"].AxisY.Interval =10 ; chart1.Series.Add("Meranie");
 chart1.Series["Meranie"].Color=Color.Green;
 chart1.Series["Meranie"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
 // 
} private void Form1_Load(object sender, EventArgs e) { 
// TODO: This line of code loads data into the 'databaseDataSet.Meranie' table. You can move, or remove it, as needed. 
// this.meranieTableAdapter.Fill(this.databaseDataSet.Meranie); 
} 

private void X_Click(object sender, EventArgs e) 
{ 
}

 private void button1_Click(object sender, EventArgs e) 
{ 
/* OleDbConnection conn = new OleDbConnection(); 
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; 
Data Source=C:\Users\Peto\Documents\Visual Studio 2010\Projects\Meranie vzduchu\Meranie vzduchu\bin\Tabulky.xls;Extended Properties= ""Excel 8.0;HDR=YES;"";";
 OleDbCommand command1 = new OleDbCommand ( "SELECT Meno " + "FROM [Studenti$]", conn ); OleDbCommand command2 = new OleDbCommand ( "SELECT Priezvisko " + "FROM [Studenti$]", conn ); DataSet dsMeno = new DataSet(); 
DataSet dsPriezvisko = new DataSet(); 
OleDbDataAdapter adapter1 = new OleDbDataAdapter(command1); 
adapter1.Fill(dsMeno); 
OleDbDataAdapter adapter2 = new OleDbDataAdapter(command2); 
adapter2.Fill(dsPriezvisko); */ 
} 

private void chart1_Enter(object sender, EventArgs e) 
{ 
chart1.ChartAreas.Add("area"); 
chart1.ChartAreas["area"].AxisX.Minimum = 0; 
chart1.ChartAreas["area"].AxisX.Maximum = 20; 
chart1.ChartAreas["area"].AxisX.Interval = 1; 
chart1.ChartAreas["area"].AxisY.Minimum = 0; 
chart1.ChartAreas["area"].AxisY.Interval = 10; 
chart1.Series.Add("Meranie"); chart1.Series["Meranie"].Color = Color.Green; chart1.Series["Meranie"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line; 

/////////////////////////////////////////////////////////////////// // need some code ...... I need get data from excel and put graph ////////////////////////////////////////////////////////////// 
} 

private void button2_Click(object sender, EventArgs e) 
{ 
OleDbConnection conn = new OleDbConnection(); 
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\Peto\Documents\Visual Studio 2010\Projects\Meranie vzduchu\Meranie vzduchu\bin\Tabulky.xls;
Extended Properties= ""Excel 8.0;HDR=YES;"";";

推荐答案

，conn）; OleDbCommand command2 = new OleDbCommand（SELECT Priezvisko+FROM [Studenti

", conn ); OleDbCommand command2 = new OleDbCommand ( "SELECT Priezvisko " + "FROM [Studenti

，conn）; DataSet dsMeno = new DataSet（）;
DataSet dsPriezvisko = new DataSet（）;
OleDbDataAdapter adapter1 = new OleDbDataAdapter（command1） ;
adapter1.Fill（dsMeno）;
OleDbDataAdapter adapter2 = new OleDbDataAdapter（command2）;
adapter2.Fill（dsPriezvisko）; * /
}

private void chart1_Enter（ object sender，EventArgs e）
{
chart1.ChartAreas.Add（ area）;
chart1.ChartAreas [ area]。AxisX.Minimum = 0 ;
chart1.ChartAreas [ area]。AxisX.Maximum = 20 ;
chart1.ChartAreas [ area]。AxisX.Interval = 1 ;
chart1.ChartAreas [ area]。AxisY.Minimum = 0 ;
chart1.ChartAreas [ area]。AxisY.Interval = 10 ;
chart1.Series.Add（ Meranie）; chart1.Series [ Meranie]。颜色= Color.Green; chart1.Series [ Meranie]。ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType 。线;

/// /////////////// ///////////////////////////////////////////////// / /需要一些代码......我需要从excel获取数据并放入图形/////////////////////////////// ///////////////////////////////
}

private void button2_Click（ object sender，EventArgs e）
{
OleDbConnection conn = new OleDbConnection（）;
conn.ConnectionString = @ Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C：\\ \\ Users\Peto \Documents\Visual Studio 2010 \Projects\ Meranie vzduchu \ Meranie vzduchu \bin\Tabulky.xls;
Extended Properties =Excel 8.0; HDR = YES; ;;

", conn ); DataSet dsMeno = new DataSet(); DataSet dsPriezvisko = new DataSet(); OleDbDataAdapter adapter1 = new OleDbDataAdapter(command1); adapter1.Fill(dsMeno); OleDbDataAdapter adapter2 = new OleDbDataAdapter(command2); adapter2.Fill(dsPriezvisko); */ } private void chart1_Enter(object sender, EventArgs e) { chart1.ChartAreas.Add("area"); chart1.ChartAreas["area"].AxisX.Minimum = 0; chart1.ChartAreas["area"].AxisX.Maximum = 20; chart1.ChartAreas["area"].AxisX.Interval = 1; chart1.ChartAreas["area"].AxisY.Minimum = 0; chart1.ChartAreas["area"].AxisY.Interval = 10; chart1.Series.Add("Meranie"); chart1.Series["Meranie"].Color = Color.Green; chart1.Series["Meranie"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line; /////////////////////////////////////////////////////////////////// // need some code ...... I need get data from excel and put graph ////////////////////////////////////////////////////////////// } private void button2_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\Peto\Documents\Visual Studio 2010\Projects\Meranie vzduchu\Meranie vzduchu\bin\Tabulky.xls; Extended Properties= ""Excel 8.0;HDR=YES;"";";

这是非常直接的：

http://support.microsoft.com/kb/302084 [ ^ ]



读取包含绘图数据的单元格，您就完成了。

It is farly straight forward:
http://support.microsoft.com/kb/302084[^]

Read the cells that contains the plotted data and you are done.

这篇关于如何使用excel中的数据在c＃中创建图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！