J
JFD
Hi gang,
OK, I've just wasted 30 minutes trying to do something I thought would be
very simple.
I have a client who produces, on a weekly basis, a simple 30 line Excel
spreadsheet. The spreadsheet does contain some formatting - colors, borders,
etc. I want to create a situation where this individual can save his
spreadsheet to the same folder in this front-page web site each week. (Yes,
the file name would be the same each time, overwriting the previous version
of the file.)
I am quite familiar with using the include page Web component and was
expecting that would be able to designate an empty table cell on my target
page and use it to display this simple spreadsheet. (Expecting that each
time the sheet was updated, assuming it didn't get any larger, that it would
just replace the previous version)
I have tried saving the spreadsheet in various formats including HTML, XML,
and xls.
While I get various results that are something like the spreadsheet - I
don't get the formatting.
When I'm in the Excel file and I do a "preview as web page" in the browser I
get a great result.
When I save as web page (HTML), import the file into the web site, and
display the file in a table on my page using the include page Web component,
the formatting of my spreadsheet doesn't look at all like it does what it's
just displayed by itself in the browser.
I know there's got to be simple easy way to display an Excel spreadsheet
inside the body of a front-page web page with formatting intact.
I have searched the Microsoft knowledge base that all of the references I
have found focus on creating an editable active-x control version of the
spreadsheet, which I absolutely do not want. Rather, just a simple display of
information with formatting intact.
If someone has actually achieved this, with formatting intact, please respond.
Respectfully, I'm only interested in a 100% Microsoft solution.
OK, I've just wasted 30 minutes trying to do something I thought would be
very simple.
I have a client who produces, on a weekly basis, a simple 30 line Excel
spreadsheet. The spreadsheet does contain some formatting - colors, borders,
etc. I want to create a situation where this individual can save his
spreadsheet to the same folder in this front-page web site each week. (Yes,
the file name would be the same each time, overwriting the previous version
of the file.)
I am quite familiar with using the include page Web component and was
expecting that would be able to designate an empty table cell on my target
page and use it to display this simple spreadsheet. (Expecting that each
time the sheet was updated, assuming it didn't get any larger, that it would
just replace the previous version)
I have tried saving the spreadsheet in various formats including HTML, XML,
and xls.
While I get various results that are something like the spreadsheet - I
don't get the formatting.
When I'm in the Excel file and I do a "preview as web page" in the browser I
get a great result.
When I save as web page (HTML), import the file into the web site, and
display the file in a table on my page using the include page Web component,
the formatting of my spreadsheet doesn't look at all like it does what it's
just displayed by itself in the browser.
I know there's got to be simple easy way to display an Excel spreadsheet
inside the body of a front-page web page with formatting intact.
I have searched the Microsoft knowledge base that all of the references I
have found focus on creating an editable active-x control version of the
spreadsheet, which I absolutely do not want. Rather, just a simple display of
information with formatting intact.
If someone has actually achieved this, with formatting intact, please respond.
Respectfully, I'm only interested in a 100% Microsoft solution.