Hello KKarre,
Frankly, I am still not 100% clear about your design request. Would you
help me confirm the following points so that I can do a better support for
this case?
1. When you saved the Excel workbook as web page, did you choose the "Add
interactivity" option in the Save As dialog?
(I hope to know it because this option decides the appearance and some
frame structure of the generated html page)
2. You mentioned that "if the tabs are selected at the bottom you only get
that frame", I think this depends on how you print the page:
If you use the javascript window.print(); it will print the frame where
this javascript is located, and all its sub frames. So we can either put it
outside the whole workbook frame to print both the spreadsheet data and the
tab bar in the bottom, or put the javascript in a certain spreadsheet's
page (located in [WorkbookName]_files folder\sheet00n.htm) to print the
active spreadsheet data only.
If you use IE File menu -> Print to print the page, we can print the whole
page directly, including the spreadsheet data and the tab bar.
3. I notice you expect the function run well in other browsers than IE. I
believe all the standard browsers support the javascript "window.print()".
4. What's the easiest way to accomplish this? Linking to a non-frame,
printer friendly page and printing that?
In the generated htm from the Excel workbook, there is a sub folder named
as [WorkbookName]_files. Each worksheet in the original workbook are stored
as sheet00n.htm in this folder. And these htm's has no frame. Therefore, I
think we can write the javascript as:
<script>
function print_url(url)
{
location=url;
print();
}
</script>
<a
href="javascript
rint_url('
http://¡/[WorkbookName]_files/sheet001.htm')">P
rint sheet 1</a>
Am I understanding this case correctly? Feel free to correct me, thanks.
Regards,
Jialiang Ge (
[email protected], remove 'online.')
Microsoft Online Community Support
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.