Excel genration with grid lines

kha_tsn 0 Tallied Votes 456 Views Share

This code is to generate excel with grid lines in it with file name as you given in the code which will disply when you opening throug the download dialog box,

Regards,
khaleel

<!---to open excel with given name--->
<cfheader name="Content-Disposition" value="attachment;filename=#lFilenameCreated#">
<cfcontent type="application/vnd.ms-excel">
<!---<cfcontent type="application/vnd.ms-excel" >
  <cfheader name="Content-Disposition" value="filename=SchoolReport.xls">--->
</cfoutput>
<html xmlns:o="urn:schemas-microsoft-com:office:excel" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> 
<head>
<TITLE>CTY Information System - School Report</TITLE>
<meta http-equiv="Content-Type" content="text/html;charset=windows-1252"> 
<!---To get gridlines in excel file--->
<xml > 
 <x:ExcelWorkbook > 
  <x:Name>School Report</x:Name>
  <x:ExcelWorksheets > 
    <x:ExcelWorksheet > 
    <x:Name>School Report</x:Name> 
     <x:WorksheetOptions> 
      <x:Panes> 
      </x:Panes> 
      <x:Print>         
       <x:Gridlines />     
      </x:Print> 
     </x:WorksheetOptions> 
   </x:ExcelWorksheet> 
  </x:ExcelWorksheets> 
 </x:ExcelWorkbook> 
</xml> 
<Write your code here>
ngabach 0 Newbie Poster

Has anyone used an mpeg4 v568? If so, after where on earth?
I haven't used the Samsung mpeg4 V568 but I went to this shop in Oxford Street that had the finishing piece. I checked out all its features and I found the player to be pretty impressive. It is equipped with a first-class touch...

http://09005-telefonsex.die-erotiksuche.com

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.