Office 2007 documents not appearing in iframe

We've been developing an application for a while which allows display of
office/pdf etc documents within an iframe in a web browser.
However, since installing office 2007 this has stopped working and instead
of them appearing nicely in the iframe they now pop up and appear within the
office program.
Does anyone know if there is a way to alter the behaviour of office 2007 so
that the documents remain embedded within the iframe, or is this something
which I just have to accept.
ThanksAFAIK in both 2007 and previous version this is actually a client dependant
behavior. Try :
http://support.microsoft.com/kb/162059/en-us
Another option could be to use an object tag (not tried)...
Patrice
"T" <T@.discussions.microsoft.com> a crit dans le message de news:
49BA0ADC-30D0-4B2E-8724-F3823CBFD8DD@.microsoft.com...
> We've been developing an application for a while which allows display of
> office/pdf etc documents within an iframe in a web browser.
> However, since installing office 2007 this has stopped working and instead
> of them appearing nicely in the iframe they now pop up and appear within
> the
> office program.
> Does anyone know if there is a way to alter the behaviour of office 2007
> so
> that the documents remain embedded within the iframe, or is this something
> which I just have to accept.
> Thanks
>
Hey thanks. I did as suggested in the support article and it does now open i
n
the iframe.
However, this must have been something the Office 2007 installation messed
around with as everything worked fine before installing 2007. Anyone know wh
y
this was done? Also its not something i can expect all our users to do after
they install office 2007, that they then have to for every office file type
select a check box in folder options to allow them to appear in the browser.
Does anyone have any suggestions?
Cheers
"Patrice" wrote:

> AFAIK in both 2007 and previous version this is actually a client dependan
t
> behavior. Try :
> http://support.microsoft.com/kb/162059/en-us
> Another option could be to use an object tag (not tried)...
> --
> Patrice
>
> "T" <T@.discussions.microsoft.com> a écrit dans le message de news:
> 49BA0ADC-30D0-4B2E-8724-F3823CBFD8DD@.microsoft.com...
>
>
re:
!> http://support.microsoft.com/kb/162059/en-us
That KB needs revision.
The latest document type listed is Office 8.
Office 2007 is Office 12.
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"Patrice" <http://www.chez.com/scribe/> wrote in message
news:OKO8sV9XHHA.4552@.TK2MSFTNGP05.phx.gbl...
> AFAIK in both 2007 and previous version this is actually a client dependan
t behavior. Try :
> http://support.microsoft.com/kb/162059/en-us
> Another option could be to use an object tag (not tried)...
> --
> Patrice
>
> "T" <T@.discussions.microsoft.com> a crit dans le message de news:
> 49BA0ADC-30D0-4B2E-8724-F3823CBFD8DD@.microsoft.com...
>
I mentionned you could perhaps use an object tag inside your iframe to see
if the document is then forced to be placed inside the IE window...
"T" <T@.discussions.microsoft.com> a crit dans le message de news:
AA9DF605-996F-457E-95C0-A9FE2983D49D@.microsoft.com...
> Hey thanks. I did as suggested in the support article and it does now open
> in
> the iframe.
> However, this must have been something the Office 2007 installation messed
> around with as everything worked fine before installing 2007. Anyone know
> why
> this was done? Also its not something i can expect all our users to do
> after
> they install office 2007, that they then have to for every office file
> type
> select a check box in folder options to allow them to appear in the
> browser.
> Does anyone have any suggestions?
> Cheers
>
> "Patrice" wrote:
>

Office 2007 documents to database, dynamically generate on demand

Hello, I am currently adding some document management functionality to a .Net 2.0 Web app (VB) where I take a file in, save the file to a SQL 2000 database (image datatype), and then allow users to browse and download these files.

This works great for most files my users use -- with the exception of Office 2k7 files

I am able to upload a file, read the file into a binary array and insert into a new record in the database.

However, when I retrieve the binary array and attempt to output the file, there is a problem.

The user is prompted to open or save the file per-usual, however when Word 2007 tries to open the file, there is an error message that says:

"The Office Open XML file Test.docx cannot be opened because there are problems with the contents"

Under "Details" it says:

"The file is corrupt and cannot be opened"

If I click "OK", I am asked whether I want to have Word recover the contents of the document.

If I click "Yes" my document opens and all of the original content is there.

I have been doing some reading, and I know that the new Office 2007 files are really .zip files with XML files that contain formatting and content information.

What I would like to know is, is there a reason why I can't save these files to the database as I have been, and if so, is there a "right" way to do this?

Hi,

Based on my understanding, the users upload the word 2007 files into database and download them with your asp.net application. When you try to open the file that is downloaded, you get the error message above. If I have misunderstood you, please feel free to let me know.

To better understand your issue, could you please confirm the following information:

When we write the file to the client, we should make sure that file doesn't contain HTML-tag. We can add Response.End() right after writing and stop further processing of the ASP.NET page. For more information, seehttp://blog.benday.com/archive/2005/08/09/2705.aspx.

