CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 RESOLVED: Export to Excel issue with grid lines

 Print topic Send topic

Author Message
ckroon

Posts: 869
Posted: 07/08/2009, 11:34 PM
So.. I got the Export to Excel working using the code in the example pack.
Only problem is that when it exports to excel, there are no Grid lines. This will freak my client out and I don't want them to have to go to Tools->Options->View Grid Lines every time they export.

Is there a way to have the grid lines visible when it exports the page?

Thanks!

_________________
Walter Kempees...you are dearly missed.
View profile  Send private message
rho


Posts: 85
Posted: 07/08/2009, 11:49 PM
A quick Google gives a possible solution by changing the html: http://groups.google.com/group/microsoft.public.excel/b...2574a55b464f050.

Haven't tested it though....

Rob.
View profile  Send private message
ckroon

Posts: 869
Posted: 07/10/2009, 11:55 AM
Thanks Rob! Worked like a charm

:-D

For everyones use: paste this into the Head section of the Html page

Quote :
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <meta http-equiv=Content-Type content="text/html; charset=windows-1252"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 11"> <style> <!--table @page{} --> </style> <!--[if gte mso 9]><xml> <x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet> <x:Name>Sheet1</x:Name> <x:WorksheetOptions><x:Panes> </x:Panes></x:WorksheetOptions> </x:ExcelWorksheet></x:ExcelWorksheets></ x:ExcelWorkbook> </xml> <![endif]-->

Notice you can control the name of the sheet (Sheet1).

Enjoy!

_________________
Walter Kempees...you are dearly missed.
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.