Search results matching tag 'OWC'

Re: OWC Com exception error

mlemmi — Thu, 17 Jul 2008 04:00:00 GMT

Hi,

yes I have! You have to read carefully and follow exactly what is written in the article which I send the link. You will find the solution there.

http://aspnet.4guysfromrolla.com/articles/080603-1.2.aspx

You have to be really carefull when you read the section called "Installing OWC10 on the Web Server" or you'll get in troubles.

Please, let me know if it works,

my best regards.

Miles

Re: OWC Com exception error

mlemmi — Thu, 26 Jun 2008 04:00:00 GMT

I prefer to post a block with code (for different kind of chart but is the same):

ChartSpace1 = New OWC.ChartSpace()

Dim c As Object

c = ChartSpace1.Constants

ChartSpace1.Border.Color = c.chColorNone

Chart1 = ChartSpace1.Charts.Add(0)

Chart1_Series1 = Chart1.SeriesCollection.Add(0)

Chart1_Series1.Type = c.chChartTypeScatterLine

Chart1_Series1.Line.Color = "Blue"

Chart1_Series1.Border.Color = "black"

Chart1_Series1.Marker.Size = 6

Chart1_Series1.Marker.Style = c.chMarkerStyleCircle

Chart1_Series1.SetData(OWC.ChartDimensionsEnum.chDimSeriesNames, OWC.ChartSpecialDataSourcesEnum.chDataLiteral, "Pesi (g)")

Chart1_Series1.SetData(OWC.ChartDimensionsEnum.chDimXValues, OWC.ChartSpecialDataSourcesEnum.chDataLiteral, aX)

Chart1_Series1.SetData(OWC.ChartDimensionsEnum.chDimYValues, OWC.ChartSpecialDataSourcesEnum.chDataLiteral, aY)

Note: aX and aY are the array with values for my scatter line chart

etc ...

Mickey

Microsoft OWC graphs, XML, and SQL 2005 in C#

TheEarthWillShake — Tue, 10 Jun 2008 04:00:00 GMT

Hey, I'm trying to read a database and display it as a graph. I have accomplished this but I have an issue.

Database structure is one table called num1.

num1 only has ID, X, and Y columns. That's it.

The graph displays right but the tags at the bottom have all shifted over right so it's not lined up.

The process I did was, read a database into a dataset, convert it to XML, then display it as a graph.

http://i88.photobucket.com/alb...icemike_2006/chart.png

^ There's the picture.

Code is attached.

Code.......

private void BuildCharts ()
{
//Create a SQL connection
String cn = ConfigurationManager.ConnectionStrings["OWCDEMOConnectionString"].ConnectionString;

//The SQL query
string sqlStatement = "SELECT x, y FROM [num1]";

//Create a new instance of an SqlConnection and assign our connection string to it
SqlConnection sqlConnection = new SqlConnection(cn);

//Open our connection
sqlConnection.Open();

//Create a new instance of a dataset object
DataSet dataSet = new DataSet();

//Assign the SQL statement and connectio to use for this operation
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlStatement, sqlConnection);

//Fill our dataset with the data accumulated from the SQL statement
sqlAdapter.Fill(dataSet);

//ChartSpaceClass oChartSpace = new ChartSpaceClass();
System.IO.StringWriter sw = new System.IO.StringWriter();
XmlDocument xDoc = new XmlDocument();
dataSet.WriteXml(sw);


//Disgard connections
sqlConnection.Close();
dataSet.Dispose();
sw.Close();

//XML
xDoc.LoadXml(sw.ToString());
System.Xml.XmlNodeList nodes;
nodes = xDoc.ChildNodes.Item(0).ChildNodes;

int nCount = nodes.Count + 1;


string[] aNames = new string[nCount];
string[] aTotals = new string[nCount];
string names = String.Empty;
string totals = String.Empty;