Yes, you have summarized what I am doing correctly.

I have been looking into this in more detail, and after using Hex Workshop, I compared the original file and the streamed file. The streamed file contained 1 extra byte.

I reviewed my code and found that the size of the file in the database was the same as the original, so I reviewed my code in the download.aspx code-behind (the file that streams the requested document).

I had read about this earlier, so I knew not to have any HTML in the aspx.

However, it seems that the Content-Length of the file is zero-based, so when I was setting Content-Length to equal the value I had in the database, an extra byte was being added.

When I set Content-Length to equal the size of the file (in bytes) - 1, I no longer received the error.

Ex:

Dim File As New EO.Library.File(CInt(Request("file")))
Dim _BinaryLength = (CInt(File.Binary.Length) - 1)

Response.Clear()
Response.Buffer = True
Response.AddHeader("Content-Disposition", "attachment;filename=" & File.Name)
Response.AddHeader("Content-Length", CInt(_BinaryLength))
Response.ContentType = File.ContentType
Response.BinaryWrite(File.Binary)
Response.End()

Office 2007 documents not appearing in iframe

We've been developing an application for a while which allows display of
office/pdf etc documents within an iframe in a web browser.

However, since installing office 2007 this has stopped working and instead
of them appearing nicely in the iframe they now pop up and appear within the
office program.

Does anyone know if there is a way to alter the behaviour of office 2007 so
that the documents remain embedded within the iframe, or is this something
which I just have to accept.

ThanksAFAIK in both 2007 and previous version this is actually a client dependant
behavior. Try :
http://support.microsoft.com/kb/162059/en-us
Another option could be to use an object tag (not tried)...

--
Patrice

"T" <T@.discussions.microsoft.coma crit dans le message de news:
49BA0ADC-30D0-4B2E-8724-F3823CBFD8DD@.microsoft.com...

Quote:

Originally Posted by

We've been developing an application for a while which allows display of
office/pdf etc documents within an iframe in a web browser.
>
However, since installing office 2007 this has stopped working and instead
of them appearing nicely in the iframe they now pop up and appear within
the
office program.
>
Does anyone know if there is a way to alter the behaviour of office 2007
so
that the documents remain embedded within the iframe, or is this something
which I just have to accept.
>
Thanks
>

Hey thanks. I did as suggested in the support article and it does now open in
the iframe.

However, this must have been something the Office 2007 installation messed
around with as everything worked fine before installing 2007. Anyone know why
this was done? Also its not something i can expect all our users to do after
they install office 2007, that they then have to for every office file type
select a check box in folder options to allow them to appear in the browser.

Does anyone have any suggestions?

Cheers

"Patrice" wrote:

Quote:

Originally Posted by

AFAIK in both 2007 and previous version this is actually a client dependant
behavior. Try :
http://support.microsoft.com/kb/162059/en-us
>
Another option could be to use an object tag (not tried)...
>
--
Patrice
>
>
>
"T" <T@.discussions.microsoft.coma écrit dans le message de news:
49BA0ADC-30D0-4B2E-8724-F3823CBFD8DD@.microsoft.com...

Quote:

Originally Posted by

We've been developing an application for a while which allows display of
office/pdf etc documents within an iframe in a web browser.

However, since installing office 2007 this has stopped working and instead
of them appearing nicely in the iframe they now pop up and appear within
the
office program.

Does anyone know if there is a way to alter the behaviour of office 2007
so
that the documents remain embedded within the iframe, or is this something
which I just have to accept.

Thanks

>
>
>

re:
!http://support.microsoft.com/kb/162059/en-us
That KB needs revision.
The latest document type listed is Office 8.

Office 2007 is Office 12.

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"Patrice" <http://www.chez.com/scribe/wrote in message
news:OKO8sV9XHHA.4552@.TK2MSFTNGP05.phx.gbl...

Quote:

Originally Posted by

AFAIK in both 2007 and previous version this is actually a client dependant behavior. Try :
http://support.microsoft.com/kb/162059/en-us
>
Another option could be to use an object tag (not tried)...
>
--
Patrice
>
>
>
"T" <T@.discussions.microsoft.coma crit dans le message de news:
49BA0ADC-30D0-4B2E-8724-F3823CBFD8DD@.microsoft.com...

Quote:

Originally Posted by

>We've been developing an application for a while which allows display of
>office/pdf etc documents within an iframe in a web browser.
>>
>However, since installing office 2007 this has stopped working and instead
>of them appearing nicely in the iframe they now pop up and appear within the
>office program.
>>
>Does anyone know if there is a way to alter the behaviour of office 2007 so
>that the documents remain embedded within the iframe, or is this something
>which I just have to accept.
>>
>Thanks
>>

>
>

I mentionned you could perhaps use an object tag inside your iframe to see
if the document is then forced to be placed inside the IE window...

