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?
7  1354 
> 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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:BC**********************************@microsof t.com... 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?
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.
"Alvin Bruney - ASP.NET MVP" wrote: 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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:BC**********************************@microsof t.com... 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?
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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:93**********************************@microsof t.com... 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.
"Alvin Bruney - ASP.NET MVP" wrote:
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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:BC**********************************@microsof t.com... 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?
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,
"Alvin Bruney - ASP.NET MVP" wrote: 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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:93**********************************@microsof t.com... 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.
"Alvin Bruney - ASP.NET MVP" wrote:
> 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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:BC**********************************@microsof t.com...
> 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?
> 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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:8A**********************************@microsof t.com... 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,
"Alvin Bruney - ASP.NET MVP" wrote:
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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:93**********************************@microsof t.com... 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.
"Alvin Bruney - ASP.NET MVP" wrote:
> > 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/
> -------------------------------------------------------
>
>
>
> "John" <Jo**@discussions.microsoft.com> wrote in message
> news:BC**********************************@microsof t.com...
> > 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?
>
>
>
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?
"Alvin Bruney - ASP.NET MVP" wrote: 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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:8A**********************************@microsof t.com... 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,
"Alvin Bruney - ASP.NET MVP" wrote:
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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:93**********************************@microsof t.com...
> 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.
>
> "Alvin Bruney - ASP.NET MVP" wrote:
>
> > > 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/
> > -------------------------------------------------------
> >
> >
> >
> > "John" <Jo**@discussions.microsoft.com> wrote in message
> > news:BC**********************************@microsof t.com...
> > > 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?
> >
> >
> >
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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:87**********************************@microsof t.com... 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?
"Alvin Bruney - ASP.NET MVP" wrote:
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/
-------------------------------------------------------
"John" <Jo**@discussions.microsoft.com> wrote in message
news:8A**********************************@microsof t.com... 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,
"Alvin Bruney - ASP.NET MVP" wrote:
> 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/
> -------------------------------------------------------
>
>
>
> "John" <Jo**@discussions.microsoft.com> wrote in message
> news:93**********************************@microsof t.com...
> > 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.
> >
> > "Alvin Bruney - ASP.NET MVP" wrote:
> >
> > > > 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/
> > > -------------------------------------------------------
> > >
> > >
> > >
> > > "John" <Jo**@discussions.microsoft.com> wrote in message
> > > news:BC**********************************@microsof t.com...
> > > > 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?
> > >
> > >
> > >
>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Timothy |
last post by:
I have developed an application that uses the Office Web Components 2003. This application will be deployed to systems that do not have Office or the Web Components installed. The problem that I am...
|
by: srinivas |
last post by:
Hi,
I created an interactive html page by saving an excel
file.What i need is, i created this file using office 2000.some of our
clients are unable to access my page.when ever they attempt to...
|
by: mehul |
last post by:
Hi,
I am trying to use Microsoft Office Web components in my asp.net
applicaion.
Actually i want to use the chart and came accross some sample code
in MSDN (Kb:Use a DataSet with the Office...
|
by: DC Gringo |
last post by:
Allison (or others), thank you for the advice...a few more questions:
- I have tested on my workstation on Excel XP and my application references
the Excel 10.0 Object Library. I was told the...
|
by: Michael Russell |
last post by:
Hi all,
Using C#, I've created a simple wrapper class for using Excel. I have
Office Pro 2003 installed on my devel machine. The wrapper class works
great, reading and writing to/from Excel. ...
|
by: fiona |
last post by:
Divelements release fully featured Office 2007 style Ribbon control
Major component suite designed to mimic the advanced user interface
features of Microsoft Office 2007
Dorset, United Kingdom -...
|
by: fiona |
last post by:
Dramatically increases support for accessibility as well as fully
conforming to the Office 2007 UI license and guidelines
Dorset, United Kingdom - January 3 2007, Divelements Ltd announces
the...
|
by: Manikandan |
last post by:
Hi,
I have a question reg excel interop.
I have no excel installation(office installation) in my system
I'm using office web components in my application.
is there any help available to use...
|
by: =?Utf-8?B?VGVycnkgQWxsZW4=?= |
last post by:
When referencing the Microsoft Graph 11.0 Object Library in a C# applicaion
using Visual Studio 2005 it uses the path below.
...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
