Where is code for demos?

Aspose.Cells Product Family
1

Hello,

This is my first post. I am trying to find the c-sharp code that is behind the demos, like the one to show the sub-totals and I can't find it anywhere? I only find the excel spreadsheet that does what I need my program to do, but I can't find the c# code for it? Also I am doing the

Dynamically Generate Formatted Excel Reports with an Elegant Graph

that is in the documentation for aspose.cells, however it talks about using a chart.gif (in images dir) and products.xml file. I can't find either of these files on the website and I don't know where to download them??? So far I am running into this brick wall here. It seems like all the demos are for "show" on what all the components can do..but not the code behind them to do it? Can someone point me in the right direction to find the "meat" of the examples written in C#?

thank you,

David

2

Hi,

Thanks for your inquiry.

1). Well, when you install the control using Aspose.Grid.msi installer: http://www.aspose.com/community/files/53/visual-components/aspose.grid/default.aspx the demo solutions (Aspose.Grid.Desktop and Aspose.Grid.Web demos (C# and VB)) are automatically installed on your system by default in the ....\Program Files\Aspose\Aspose.Grid\demos folder. So, you may open the demo solutions into VS.NET and check their source codes. You should also check the documentation of Aspose.Grid @: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/index.html

2). I have attached the complete source C# project for the technical article "Dynamically Generate Formatted Excel Reports with an Elegant Graph" for your reference, so you may also check the source .xml and .gif files.

Thank you.

3

Hello,

I’m glad you sent that too me because I don’t have that one on my drive.

Ok, next thing. I think there are a couple of errors and I wanted to point them out.

First I am using vs2005 with .net 2.

In the tutorial you write this:

I
Add
Reference to the
three components i.e. Aspose.Grid.Web.dll, Aspose.Chart.dll and Aspose.Cells.dll
to the project first. I place some control on the page and set their properties,
i.e. a drop down list, a command button and a label. I then place Aspose.Grid.Web
control
(GridWeb) to it from the toolbox, since
after adding references to the three components, the GridWeb control is appeared on
toolbox. The other two components (Aspose.Chart and Aspose.Cells) are just libraries, only get
referenced to the project.


The problem i’m having is that it does not appear in the box to the side at all. I had to figure out how to add it. I think you should put instructions on how to add it in manually so people don’t get stuck there.

Next, the Chart doesn’t display at all in my grid. It does show up in my excel export though…albiet doesn’t have the same number of pieces of pie as the data shows (missing the bottom piece of data every time).

Anyhow, thank you for all your help and I hope that my feedback can help you. I have another question but i’ll start a new thread for that.

thanks,
David

4

Hi David,

1). I think you are right, I did not explain much there for how to add the GridWeb control to the toolbox in VS.NET. I thought the user must have read this already i.e.., how to add the Aspose.Grid.Web control to the toolbox: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/integrate-aspose-grid-with-visual-studio-net.html I have also updated the article and provided the needed description there.

2)... Next, the Chart doesn't display at all in my grid. It does show up in my excel export though...albiet doesn't have the same number of pieces of pie as the data shows (missing the bottom piece of data every time).

Well, you do need to click btnChart custom command button which has "create chart" tool tip to show the chart in the GridWeb. Also, please make sure that you have inserted all the code snippet related to "Creating Chart based on the Source Range using Aspose.Chart component" subtitle described in the article.

And for "albiet doesn't have the same number of pieces of pie as the data shows (missing the bottom piece of data every time)." Could you give us more details which data portion is missing in the rendered chart. I don't find any problem.

Thank you.

5

Hello,

I have another question that I think is appropriate for this thread as it is part of the tutorial.

I just found out that we are not using the Aspose.Grid.Web…however we are using the Aspose.Cells. We have datasets (query sets from oracle) that we want to put into excel spreadsheets and add headers, footers, sub-totals, grand totals and have some spacing (empty rows) in-between each set of data. I am not sure how to go about this…is there a tutorial for taking my dataset in c# and just dropping it right into the Aspose.Cells and making an Excel spreadsheet right from that?

thanks again,
David

6

Hi David,

OK, I think you may try to explore Aspose.Cells Documentation especially the following topics for your desired tasks:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/importing-data-to-worksheets.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/setting-headers-and-footers.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/groupingungrouping-rows-and-columns.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/insertingdeleting-rows-and-columns.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/using-formulasfunctions-to-process-data.html

For subtotaling etc. you may try our unique feature i.e.., smart markers. For reference, please check the following topic:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/smart-markers.html

Feel free to contact us anytime if you need further clarifications.

Thank you.

7

Thank you so much for pointing me in the right direction! I’ll let you know the results.

-David

Update, i’m still stuck…I looked at the examples but I guess i’m a few lines of code short.

public partial class _Default : System.Web.UI.Page
{
DataSet ds;


protected void Page_Load(object sender, EventArgs e)
{
// Set the license for Aspose.Cells

Aspose.Cells.License cellsLicense = new

Aspose.Cells.License();

cellsLicense.SetLicense(“Aspose.Cells.lic”);




//this is my dataset
ds = Page.Session[“ClientTrackerMasterList”] as DataSet;

??? what do I do here to put the above into an excel .xls file ???
…with headers??

}





}