compatibility to EXCEL transformation
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
|