"T" <T@.discussions.microsoft.coma crit dans le message de news:
AA9DF605-996F-457E-95C0-A9FE2983D49D@.microsoft.com...

Quote:

Originally Posted by

Hey thanks. I did as suggested in the support article and it does now open
in
the iframe.
>
However, this must have been something the Office 2007 installation messed
around with as everything worked fine before installing 2007. Anyone know
why
this was done? Also its not something i can expect all our users to do
after
they install office 2007, that they then have to for every office file
type
select a check box in folder options to allow them to appear in the
browser.
>
Does anyone have any suggestions?
>
Cheers
>
>
>
"Patrice" wrote:
>

Quote:

Originally Posted by

>AFAIK in both 2007 and previous version this is actually a client
>dependant
>behavior. Try :
>http://support.microsoft.com/kb/162059/en-us
>>
>Another option could be to use an object tag (not tried)...
>>
>--
>Patrice
>>
>>
>>
>"T" <T@.discussions.microsoft.coma crit dans le message de news:
>49BA0ADC-30D0-4B2E-8724-F3823CBFD8DD@.microsoft.com...

Quote:

Originally Posted by

We've been developing an application for a while which allows display
of
office/pdf etc documents within an iframe in a web browser.
>
However, since installing office 2007 this has stopped working and
instead
of them appearing nicely in the iframe they now pop up and appear
within
the
office program.
>
Does anyone know if there is a way to alter the behaviour of office
2007
so
that the documents remain embedded within the iframe, or is this
something
which I just have to accept.
>
Thanks
>

>>
>>
>>

office automation

Hello,

I have written a bunch of apps in vb .net that automated different office apps. I am very new to asp however. I created an asp .net web application in vs net added a button to a form and inserted this code:

 Dim xlapp As Excel.Application
 Response.Write("excel")
 'Response.Write("fname = " & Fname)
 xlapp = New Excel.Application

and it crashes with an access denied error

ive read some things on line about automating office with asp but they always seem to use c code and i would much rather use vb code

any help/advice or places i can go to read up on this would be greatly appreciated

ThanksHi,

Take a look @.Create and Modify Excel Files (VB)

HTH

Office Components and IIS and .NET Framework

I'd like to generate a Word document from a web app and found many articles that support doing so. However, office components are not available on our web server. Our sys admin told us it is not recommended to install Office components on the web server because Word is client software. (We are so sys admin ignorant in our developer shop.) Does anyone know if this is also true with the .NET framework - that we should not install Office components on the web server?
Thanks so much.Yes, it is recommended not to run office products on a dedicated server.
On one of our servers, MS Access was put on it ONLY because a couple databases may need maintainence from time to time.
There are other servers; however, that are dedicated to running office products that the entire company can share so people don't have to load those products on their local machine.
You may want to look into that option, another server running office and utilities, and then connect to that from your IIS server to launch Word.
Zath

Thanks for your reply.
I was referring to creating word documents via C#.NET using a web pageas the interface. My attempts to do so using wordApp = newWord.ApplicationClass(); failed with error:
COM object with CLSID {000209FF-0000-0000-C000-000000000046} is either not valid or not registered
which I understood was related to Word not being available on the Web Server.
I will look at using MIME types.
Thank you again!
a once former virgin poster,
elle_f

And just came across this bit of code that may interest you...
http://www.developerfusion.com/forums/topic-22540
Zath

office web component

to everyone,in asp.net,how can i use the office web componentHi,

I found this article very helpful

http://www.devx.com/xml/Article/7018/0
Hello,

you have different options to use the OWC but basically you have to store all the files which you want to display with owc in XML-format. For example if you want to load an excel-spreadsheet you must save this as an "XML-Spreadsheet" file before. This is the only format that the OWC Spreadsheet Component can read and bring in all the formulas, etc. Do not attempt to load a regular XLS file in OWC, it can't be done...

Then you can load the spreadsheet in your webform with simple code like i show you in the following example. This is VB.Net but of course you can do it in C# as well:

Dim spreadsheet As OWC10.SpreadsheetClass = New SpreadsheetClass
spreadsheet .XMLURL = MapPath("OWCTest.xml")
spreadsheet .Range("B1:B3").Cells(1).Value = Convert.ToInt32(txtField1.Text)
spreadsheet .Range("B1:B3").Cells(2).Value = Convert.ToInt32(txtField2.Text)
spreadsheet .CalculateFull()
lblMessage.Text = "The result is: " & (sp.Range("B1:B3").Cells(4).Value)

This is an absolute beginner example. If you want to learn more i would recommend the following links:

Creating Excel Spreadsheets with Office Web Components (OWC)
Charting with Office Web Components (OWC)
Creating Dynamic Charts in ASP. NET Web Applications Using OWC

Even MS has a good KB article about this issue:
HOW TO: Use a DataSet with the Office XP Chart Component and ASP.NET

HTH,

Office Web Componenets for Access?

