OWC spreadsheet control

[CSharpguy]

I have an asp.net web form that i took over from another developer. Its using
the excel control on my form. (this was an asp page and it worked correctly).
My question is my dataset is being returned to the page with HTML tags in it,
such as <b>BMW</b> <i>Sold</i> how can I have BMW and Sold show up in my OWC
- Excel spreadsheet control in BOLD and ITALICS? The form is using XML for
some formatting, but not all of it.

I never used the OWC excel control before and what i'm finding online isn't
that helpful for what i need to do

 

[Alvin Bruney]

if you have the owc object embedded, you simply need to apply bold font
settings to the cell or header in the owc control.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[CSharpguy]

Thats easier said then done due to the fact he's doing everything via XML.
He did not drag and drop the control to the web form. He's binding a dataset
to it and has a style class so I can't grab the cells and format it that
way.

if you have the owc object embedded, you simply need to apply bold font
settings to the cell or header in the owc control.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I have an asp.net web form that i took over from another developer. Its
using
the excel control on my form. (this was an asp page and it worked
correctly).
My question is my dataset is being returned to the page with HTML tags in
it,
such as <b>BMW</b> <i>Sold</i> how can I have BMW and Sold show up in my
OWC
- Excel spreadsheet control in BOLD and ITALICS? The form is using XML
for
some formatting, but not all of it.

I never used the OWC excel control before and what i'm finding online
isn't
that helpful for what i need to do

 

[Alvin Bruney]

Then you need to grab a hold of the OWC schema available on the Office
website. The schema indicates how to set the appropriate tags for
formatting. Or if you want to do it the easy way, open the spreadsheet and
some text and bold it then cause the spreadsheet to write out the data in
XML format. Open that file and examine and use the tags in your code.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Thats easier said then done due to the fact he's doing everything via XML.
He did not drag and drop the control to the web form. He's binding a
dataset to it and has a style class so I can't grab the cells and format
it that way.

if you have the owc object embedded, you simply need to apply bold font
settings to the cell or header in the owc control.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I have an asp.net web form that i took over from another developer. Its
using
the excel control on my form. (this was an asp page and it worked
correctly).
My question is my dataset is being returned to the page with HTML tags
in it,
such as <b>BMW</b> <i>Sold</i> how can I have BMW and Sold show up in my
OWC
- Excel spreadsheet control in BOLD and ITALICS? The form is using XML
for
some formatting, but not all of it.

I never used the OWC excel control before and what i'm finding online
isn't
that helpful for what i need to do

 

[CSharpguy]

where can i find the schema?

Also will that OWC black book help me out on this or no?

Then you need to grab a hold of the OWC schema available on the Office
website. The schema indicates how to set the appropriate tags for
formatting. Or if you want to do it the easy way, open the spreadsheet and
some text and bold it then cause the spreadsheet to write out the data in
XML format. Open that file and examine and use the tags in your code.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Thats easier said then done due to the fact he's doing everything via
XML.
He did not drag and drop the control to the web form. He's binding a
dataset to it and has a style class so I can't grab the cells and format
it that way.

if you have the owc object embedded, you simply need to apply bold font
settings to the cell or header in the owc control.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I have an asp.net web form that i took over from another developer. Its
using
the excel control on my form. (this was an asp page and it worked
correctly).
My question is my dataset is being returned to the page with HTML tags
in it,
such as <b>BMW</b> <i>Sold</i> how can I have BMW and Sold show up in
my OWC
- Excel spreadsheet control in BOLD and ITALICS? The form is using XML
for
some formatting, but not all of it.

I never used the OWC excel control before and what i'm finding online
isn't
that helpful for what i need to do

 

[CSharpguy]

I just found the XML schema. The developer that converted this over from asp
to asp.net (C#) is doing the cell formatting like that, but the BOLD isn't
working. The control is being populated via a dataset, in the dataset data
is being returned (such as headers) like <b>BMW</b>, <i>Sold</i>
but the control on the asp.net web form is not recognizing the <b> tags but
in the asp version it does and works correctly.

Then you need to grab a hold of the OWC schema available on the Office
website. The schema indicates how to set the appropriate tags for
formatting. Or if you want to do it the easy way, open the spreadsheet and
some text and bold it then cause the spreadsheet to write out the data in
XML format. Open that file and examine and use the tags in your code.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Thats easier said then done due to the fact he's doing everything via
XML.
He did not drag and drop the control to the web form. He's binding a
dataset to it and has a style class so I can't grab the cells and format
it that way.

if you have the owc object embedded, you simply need to apply bold font
settings to the cell or header in the owc control.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I have an asp.net web form that i took over from another developer. Its
using
the excel control on my form. (this was an asp page and it worked
correctly).
My question is my dataset is being returned to the page with HTML tags
in it,
such as <b>BMW</b> <i>Sold</i> how can I have BMW and Sold show up in
my OWC
- Excel spreadsheet control in BOLD and ITALICS? The form is using XML
for
some formatting, but not all of it.

I never used the OWC excel control before and what i'm finding online
isn't
that helpful for what i need to do