LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Testing Reverse Compatibility and Compatibility in General dim Excel Discussion (Misc queries) 4 January 8th 08 01:02 PM
Number Transformation Saxman Excel Discussion (Misc queries) 8 June 18th 07 11:09 PM
Converting Test Scores to somewhat of a Linear Transformation [email protected] Excel Worksheet Functions 6 February 11th 07 01:30 PM
Data Transformation zaisaki[_3_] Excel Programming 2 October 30th 05 03:51 AM
excel compatibility marty Excel Worksheet Functions 2 May 30th 05 11:45 PM


All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"