Has anyone had success with Office Web Components with Access? What I have
in mind is a site where Access users can log in and update their Access
databases with new records that have been uploaded by other Access users.
Or perhaps I could have a "shared records" page where anyone can update/add
to a shared record.

The purpose is to have a "sometimes connected" Access application where
folks can log on and share/update/synchronize records as they have
opportunity.

Has anyone done this? Is this even possible with OWC?

Thanks in advance.yup, its possible. The OWC components can handle user input quiet easily
with little work on your part. There are licensing issues you have to
contend with but you can read more about the intricacies of licensing in the
black book.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @. www.lulu.com/owc, Amazon.com etc
"deko" <deko@.deko.com> wrote in message
news:%B0ve.1889$N22.1854@.newssvr21.news.prodigy.co m...
> Has anyone had success with Office Web Components with Access? What I
> have
> in mind is a site where Access users can log in and update their Access
> databases with new records that have been uploaded by other Access users.
> Or perhaps I could have a "shared records" page where anyone can
> update/add
> to a shared record.
> The purpose is to have a "sometimes connected" Access application where
> folks can log on and share/update/synchronize records as they have
> opportunity.
> Has anyone done this? Is this even possible with OWC?
> Thanks in advance.

Office Web Components

Hello All,

I have a project that requires the use of OWC(Office Web Components) for charting values stored into SQL Server. What's the best method to use this, Classic ASP? or ASP.NET (VB.NET) or (C#) ?? I heard that this OWC is not very well documented, is there any examples out there ??.

Thanks In Advance

TonyIf you only need charting you can use a control I've built:
WebChart control

office web components

Hi there
I'm producing charts on the fly using Office Web Components and VBScript in
my ASP.NET application. The problem for me is that VBScript (which I'm new
at) and VBA (which I have a bit of experience in) use fairly different code
to achieve the same thing.
If I take a previously produced chart (produced manually in Excel) as a
template, is there any way to list all the chart's properties and settings,
specifically the non-default settings? I've tried visually recreating the
chart with the Macro Recorder on, but this isn't very helpful for two
reasons: I would have to recreate an awful lot of charts; and the massive
list of properties put out by the Macro Recorder don't make it immediately
clear which are mine and which are the defaults/non-essential settings?
Please help!
Best regards
LoaneHi Loane:
I believe these are two distinct objects are they not? One is an OWC.Chart
and the other an MSChart.Chart, thus the difference isn't in the language
but the object model.
Scott
http://www.OdeToCode.com/blogs/scott/

> Hi there
> I'm producing charts on the fly using Office Web Components and
> VBScript in my ASP.NET application. The problem for me is that
> VBScript (which I'm new at) and VBA (which I have a bit of experience
> in) use fairly different code to achieve the same thing.
> If I take a previously produced chart (produced manually in Excel) as
> a template, is there any way to list all the chart's properties and
> settings, specifically the non-default settings? I've tried visually
> recreating the chart with the Macro Recorder on, but this isn't very
> helpful for two reasons: I would have to recreate an awful lot of
> charts; and the massive list of properties put out by the Macro
> Recorder don't make it immediately clear which are mine and which are
> the defaults/non-essential settings?
> Please help!
> Best regards
> Loane
Hi Scott
Nothing like a novice to sound like a complete idiot! I suppose what I
should have said is, I find the OWC Help file a bit sparse, and I'm trying
to find a detailed listing of the properties, enumerated constants,
appropriate syntax, etc. associated with OWC chartspaces. I've found some
great articles on MSDN, but these are pretty introductory. I was hoping
there'd be a close mapping between VBA and VBScript in this respect, but not
much luck. I should have known there'd be no lazy way out.
Thanks for your reply.
Best regards
Loane
> I believe these are two distinct objects are they not? One is an OWC.Chart
> and the other an MSChart.Chart, thus the difference isn't in the language
> but the object model.
>

office web components

Hi there

I'm producing charts on the fly using Office Web Components and VBScript in
my ASP.NET application. The problem for me is that VBScript (which I'm new
at) and VBA (which I have a bit of experience in) use fairly different code
to achieve the same thing.

If I take a previously produced chart (produced manually in Excel) as a
template, is there any way to list all the chart's properties and settings,
specifically the non-default settings? I've tried visually recreating the
chart with the Macro Recorder on, but this isn't very helpful for two
reasons: I would have to recreate an awful lot of charts; and the massive
list of properties put out by the Macro Recorder don't make it immediately
clear which are mine and which are the defaults/non-essential settings?

Please help!

Best regards
LoaneHi Loane:

I believe these are two distinct objects are they not? One is an OWC.Chart
and the other an MSChart.Chart, thus the difference isn't in the language
but the object model.

--
Scott
http://www.OdeToCode.com/blogs/scott/