int i = 1;
for (i = 1; i < nCount; i++)
{
//aNames = nodes.Item(i - 1).ChildNodes.Item(1).InnerText; //ChildNodes.Item(1) For Car Names
aTotals = nodes.Item(i - 1).ChildNodes.Item(0).InnerText; //ChildNodes.Item(0) For Numbers
}

int j = 0;
for (j = 1; j < nCount; j++)
{
aNames[j] = nodes.Item(j - 1).ChildNodes.Item(1).InnerText; //ChildNodes.Item(1) For Car Names
//aTotals = nodes.Item(i - 1).ChildNodes.Item(0).InnerText; //ChildNodes.Item(0) For Numbers
}

names = String.Join("\t", aNames);
totals = String.Join("\t", aTotals);


//Test Labels
//Convert.ToString(aNames); Label = System.String
//Convert.ToString(nodes); Label = System.Xml...
Label1.Text = names;
Label2.Text = totals;
Label3.Text = Convert.ToString(sw);
Label4.Text = Convert.ToString(nCount);


//**********************************

Microsoft.Office.Interop.Owc11.ChartSpaceClass newChartSpace = new Microsoft.Office.Interop.Owc11.ChartSpaceClass();
Microsoft.Office.Interop.Owc11.ChartChartTypeEnum newChartType;


newChartSpace.Charts.Add(0);
newChartSpace.Charts[0].SeriesCollection.Add(0);
newChartSpace.Charts[0].SeriesCollection[0].SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimCategories, Convert.ToInt32(Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral), names);
newChartSpace.Charts[0].SeriesCollection[0].SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimValues, Convert.ToInt32(Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral), totals);


byte[] byteArr = (byte[]) newChartSpace.GetPicture ("png", 800, 500);

//------------------------------------------------------------------------
//Store the chart image in Session to be picked up by an HttpHandler later
//------------------------------------------------------------------------
HttpContext ctx = HttpContext.Current;
string chartID = Guid.NewGuid().ToString();

ctx.Session [chartID] = byteArr;
imgChart.ImageUrl = string.Concat ("chart.ashx?", chartID);


}


}
}

Rounding Error creating a pie chart with OWC11 on ASP.NET / VB.NET

fgentili — Tue, 13 May 2008 04:00:00 GMT

Hi everybody,
I'm currently using OWC11 on .NET Framework 2.0 (ASP.NET - VB.NET) in order to create charts. I'm experiencing an issue about rounding a piechart percentage values that I provide to the component.

my problem is:
If I have to represent three integer percentage values that are exacly 1/3 of a pie each one: using OWC11 in my application the result is a three-parts pie with 33% each one while doing the same on Excel the result is 33%, 33% and 34%! The sum of the last operation is (uncorrectly) 100% (i guess that Excel auto-rounds something somewhere....... ) while in the first case, using OWC11, the sum is 99% (wrong anyway but perfectly consistent with the fact that are integer percentages not decimal!). The question is: does the OWC11 component allows an auto-rounding excel-styled or do I have to "manage" series before send to the OWC11?

Thanks in advantage

Fabio Gentili

OWC: Rotate X-Axis Text to 90 Degrees

hifni — Wed, 02 Apr 2008 04:00:00 GMT

Uses: Windows XP + SP2, .NET 1.1 Framework, OWC10, VB.NET;

My application, an ASP.NET web application produces the chart withoout any problem, as witnessed in the following picture:

however I 'm facing some problem to Rotate the X-Axis text/Label in 90 degrees form. Any help will be greatly appreciated.

Regards,

Hifni

OWC Com exception error

fuzzster967 — Fri, 12 Oct 2007 04:00:00 GMT

Hello,

Trying to get OWC11 to work within aspx page using VWD2005 Express. When I debug the code I'm getting the following error :-

Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))

at the code line

ChartSpace1.Charts(0).SeriesCollection(0).SetData(c.chDimCategories, c.chDataLiteral, categories)

I've taken the sample code from the OWCDCH11.CHM help files but with little success.

Any help much appreciated.

interop.owc10.dll problem

BhaveshPatel — Mon, 11 Jun 2007 04:00:00 GMT

