Embedding an Excel sheet in a web page

[Guest]

Hi all...

I have a worksheet in Excel. I'd like to publish a range on the sheet
in a webpage for a site I'm maintaining.

Is there a way to use object linking and embedding to insert
the range into a webpage, and then publish the webpage as
simple HTML, in effect breaking the link at the time it's published?

I suppose I could develop an FP design-time automation solution
that does a copy and paste, but was sort of hoping for an
easier method.

Thanks!

 

[Stefan B Rusynko]

In Excel Select the range and Save a Html - selected range
Then in FP File Import the html page and use it as an include page
- or just copy / paste the range from Excel to a FP page




<MVSmith> wrote in message | Hi all...
|
| I have a worksheet in Excel. I'd like to publish a range on the sheet
| in a webpage for a site I'm maintaining.
|
| Is there a way to use object linking and embedding to insert
| the range into a webpage, and then publish the webpage as
| simple HTML, in effect breaking the link at the time it's published?
|
| I suppose I could develop an FP design-time automation solution
| that does a copy and paste, but was sort of hoping for an
| easier method.
|
| Thanks!
|
|
|

 

[Guest]

Thanks, Stefan...

I guess it would be relatively easy to do VB in Excel,
save out the range as HTML in an FP web folder, and
then hand off the filename to VB in FP for inclusion
in an FP page. I suppose you could even get the file,
strip out the innerHTML of its BODY element, and
insert it at design time.

--mvsmith

 

[Stefan B Rusynko]

Actually in Excel VBA you could generate the entire page in FP using the named range





<MVSmith> wrote in message | Thanks, Stefan...
|
| I guess it would be relatively easy to do VB in Excel,
| save out the range as HTML in an FP web folder, and
| then hand off the filename to VB in FP for inclusion
| in an FP page. I suppose you could even get the file,
| strip out the innerHTML of its BODY element, and
| insert it at design time.
|
| --mvsmith
|
|
| | > In Excel Select the range and Save a Html - selected range
| > Then in FP File Import the html page and use it as an include page
| > - or just copy / paste the range from Excel to a FP page
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > <MVSmith> wrote in message | > | Hi all...
| > |
| > | I have a worksheet in Excel. I'd like to publish a range on the sheet
| > | in a webpage for a site I'm maintaining.
| > |
| > | Is there a way to use object linking and embedding to insert
| > | the range into a webpage, and then publish the webpage as
| > | simple HTML, in effect breaking the link at the time it's published?
| > |
| > | I suppose I could develop an FP design-time automation solution
| > | that does a copy and paste, but was sort of hoping for an
| > | easier method.
| > |
| > | Thanks!
| > |
| > |
| > |
| >
| >
|
|