> Hi there
> I'm producing charts on the fly using Office Web Components and
> VBScript in my ASP.NET application. The problem for me is that
> VBScript (which I'm new at) and VBA (which I have a bit of experience
> in) use fairly different code to achieve the same thing.
> If I take a previously produced chart (produced manually in Excel) as
> a template, is there any way to list all the chart's properties and
> settings, specifically the non-default settings? I've tried visually
> recreating the chart with the Macro Recorder on, but this isn't very
> helpful for two reasons: I would have to recreate an awful lot of
> charts; and the massive list of properties put out by the Macro
> Recorder don't make it immediately clear which are mine and which are
> the defaults/non-essential settings?
> Please help!
> Best regards
> Loane
Hi Scott

Nothing like a novice to sound like a complete idiot! I suppose what I
should have said is, I find the OWC Help file a bit sparse, and I'm trying
to find a detailed listing of the properties, enumerated constants,
appropriate syntax, etc. associated with OWC chartspaces. I've found some
great articles on MSDN, but these are pretty introductory. I was hoping
there'd be a close mapping between VBA and VBScript in this respect, but not
much luck. I should have known there'd be no lazy way out.

Thanks for your reply.

Best regards
Loane

> I believe these are two distinct objects are they not? One is an OWC.Chart
> and the other an MSChart.Chart, thus the difference isn't in the language
> but the object model.
>> I'm producing charts on the fly using Office Web Components and
>> VBScript in my ASP.NET application. The problem for me is that
>> VBScript (which I'm new at) and VBA (which I have a bit of experience
>> in) use fairly different code to achieve the same thing.
>>
>> If I take a previously produced chart (produced manually in Excel) as
>> a template, is there any way to list all the chart's properties and
>> settings, specifically the non-default settings? I've tried visually
>> recreating the chart with the Macro Recorder on, but this isn't very
>> helpful for two reasons: I would have to recreate an awful lot of
>> charts; and the massive list of properties put out by the Macro
>> Recorder don't make it immediately clear which are mine and which are
>> the defaults/non-essential settings?

Office Web Components

Hello,
Does anyone know of a web site(s) with examples of working with Microsoft
Web Components? Or some examples?

Thanks to all...Hi Randy:

Google will turn up many good examples:

http://www.google.com/search?hl=en&q=owc+asp.net

HTH,

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Wed, 25 May 2005 09:42:12 -0500, "Randy" <temp@.temp.com> wrote:

>Hello,
>Does anyone know of a web site(s) with examples of working with Microsoft
>Web Components? Or some examples?
>Thanks to all...
You should get the black book. It provides all that you need.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @. www.lulu.com/owc, Amazon.com etc
"Randy" <temp@.temp.com> wrote in message
news:uZdHxfTYFHA.3836@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Does anyone know of a web site(s) with examples of working with Microsoft
> Web Components? Or some examples?
> Thanks to all...

Office Web Components

Hi

Any one have an example about how to use OWC pivot tables ??

thanks in advance
--
Salu2
Sergio T.I have not tried, but check this one:
http://www.csharphelp.com/archives4/archive623.html
"SergioT" <stardio@.noSpamgmail.comwrote in message
news:OwoztA$6GHA.3732@.TK2MSFTNGP05.phx.gbl...
Hi

Any one have an example about how to use OWC pivot tables ??

thanks in advance
--
Salu2
Sergio T.

Office Web Components

Hi!!,

I have tried to generate Excell grafics using OWC10 dll. In my asp.net page,
i have a dropdownlist where i can select the type of the grafic, a
linkbutton where i can clik to generate the grafic, and a Image WebControl
where i show the grafic, but i have a problem. The first time i click the
linkbutton, it show the grafic correctly, but when i click more times,
although the grafic has been generated correctly ,the image show the first
grafic.

How can resolve this?

thank you very much.

P.D.: I hope explain it well. Sorry for my bad english.

--