hey guys couple of questions about interop.owc10.dll

(1) what is the differance between interop.OWC10.dll and OWC10.dll ?

(2) what is the differance between OWC10.dll and OWC11.dll?

(3) I have created a simple aspx page with creating graph using interop.OWC10.dll, but I am not able to make it run on server 2003(none office tool is installed).

(4) when I uploaded to the server i started getting this error. retrieving the COM class factory for component with CLSID {0002E556 ..........

(5) To make my graph page run using interop.OWC10.dll, do I need to install whole microsoft office on microsoft server 2003?

please help guys.

Score/Time chart with Office Web Component (OWC)

cosmo0 — Wed, 28 Feb 2007 05:00:00 GMT

Hello !

I want to draw a chart with the Office Web Component. I read many articles (on 4guys, csharphelp etc), but found no "official" documentation and/or example. And I'm struggling to find how I can do what I want.

Here is the code I use for generating a (test) chart :

1                Dim Graphique As New ChartSpace
2                Dim Graph As ChChart = Graphique.Charts.Add()
3                With Graph
4                    .Type = ChartChartTypeEnum.chChartTypeScatterLineMarkers
5                    .HasLegend = False
6                    .HasTitle = True
7                    .Title.Caption = "Results of learner"
8                    .Axes(0).HasTitle = True
9                    .Axes(0).Title.Caption = "Results"
10                   .Axes(1).HasTitle = True
11                   .Axes(1).Title.Caption = "Exercices"
12               End With
13   
14               Dim GraphSeries As ChSeries = Graph.SeriesCollection.Add(0)
15               GraphSeries.SetData(ChartDimensionsEnum.chDimSeriesNames, ChartSpecialDataSourcesEnum.chDataLiteral, "Score")
16               GraphSeries.SetData(Owc11.ChartDimensionsEnum.chDimXValues, Owc11.ChartSpecialDataSourcesEnum.chDataLiteral, "01-2007" & vbTab & "02-2007" & vbTab & "03-2007" & vbTab & "04-2007")
17               GraphSeries.SetData(Owc11.ChartDimensionsEnum.chDimYValues, Owc11.ChartSpecialDataSourcesEnum.chDataLiteral, Math.Floor(Rnd() * 10).ToString & vbTab & Math.Floor(Rnd() * 10).ToString & vbTab & Math.Floor(Rnd() * 10).ToString & vbTab & Math.Floor(Rnd() * 10).ToString)
18   
19               Response.ContentType = "image/gif"
20               Response.BinaryWrite(Graphique.GetPicture("gif", 500, 400))
21               Response.End()

But on the X axis, there are still the values 0, 1, 2 etc ! It doesn't cares that I gave him dates...
How can I put other values on the X axis than arbitrary numbers ?

Thanks very much !

IE7 Breaks IE6 Javascript/OWC Client-Side Display

acksoft — Wed, 13 Dec 2006 05:00:00 GMT

I have an app that uses a javascript menu with many items, and many of the pages in the app have grids created with Office Web Components (OWC 11).

In IE6 everything worked just fine, but in IE7 many of the javascript menu items appear behind the grid, making them unavailable to the user.

At first I thought it was the "windowed" vs. "non-windowed" controls issue (see MS Knowledge Base article ID 177378), but then I realized if that was the problem, it should have occured in IE6 as well.

Can anyone, particularly anyone from the MS IE team who might happen by, shed some light on what has changed between IE6 and IE7 that might have caused this problem?

Any assistance will be greatly appreciated as this is a serious issue for a legacy application at a VERY LARGE corporation with 2500+ users that needs to be solved quickly.

Thanks in advance.

Re: generate graphs in asp.net 2.0

anzer — Mon, 28 Aug 2006 04:00:00 GMT

Try Office web components (OWC) with asp.net,,, , i have used it with CF but didnt try in asp.net, anyway Its really powerfull

Here you can find sample source code

or just google and u can get alot of resources about OWC

Regards
Anzer