Excel.ChartObject obj = (Excel.ChartObject)exSheet.ChartObjects("Chart 39");
"Chart 39"是模板中有的一个图表,我用上面的代码可以获得图表的对象,但是我怎么设置坐标轴的最大值、最小值和步进啊。(图表有3个坐标轴,1个横轴,左右各一个竖轴)。
哪位大侠帮帮忙啊,感激不尽!
解决方案 »
- Could not compile the mapping document异常问题
- 请问项目以中文来命名,如 中文.sln,会引起歧义吗
- 请问用.net c#开发一个类似VNC的Winform项目的可行性
- 请问如果将DataGridView中的数据[手工添加的]转为DataSet
- web直接打印(不用选择打印机)
- FTP 下载文件 超初级问题,请指教一下
- DataGridView 疑问
- sql查询处理
- 用.NET做过企业级系统的大哥们请进
- 100分紧急求助:如何在C#中使用SQLDMO
- dataGridView.CurrentCell.Value无法赋值
- 如何获取窗体句柄是否等于某个模糊内容
using System.Runtime.InteropServices;
using Excel = Microsoft.Office.Interop.Excel;private void button1_Click(object sender, EventArgs e)
{
Excel.Application xlApp;
Excel.Workbook xlBook;
Excel.Workbooks xlBooks;
Excel.Range xlRange ;
Excel.Sheets xlsheets;
Excel.Worksheet xlSheet;
try
{
xlApp = new Excel.Application();
xlBooks = xlApp.Workbooks;
xlBook = xlBooks.Add(Missing.Value);
xlsheets = xlBook.Worksheets;
xlSheet = (Excel.Worksheet)xlsheets.get_Item(1);
// xlApp.DisplayAlerts = false;
// create cell header
object[] objHeaders = { "Count", "num1", "num2", "num3", "num4" };
// set header text
xlRange = xlSheet.get_Range("A1", "E1");
xlRange.set_Value(Missing.Value, objHeaders);
xlRange.Font.Bold = true;
xlRange.Font.Name = "Verdana";
xlRange.Font.Size = 10;
xlRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
for (int i = 0; i < 13; i++)
{
xlSheet.Cells[2 + i, 1] = i;
xlSheet.Cells[2 + i, 2] = i+1;
xlSheet.Cells[2 + i, 3] = i+2;
xlSheet.Cells[2 + i, 4] = i+3;
xlSheet.Cells[2 + i, 5] = i+4;
}
Excel.Chart xlChart = (Excel.Chart)xlBook.Charts.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
Excel.Range chartRage = xlSheet.get_Range("A1:A14", "B1:E14");
xlChart.ChartWizard(chartRage, Excel.XlChartType.xl3DColumn, Missing.Value, Excel.XlRowCol.xlColumns, 1, 1, true, "效率分析", "时间", "次数", Missing.Value);
xlBook.SaveAs(Application.StartupPath + "\\Analysis.xls", Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value);
xlBook.Close(false, Missing.Value, Missing.Value);
MessageBox.Show("Excel chart created under: \n" + Application.StartupPath + "\\Analysis.xls", "Confirm", MessageBoxButtons.OK);
}
catch (Exception ec)
{
MessageBox.Show(ec.ToString());
}
finally
{
xlRange = null;
xlSheet = null;
xlBook = null;
xlApp = null;
} }
}
excel
Excel.Axes myaxes0 = (Excel.Axes)chart0.Axes(objmissing, Excel.XlAxisGroup.xlPrimary);
myaxes0.Item(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlPrimary).HasTitle = true;
myaxes0.Item(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlPrimary).AxisTitle.Text = "时间(Hour)";
double d4 = Y_min_t;
myaxes0.Item(Excel.XlAxisType.xlValue, Excel.XlAxisGroup.xlPrimary).MinimumScale = Math.Floor(d4);
myaxes0.Item(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlPrimary).MaximumScale = Math.Ceiling(X_max);