Julin Sanz
Salamanca (Espaa)You need to have unique names for your graph otherwise it overwrites the
last image.
window.open('graph.aspx','this needs to be a unique name'...

you can get unique names by using this line of code
System.Text.RegularExpressions.Regex.Replace(DateT ime.Now.ToString(),"\\D","
")

--

----
Got TidBits?
Get it here: www.networkip.net/tidbits
"Julian Sanz" <jsanzg@.gpm.es> wrote in message
news:e158gDsnDHA.360@.TK2MSFTNGP12.phx.gbl...
> Hi!!,
> I have tried to generate Excell grafics using OWC10 dll. In my asp.net
page,
> i have a dropdownlist where i can select the type of the grafic, a
> linkbutton where i can clik to generate the grafic, and a Image WebControl
> where i show the grafic, but i have a problem. The first time i click the
> linkbutton, it show the grafic correctly, but when i click more times,
> although the grafic has been generated correctly ,the image show the first
> grafic.
> How can resolve this?
> thank you very much.
> P.D.: I hope explain it well. Sorry for my bad english.
> --
> Julin Sanz
> Salamanca (Espaa)
well, i save the grafic in a image filethat it names "grafico.gif". When I
generate the image, i overwrite the last grafic, this is what i want, but
the asp.net page show the first image. When i refresh the page with the
refresh button of the explorer, it shows the correctly image. I understand
you that i have to create a diferent image file for each grafic, these image
files have to have diferents names. Have i understand you well?

"Alvin Bruney" <vapordan_spam_me_not@.hotmail_no_spamhotmail.com> escribi en
el mensaje news:uR8Sf6wnDHA.688@.TK2MSFTNGP10.phx.gbl...
> You need to have unique names for your graph otherwise it overwrites the
> last image.
> window.open('graph.aspx','this needs to be a unique name'...
> you can get unique names by using this line of code
System.Text.RegularExpressions.Regex.Replace(DateT ime.Now.ToString(),"\\D","
> ")
>
> --
>
> ----
> Got TidBits?
> Get it here: www.networkip.net/tidbits
> "Julian Sanz" <jsanzg@.gpm.es> wrote in message
> news:e158gDsnDHA.360@.TK2MSFTNGP12.phx.gbl...
> > Hi!!,
> > I have tried to generate Excell grafics using OWC10 dll. In my asp.net
> page,
> > i have a dropdownlist where i can select the type of the grafic, a
> > linkbutton where i can clik to generate the grafic, and a Image
WebControl
> > where i show the grafic, but i have a problem. The first time i click
the
> > linkbutton, it show the grafic correctly, but when i click more times,
> > although the grafic has been generated correctly ,the image show the
first
> > grafic.
> > How can resolve this?
> > thank you very much.
> > P.D.: I hope explain it well. Sorry for my bad english.
> > --
> > Julin Sanz
> > Salamanca (Espaa)

Office Web Component Print preview

Hi all
Was working on Office web component 3.0 which fits in to my projects.
but came across one problem

in excel when we give the print preview it displays the whole format
of the sheet.
even in page preview im able to see only those part which is displayed
on the form.

Is there any way to display the sheet data in OWC in the print preview
of the page.??

Any idea would be appreated.There is no publicly released OWC version 3.

Quote:

Originally Posted by

Is there any way to display the sheet data in OWC in the print preview
of the page.??

Not easily. If you have the energy to, you can download the print behavior
files for the owc 10 version and tweak the code.

--
Regards,
Alvin Bruney
----------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99

"jack" <gautams.mail@.gmail.comwrote in message
news:1193056230.374668.83990@.i13g2000prf.googlegro ups.com...

Quote:

Originally Posted by

Hi all
Was working on Office web component 3.0 which fits in to my projects.
but came across one problem
>
in excel when we give the print preview it displays the whole format
of the sheet.
even in page preview im able to see only those part which is displayed
on the form.
>
Is there any way to display the sheet data in OWC in the print preview
of the page.??
>
>
Any idea would be appreated.
>

Office Web Components

Hello,
Does anyone know of a web site(s) with examples of working with Microsoft
Web Components? Or some examples?
Thanks to all...Hi Randy:
Google will turn up many good examples:
http://www.google.com/search?hl=en&q=owc+asp.net
HTH,
Scott
http://www.OdeToCode.com/blogs/scott/
On Wed, 25 May 2005 09:42:12 -0500, "Randy" <temp@.temp.com> wrote:

>Hello,
>Does anyone know of a web site(s) with examples of working with Microsoft
>Web Components? Or some examples?
>Thanks to all...
>
You should get the black book. It provides all that you need.
Regards,
Alvin Bruney - ASP.NET MVP
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @. www.lulu.com/owc, Amazon.com etc
"Randy" <temp@.temp.com> wrote in message
news:uZdHxfTYFHA.3836@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Does anyone know of a web site(s) with examples of working with Microsoft
> Web Components? Or some examples?
> Thanks to all...
>

Office Web Components

Hi
Any one have an example about how to use OWC pivot tables '
thanks in advance
--
Salu2
Sergio T.I have not tried, but check this one:
http://www.csharphelp.com/archives4/archive623.html
"SergioT" <stardio@.noSpamgmail.com> wrote in message
news:OwoztA$6GHA.3732@.TK2MSFTNGP05.phx.gbl...
Hi
Any one have an example about how to use OWC pivot tables '
thanks in advance
--
Salu2
Sergio T.

Office Web Components

I want to give users full pivot-table interactivity with the data in three cubes onthis Web site. All users are prompted to set the site as atrusted site,and are warned about the data source. Most users are able to thenbrowse the "data analyst tables". I'm getting a lot of positivefeedback.
In all cases, users are set up withMicrosoft Windows XP, Office (XP, I think), and the latest version ofInternet Explorer. Each page (the .mht file) merely links to the"single-fileWeb page", created from an Excel pivot table, which is connected to anAnalysis Server cube. Most users have the same configuration forWindows Firewall, anti-virus software, spyware protection, and networkconnectivity.

Some users (actually, about one-third) are unable to open the pivottables. In some cases, the screen will "flash" a small icon where thepivot table should be, and then sit there with no hint that anything iswrong. In other cases, the user will get a "frame" of the pivot table(the toolbar and data areas), but no data and no helpful feedback.Allusersare reporting an unexpected behavior; with each change of the pivottable, the display "creeps" up and left slightly: After about twentyclicks on the table, the left margin of the table is off the screen.Has anyone seen this? How can I keep the table from creeping away?
I have the impression that there's a better way to do this. Should I beplacing an OWC object on a page, then populating it? How can Itroubleshoot the failure-to-display problem? I'm writing C# code inVisual Studio .NET v1.1.4322 SP1.
Rick
RickInMesa--
Regarding this...

RickInMesa wrote:

...Some users (actually, about one-third) are unable to open the pivot tables. In some cases, the screen will "flash" a small icon where the pivot table should be, and then sit there with no hint that anything is wrong. In other cases, the user will get a "frame" of the pivot table (the toolbar and data areas), but no data and no helpful feedback.Allusers are reporting an unexpected behavior; with each change of the pivot table, the display "creeps" up and left slightly: After about twenty clicks on the table, the left margin of the table is off the screen... How can I troubleshoot the failure-to-display problem?...

...I can say that in my experience using (MSOffice + InternetExplorer) solutions, it is absolutely necessary to make sure each and every machine running the application must have the exact same version of Office and every machine has been fully patched with all available updates from the Microsoft Update site,http://update.microsoft.com/ .
I know this is a simplistic and somewhat brute-force approach; but, I have found it is the only way to get to ground-zero and then to begin debugging.
HTH.



Thank you, Mark. That's a good tip, and something that needs to be done first, I agree.
What about the "creepy" display? It shouldn't creep away on everyrefresh, should it? Users are saying that they like the pivot table,but just when they get the displayperfect, it's too far offthe left edge of the screen to see the column there. They have to startover, and try to do it with 15 clicks instead of 30.
Rick


RickInMesa--
Regarding this...

RickInMesa wrote:

...What about the "creepy" display? It shouldn't creep away on every refresh, should it?...

...I am sorry; but, I have no solution for this.
I have seen this sort of thing with embedded components and have reached the conclusion that "some of them work better than others and some of them don't work at all".
IMHO, this is just another piece of evidence that embedded controls in a web application (such as ActiveX, Flash, RealAudio, WindowsMediaPlayer, OfficeControls, the interactive Excel-on-the-web functionality, Crystal, and so on) are out of place, proprietary, and very buggy. For reporting, I like the dynamic reporting approach that offers the enduser some way to build a "query", excecute it, and display the results as HTML or PDF. That's stable. I think that web controls fail because the underlying environment (the browser) is not stable or standardized.
HTH.
Thank you.

Office Web Components COM error (Charting)

Hi all,
I am using the Office Web Components (Interop.OWC10.dll) to generate agrapth on my ASP.NET application and am getting the following messagefor some reason...
System.Runtime.InteropServices.COMException (0x80040154) Office Web Components
I have also referenced the following .dll's...
Interop.ADODB.dll
Interop.MSComctlLib.dll
This error occurs in a method I have called GenerateGraph(). The code contained in this method is as follows...
private void GenerateGraph()
{
try
{
//First create a ChartSpace object to hold the chart
OWC10.ChartSpaceClass objCSpace = newOWC10.ChartSpaceClass();

//Add a chart in the ChartSpace. The Add methodreturns a chart object.
OWC10.ChChart objChart = objCSpace.Charts.Add(0);
//Specify the type of the graph to be displayed. Thetype of the graph is specified by the enumerated values inOWC.ChartChartTypeEnum
objChart.Type =OWC10.ChartChartTypeEnum.chChartTypeLine;
//Give title to graph.
objChart.HasTitle = true;
objChart.Title.Caption = "Discontinuity Report";
objChart.Title.Font.Bold = true;
//Give the caption for the X axis and Y axis of thegraph
objChart.Axes[0].HasTitle = true;
objChart.Axes[0].Title.Caption = "Response Time";
objChart.Axes[0].HasTickLabels = true;
objChart.Axes[0].TickLabelSpacing = 5;
//Give the caption for the X axis and Y axis of thegraph
objChart.Axes[1].HasTitle = true;
objChart.Axes[1].Title.Caption = "Calls";
//Populate the Literal Strings For the data
//The categories and values can be given as literalstring with values separated by tabs. With these three values we candraw a single line.*/
//Dim strSeriesName As String = "Responses"
string strCategory = "";
string strValue = "";
//Add a series to the chart's series collection
objChart.SeriesCollection.Add(0);
FillDataStrings(ref strCategory, ref strValue);
//Give the name of the series
objChart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,System.Convert.ToInt32(OWC10.ChartSpecialDataSourcesEnum.chDataLiteral),""); //strSeriesName)
//Give the Categories
objChart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimCategories,System.Convert.ToInt32(OWC10.ChartSpecialDataSourcesEnum.chDataLiteral),strCategory);
//Give The values
objChart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimValues,System.Convert.ToInt32(OWC10.ChartSpecialDataSourcesEnum.chDataLiteral),strValue);
//Now a chart is ready to export to a GIF.
string strFilename = "PerformanceGraph" +DateTime.Now.ToString("ddMMyyyyhhmmss") + 1000 * 1000 + ".gif";
string strAbsolutePath = (Server.MapPath(".")) +"\\TempFiles\\" + strFilename;
//string strAbsolutePath = (
objCSpace.ExportPicture(strAbsolutePath, "GIF", 800,480);
//Create a relative path to the GIF file.
//If an absolute path is used instead of a relativepath, the file will not be displayed in the client machines as the fileis created in the server, not in the client. */
//string AppName =
//string strAppPath =Rainbow.Settings.Path.ApplicationPhysicalPath + "TempFiles\\" +strFilename;
string strAppPath =Rainbow.Settings.Path.ApplicationRoot + "/TempFiles/" + strFilename;
//Add the image into the placeholder.
string strImageTag = "<IMG SRC=\"" + strAppPath +"\" />";
phChart.Controls.Add(newLiteralControl(strImageTag));
Log.ApplicationLog.Write("Graph paths: \n\rApp Path:" + strAppPath + "\n\rImage Tag Path: " + strImageTag);
}
catch (Exception E)
{
Log.ApplicationLog.Write("Error: " + E);
}
}
For the life of me I can't seem to find out where exactly theproblem lies (though I have found some sources online that state thatthe the COM object may not be registered - I doubt it is this though asit would have been stated in the error message).
Hope someone can help me here.
Tryst
Which line of code is producing that error?
Did you try registering it?

regsvr32 xyz.dll
It doesn't exactly state which line it is one. It just references the method in which the error is called.
The Office Web Components were already installed as we had previous reports using the Office Web Components.
I'm not really sure what the problem can be? Are there any other possible external factors that may be causing this?
Thanks
Tryst

Try the link below for PInvoke(platform invoke). Hope this helps.
http://www.pinvoke.net
I use OWC all over the place, seems to me I get a line number. How about trying this, walk through each line of code and let us know which it dies on?
Or...
I have a little OWC Chart Helper class that I just posted at my blog. Its not very well documented, but perhaps it'll help you out? I write classes like this to help me use complicated stuff like OWC a bit more easily. I also have an Excel helper that is an interface implementing both OWC and Excel models, I'll post it soon. I need to clean these things up.
http://spaces.msn.com/members/mutethis/Blog/cns!1pqaRX9UNoMK6pqNr__0Gnqw!167.entry
HTH

Office Web Components and colour of series

Hello,
I need to dinamically generate some chart with office web components
and parts. There is a way to choose the colour of series?

Thank You
ExchIt should be something like:

oChartSpace.Charts[0].SeriesCollection[1].Interior.Color = "red";
oChartSpace.Charts[0].SeriesCollection[1].Line.Color = "red";

/// ----------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ----------

"Exch" wrote:

Quote:

Originally Posted by

Hello,
I need to dinamically generate some chart with office web components
and parts. There is a way to choose the colour of series?
>
Thank You
Exch
>
>

office xp web components

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" <John@.discussions.microsoft.com> wrote in message
> news:BC52CED8-F1E9-4878-B747-EF743CE1339C@.microsoft.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?
>
> 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" <John@.discussions.microsoft.com> wrote in message
news:BC52CED8-F1E9-4878-B747-EF743CE1339C@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
news:93034106-8A60-4B71-BF37-C0A2ADF9C3F0@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > news:BC52CED8-F1E9-4878-B747-EF743CE1339C@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> news:93034106-8A60-4B71-BF37-C0A2ADF9C3F0@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > > news:BC52CED8-F1E9-4878-B747-EF743CE1339C@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
news:8A01D111-5A01-4B73-B19E-96119B85B44F@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > news:93034106-8A60-4B71-BF37-C0A2ADF9C3F0@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > > > news:BC52CED8-F1E9-4878-B747-EF743CE1339C@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> news:8A01D111-5A01-4B73-B19E-96119B85B44F@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > > news:93034106-8A60-4B71-BF37-C0A2ADF9C3F0@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > > > > news:BC52CED8-F1E9-4878-B747-EF743CE1339C@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
news:879490C5-6B64-477F-B737-FB758F6DF455@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > news:8A01D111-5A01-4B73-B19E-96119B85B44F@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > > > news:93034106-8A60-4B71-BF37-C0A2ADF9C3F0@.microsoft.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" <John@.discussions.microsoft.com> wrote in message
> > > > > > news:BC52CED8-F1E9-4878-B747-EF743CE1339C@.microsoft.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?
> > > > > > > > > > > > > > > > > >