View unanswered posts | View active topics
It is currently Wed Nov 27, 2024 3:26 am
|
Page 1 of 1
|
[ 7 posts ] |
|
Author |
Message |
John Lemur
|
Pie charts
How can I generate advanced pie charts in a web project?
|
Wed Jun 14, 2006 3:29 am |
|
|
tavi
Joined: Fri Feb 03, 2006 12:23 pm Posts: 3
|
Pie chart
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using EasyXLS;
using EasyXLS.Constants;
namespace TestWebEasyXLS
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
/*--------License Information --------*/
public static string sLicense = "License";
public static string sLicenseKey = "LicenseKey";
private void Page_Load(object sender, System.EventArgs e)
{
Response.Write("Tutorial 17 adapted<br>-----------<br>");
//Create an instance of the object that generates Excel files
ExcelDocument xls = new ExcelDocument();
//Add one worksheet
xls.easy_addWorksheet("SourceData");
// ----------------------------------------------------------------------
//Insert values
ExcelTable xlsTable1 = ((ExcelWorksheet)xls.easy_getSheet("SourceData")).easy_getExcelTable();
xlsTable1.easy_getCell(0, 0).setValue("Show Date");
xlsTable1.easy_getCell(0, 1).setValue("Available Places");
xlsTable1.easy_getCell(0, 2).setValue("Available -");
xlsTable1.easy_getCell(0, 3).setValue("Sold -");
xlsTable1.easy_getCell(1, 0).setValue("03/13/2005 00:00:00");
xlsTable1.easy_getCell(1, 0).setFormat(EasyXLS.Constants.Format.FORMAT_DATE);
xlsTable1.easy_getCell(2, 0).setValue("03/14/2005 00:00:00");
xlsTable1.easy_getCell(2, 0).setFormat(EasyXLS.Constants.Format.FORMAT_DATE);
xlsTable1.easy_getCell(3, 0).setValue("03/15/2005 00:00:00");
xlsTable1.easy_getCell(3, 0).setFormat(EasyXLS.Constants.Format.FORMAT_DATE);
xlsTable1.easy_getCell(4, 0).setValue("03/16/2005 00:00:00");
xlsTable1.easy_getCell(4, 0).setFormat(EasyXLS.Constants.Format.FORMAT_DATE);
xlsTable1.easy_getCell(1, 1).setValue("10000");
xlsTable1.easy_getCell(2, 1).setValue("5000");
xlsTable1.easy_getCell(3, 1).setValue("8500");
xlsTable1.easy_getCell(4, 1).setValue("1000");
xlsTable1.easy_getCell(1, 2).setValue("8000");
xlsTable1.easy_getCell(2, 2).setValue("4000");
xlsTable1.easy_getCell(3, 2).setValue("6000");
xlsTable1.easy_getCell(4, 2).setValue("1000");
xlsTable1.easy_getCell(1, 3).setValue("920");
xlsTable1.easy_getCell(2, 3).setValue("1005");
xlsTable1.easy_getCell(3, 3).setValue("342");
xlsTable1.easy_getCell(4, 3).setValue("967");
xlsTable1.easy_getColumnAt(0).setWidth(100);
xlsTable1.easy_getColumnAt(1).setWidth(100);
xlsTable1.easy_getColumnAt(2).setWidth(100);
xlsTable1.easy_getColumnAt(3).setWidth(100);
//-------------------------------------
//Add the chart xls.easy_addChart("Chart", "=SourceData!$A$1:$B$5", Chart.SERIES_IN_COLUMNS); ExcelChartSheet xlsChart = (ExcelChartSheet)xls.easy_getSheetAt(1); xlsChart.easy_setChartType(Chart.CHART_TYPE_PIE_3D_EXPLODED);
//Generate the file
Response.Write("Writing file Tutorial17.xls.");
xls.easy_WriteExcelFile("C:\\Inetpub\\wwwroot\\Tutorial17.xls", sLicense, sLicenseKey);
/*//Or write directly in Response and you don't need any permissions
//Start to prepare the Response
Response.AppendHeader("content-disposition", "attachment; filename=Tutorial17.xls");
Response.ContentType = "application/octetstream";
Response.Clear();
//Generate the file and prompt the "Open or Save Dialog Box"
xls.easy_WriteExcelFile(Response.OutputStream, sLicense, sLicenseKey);*/
//Confirm generation
String sError = xls.easy_getError();
if (sError.Equals(""))
Response.Write("<br>File successfully created.");
else
Response.Write("<br>Error encountered: " + sError);
//Dispose memory
Response.End();
xls.Dispose();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
|
Thu Jun 15, 2006 8:21 am |
|
|
MrRipley
|
Pie options
Yes, but is it possible to change de colors of each pieces by code? And how can you indicate de type of legends?
Making a pie chart from Excel, colors are assignated automatically, but from EasyXLS I always get then blue. And I don't know how to tell chart to show legends in percentage or how to access to the options of each category (I can get refereces to series, but in a pie chart usually you only have a single serie). It is easy from Excel, but is it possible by code?
I think rows and columns charts are quite more versatile with EasyXLS.
(My version of control is 5.1)
Greetings (and sorrry for my english; I'm spanish)
|
Mon Nov 20, 2006 8:28 am |
|
|
mihaionescu
Joined: Mon Nov 20, 2006 9:59 am Posts: 1
|
Please download and install the new trial version EasyXLS 5.3. In this version the chart pie is generated in different colors. This colors cannot be changed from the code. Here is some code that and I hope it can help you.
|
Mon Nov 20, 2006 10:50 am |
|
|
Guest
|
I will try. About changing categories colours, I have seen Excel does not allow it neither and apply them automatically...
|
Mon Nov 20, 2006 11:12 am |
|
|
djamraam
Joined: Tue May 13, 2008 3:32 am Posts: 2
|
pie charts
What can I do if I want to create a piechart whith several cells not with a cell range? i.e. with A1;G4;F32;H15
Thank you!
|
Fri May 16, 2008 6:12 am |
|
|
oana
Joined: Wed Nov 07, 2007 4:42 am Posts: 67
|
Pie Chart
Here is the code that you need:
|
Thu May 22, 2008 5:49 am |
|
|
|
Page 1 of 1
|
[ 7 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 0 guests |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|