
April 26th, 2004, 09:09 PM
|
|
Contributing User
|
|
Join Date: Mar 2004
Posts: 31
Time spent in forums: 5 m 40 sec
Reputation Power: 5
|
|
Setting Picture as a Header in Page setup in excel
Hi,
I use the following xml script to set the Printing options in excel spreadsheet and they work fine. Does anyone know how to set a picture as a header using xml. ie. Instead of 'Hello everyone' in the header I want to display a picture, is this possible? Any help will be greatly appriciated.
Quote:
<HTML xmlns:x="urn:schemas-microsoft-com ffice:excel">
<head>
<style>
@page
{
mso-page-orientation ortrait;
margin:0.5in 0.551in 1.1437in 0in;
mso-footer-margin:0.3149in;
mso-header-margin:0in;
mso-header-data:"Hello everyone";
mso-footer-data:"Have a nice day";
mso-horizontal-page-align:center;
}
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>general_report</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
</x:Print>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml>
<![endif]-->
...... |
Regards
SS
|