R
rf76rm
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
='urn:schemas-microsoft-comfficeffice'
xmlns:x='urn:schemas-microsoft-comffice:excel'
xmlns:ss='urn:schemas-microsoft-comffice: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>
<xageSetup />
<xrint>
<x:ValidPrinterInfo/>
</xrint>
</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
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
='urn:schemas-microsoft-comfficeffice'xmlns:x='urn:schemas-microsoft-com
ffice:excel'xmlns:ss='urn:schemas-microsoft-com
ffice: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
ageSetup /><x
rint><x:ValidPrinterInfo/>
</x
rint></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