I'd like to be able to programmatically manipulate the HTML code that
is entered into the Source Editor Text Entry dialog box of a Content
Editor web part. I've got a couple of questions:

1) Where is this HTML code stored (I assumed it would either be in a
SQL Server table or in an XML file, but can't find it in either).

2) Has anyone found a good way to paste HTML into the web part Source
Editor from another application?

I'm trying to create a process where changing content in a different
application (Excel) pushes the corresponding changes into the Content
Editor.

Any help is appreciated

Thanks

k2

Re: Content Editor HTML code - can I push code in? by Giles

Giles
Sat Aug 14 16:25:16 CDT 2004

Programmatically? with c#? I think javascript is the only programmatic way
you could alter html in a content editor web part. You will need to build a
web part if you wish to use a proper programming language.

1) yes, it's in the database, but I don't know where. I wouldn't recommend
editing the contents of the sql database directly...
2) I have used 'copy' and 'paste' to achieve this.

I would recommend using the excel 'save as' html feature. Then upload the
new .htm version of your spreadsheet into a document library. Right click on
the uploaded document in the doc lib and select 'copy shortcut'. This will
give you the absolute url of the uploaded document.

Go to your content editor web part, delete any existing content, and then
paste the url of the uploaded .htm document in to the "content link" field.
You should find the excel document is now displayed in the web part.

When you make updates to the excel document, do save as html each time and
over-write the existing htm document. Depending on what your version of
windows and/or office is, you may be able to save directly to the document
library and not have to follow the uploading steps each time...

hope this meets your requirements,
Giles

"k2" <kevin.keeffe@overlakehospital.org> wrote in message
news:41c0d82c.0408111513.4f40266e@posting.google.com...
> I'd like to be able to programmatically manipulate the HTML code that
> is entered into the Source Editor Text Entry dialog box of a Content
> Editor web part. I've got a couple of questions:
>
> 1) Where is this HTML code stored (I assumed it would either be in a
> SQL Server table or in an XML file, but can't find it in either).
>
> 2) Has anyone found a good way to paste HTML into the web part Source
> Editor from another application?
>
> I'm trying to create a process where changing content in a different
> application (Excel) pushes the corresponding changes into the Content
> Editor.
>
> Any help is appreciated
>
> Thanks
>
> k2



Re: Content Editor HTML code - can I push code in? by Steven

Steven
Sun Aug 15 10:33:41 CDT 2004

If you use Excel 2003 and install the office 2003 webparts you can publish
straight from Excel into a webpart, each time you save the spreadsheet Excel
also updates the webpart.

Steven Collier


On 14/8/04 22:25, in article O8$tzUkgEHA.3264@tk2msftngp13.phx.gbl, "Giles
Gregg" <anon@microsoft.com> wrote:

> Programmatically? with c#? I think javascript is the only programmatic way
> you could alter html in a content editor web part. You will need to build a
> web part if you wish to use a proper programming language.
>
> 1) yes, it's in the database, but I don't know where. I wouldn't recommend
> editing the contents of the sql database directly...
> 2) I have used 'copy' and 'paste' to achieve this.
>
> I would recommend using the excel 'save as' html feature. Then upload the
> new .htm version of your spreadsheet into a document library. Right click on
> the uploaded document in the doc lib and select 'copy shortcut'. This will
> give you the absolute url of the uploaded document.
>
> Go to your content editor web part, delete any existing content, and then
> paste the url of the uploaded .htm document in to the "content link" field.
> You should find the excel document is now displayed in the web part.
>
> When you make updates to the excel document, do save as html each time and
> over-write the existing htm document. Depending on what your version of
> windows and/or office is, you may be able to save directly to the document
> library and not have to follow the uploading steps each time...
>
> hope this meets your requirements,
> Giles
>
> "k2" <kevin.keeffe@overlakehospital.org> wrote in message
> news:41c0d82c.0408111513.4f40266e@posting.google.com...
>> I'd like to be able to programmatically manipulate the HTML code that
>> is entered into the Source Editor Text Entry dialog box of a Content
>> Editor web part. I've got a couple of questions:
>>
>> 1) Where is this HTML code stored (I assumed it would either be in a
>> SQL Server table or in an XML file, but can't find it in either).
>>
>> 2) Has anyone found a good way to paste HTML into the web part Source
>> Editor from another application?
>>
>> I'm trying to create a process where changing content in a different
>> application (Excel) pushes the corresponding changes into the Content
>> Editor.
>>
>> Any help is appreciated
>>
>> Thanks
>>
>> k2
>
>