Can Infragistics be used in Console applications? I have a console application where I have to generate charts and put them on excel files. Please let me know if it possible and if so, how? A sample code is appreciated. Thanks!
Hi,
I need to render a chart in Excel not as an Image but as a Chart Type.
Please let me know if this is possible with Infragistics .
If Possible send me the sample code.
Thanks & Regards,
Shilpa Gopalan
The labels will depend on the Columns of your table along with the values in certain string columns.
http://help.infragistics.com/Help/NetAdvantage/NET/2008.2/CLR2.0/html/Chart_Labels.html
There is also a TitleTop property you can use to set the title:
http://help.infragistics.com/Help/NetAdvantage/NET/2008.2/CLR2.0/html/Infragistics2.Win.UltraWinChart.v8.2~Infragistics.Win.UltraWinChart.UltraChart~TitleTop.html
I am getting a chart on the excel sheet, but how to give the x-axis label, y-axis label and the values of the x-axis and y-axis.
How to give the Title to the chart that is getting saved on excel sheet.
Please reply as soon as possible so that i can proceed further.
Here's the code to accomplish the task:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Infragistics.Win.UltraWinChart;
using Infragistics.Excel;
using System.IO;
{
class Program
UltraChart uc = new UltraChart();
uc.Data.DataBind();
Worksheet ws = wb.Worksheets.Add("worksheet1");
wsi.TopLeftCornerCell = ws.Rows[0].Cells[0];
wsi.BottomRightCornerCell = ws.Rows[2].Cells[5];
ws.Shapes.Add(wsi);
}
References that you need:
-Infragistics.Excel
-Infragistics.Shared
-Infragistics.Win.UltraWinChart
-Infragistics.Win
-System.Drawing
-System.Windows.Forms
Note: Minimum requirement of NetAdvantage 2007 Volume 2.
But how to generate the chart from a console application. That was my first question. Is it possible with Infragistics?