Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I've developed a ASP page that displays data in excel format by XSL Microsoft Office 2003 Schemas; I need of some particular features to print this document, like orientation, footer, margin etc. That code below works well if I run it in a browser where running Office 2003, but it doesn't work in a machine where running Office 2000 (I think the xsl attributes mso-footer-data and margin aren't read by Office 2000 plug-in). Have you any suggestion? Thanks in advance Rob <html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns:ss='urn:schemas-microsoft-com:office:spreadsheet' xmlns='http://www.w3.org/TR/REC-html40'" <head <style @page{mso-page-orientation:landscape;margin:.25in .25in .5in .25in; mso-header-margin:.5in; mso-footer-margin:.25in; mso-footer-data:'&R&P di &N'; mso-horizontal-page-align:center;} <xml <x:ExcelWorkbook <x:ExcelWorksheets <x:ExcelWorksheet <x:WorksheetOptions <x:PageSetup / <x:Print <x:ValidPrinterInfo/ </x:Print </x:WorksheetOptions </x:ExcelWorksheet </x:ExcelWorksheets </x:ExcelWorkbook </xml </style .........data........ Response.Buffer = True Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "attachment; filename="test.xls" Response.Write strHtml Response.Flush Response.End |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Testing Reverse Compatibility and Compatibility in General | Excel Discussion (Misc queries) | |||
Number Transformation | Excel Discussion (Misc queries) | |||
Converting Test Scores to somewhat of a Linear Transformation | Excel Worksheet Functions | |||
Data Transformation | Excel Programming | |||
excel compatibility | Excel Worksheet Functions |