office xp web components

[Guest]

I'm trying to use the OWC on my web form and trying to make it look like
Excel. I have the box there but no formatting such as headers, bold font,
etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I format
the OWC on my .NET page to look like the one on my asp page?

 

[Alvin Bruney - ASP.NET MVP]

etc. I have the same control on a asp page and I have bold font, headers,

titles, grid lines, etc. but not on my .net (C#) web form. How can I format
the OWC on my .NET page to look like the one on my asp page?

The settings should all be there. If you can see the component in the
designer, right-click on it and add the appropriate formatting. What
difficulties are you having?

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/

 

[Guest]

I can't see it in designer, the developer that created the pages with the
excel control in .NET did the databinding etc via code. He created a label as
output and just populated the label with the OWC control, so I don't see
anything in designer mode.

etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I format
the OWC on my .NET page to look like the one on my asp page?

The settings should all be there. If you can see the component in the
designer, right-click on it and add the appropriate formatting. What
difficulties are you having?

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

I'm trying to use the OWC on my web form and trying to make it look like
Excel. I have the box there but no formatting such as headers, bold font,
etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I format
the OWC on my .NET page to look like the one on my asp page?

 

[Alvin Bruney - ASP.NET MVP]

post some code to explain what you are talking about because I am completely
lost.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

I can't see it in designer, the developer that created the pages with the
excel control in .NET did the databinding etc via code. He created a label as
output and just populated the label with the OWC control, so I don't see
anything in designer mode.

etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I format
the OWC on my .NET page to look like the one on my asp page?

The settings should all be there. If you can see the component in the
designer, right-click on it and add the appropriate formatting. What
difficulties are you having?

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

I'm trying to use the OWC on my web form and trying to make it look like
Excel. I have the box there but no formatting such as headers, bold font,
etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I format
the OWC on my .NET page to look like the one on my asp page?

 

[Guest]

he has this:

lblExcel.text = office.ExcelSpreadSheet(dataSetName);

and that is how he is populating the excel OWC control. In the HTML he has
the lblExcel there and that is it. If I go to designer mode I do not see the
control on the form to design it or define the properties etc,

post some code to explain what you are talking about because I am completely
lost.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

I can't see it in designer, the developer that created the pages with the
excel control in .NET did the databinding etc via code. He created a label as
output and just populated the label with the OWC control, so I don't see
anything in designer mode.

etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I
format
the OWC on my .NET page to look like the one on my asp page?
The settings should all be there. If you can see the component in the
designer, right-click on it and add the appropriate formatting. What
difficulties are you having?

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------



I'm trying to use the OWC on my web form and trying to make it look like
Excel. I have the box there but no formatting such as headers, bold font,
etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I
format
the OWC on my .NET page to look like the one on my asp page?

 

[Alvin Bruney - ASP.NET MVP]

lblExcel.text = office.ExcelSpreadSheet(dataSetName);
So, i'd assume that this static method takes a dataset object and spits out
html formatted output?
If this is correct, you'd need to modify the html output to update the html
formatted output. These are custom objects not OWC objects so I won't know
exactly what's going on in there.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

he has this:

lblExcel.text = office.ExcelSpreadSheet(dataSetName);

and that is how he is populating the excel OWC control. In the HTML he has
the lblExcel there and that is it. If I go to designer mode I do not see the
control on the form to design it or define the properties etc,

post some code to explain what you are talking about because I am completely
lost.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

I can't see it in designer, the developer that created the pages with the
excel control in .NET did the databinding etc via code. He created a

label
as

output and just populated the label with the OWC control, so I don't see
anything in designer mode.

:

etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I
format
the OWC on my .NET page to look like the one on my asp page?
The settings should all be there. If you can see the component in the
designer, right-click on it and add the appropriate formatting. What
difficulties are you having?

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------



I'm trying to use the OWC on my web form and trying to make it

look
like

Excel. I have the box there but no formatting such as headers,

bold
font,

etc. I have the same control on a asp page and I have bold font, headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I
format
the OWC on my .NET page to look like the one on my asp page?

 

[Guest]

Thats what he's doing, but from what I can see in the code, he's doing it
with XML though. They have a few asp web pages that use this same control and
it looks just like Excel on the web page, but the .NET version just looks
like white box and teh excel toolbar but nothing else. is there anything
online I can look at on how to use it in .NET? Is there a better way to use
it or no?

lblExcel.text = office.ExcelSpreadSheet(dataSetName);

So, i'd assume that this static method takes a dataset object and spits out
html formatted output?
If this is correct, you'd need to modify the html output to update the html
formatted output. These are custom objects not OWC objects so I won't know
exactly what's going on in there.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

he has this:

lblExcel.text = office.ExcelSpreadSheet(dataSetName);

and that is how he is populating the excel OWC control. In the HTML he has
the lblExcel there and that is it. If I go to designer mode I do not see the
control on the form to design it or define the properties etc,

post some code to explain what you are talking about because I am completely
lost.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------



I can't see it in designer, the developer that created the pages with the
excel control in .NET did the databinding etc via code. He created a label
as
output and just populated the label with the OWC control, so I don't see
anything in designer mode.

:

etc. I have the same control on a asp page and I have bold font,
headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I
format
the OWC on my .NET page to look like the one on my asp page?
The settings should all be there. If you can see the component in the
designer, right-click on it and add the appropriate formatting. What
difficulties are you having?

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------



I'm trying to use the OWC on my web form and trying to make it look
like
Excel. I have the box there but no formatting such as headers, bold
font,
etc. I have the same control on a asp page and I have bold font,
headers,
titles, grid lines, etc. but not on my .net (C#) web form. How can I
format
the OWC on my .NET page to look like the one on my asp page?

 

[Alvin Bruney - ASP.NET MVP]

That's what I am saying. When the XML is being generated, you have the
opportunity to customize the OWC UI interfaceby embedding the relevant tags
inside the XML document. If the problem is you don't know what the tags are
and what settings to modify, create a test OWC project with the settings
that you would like and cause it to write an XML file to disk. Open that
file and use the relevant tags.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

Thats what he's doing, but from what I can see in the code, he's doing it
with XML though. They have a few asp web pages that use this same control and
it looks just like Excel on the web page, but the .NET version just looks
like white box and teh excel toolbar but nothing else. is there anything
online I can look at on how to use it in .NET? Is there a better way to use
it or no?

lblExcel.text = office.ExcelSpreadSheet(dataSetName);

So, i'd assume that this static method takes a dataset object and spits out
html formatted output?
If this is correct, you'd need to modify the html output to update the html
formatted output. These are custom objects not OWC objects so I won't know
exactly what's going on in there.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

he has this:

lblExcel.text = office.ExcelSpreadSheet(dataSetName);

and that is how he is populating the excel OWC control. In the HTML he has
the lblExcel there and that is it. If I go to designer mode I do not

see
the

control on the form to design it or define the properties etc,



:

post some code to explain what you are talking about because I am completely
lost.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------



I can't see it in designer, the developer that created the pages

with
the

excel control in .NET did the databinding etc via code. He created

a
label

as
output and just populated the label with the OWC control, so I

don't
see

anything in designer mode.

:

etc. I have the same control on a asp page and I have bold font,
headers,
titles, grid lines, etc. but not on my .net (C#) web form. How

can
I

format
the OWC on my .NET page to look like the one on my asp page?
The settings should all be there. If you can see the component

in
the

designer, right-click on it and add the appropriate formatting. What
difficulties are you having?

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------



I'm trying to use the OWC on my web form and trying to make it look
like
Excel. I have the box there but no formatting such as headers, bold
font,
etc. I have the same control on a asp page and I have bold font,
headers,
titles, grid lines, etc. but not on my .net (C#) web form. How

can
I

format
the OWC on my .NET page to look like the one on my asp page?