export to excel no gridlines

[germanjulian]

ahh
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"test.xls\"");

html is outputted to test.xls and it works.
however there are no excel gridlines. you know the grey gridlines on every sheet!

how do i enable them by default cause I have to go to options every time.

I know

appXL.activesheet.PageSetup.PrintGridlines = True where appxl is created as
follows Set appXL = CreateObject("Excel.application")

sets it in VB but in php? or html?

[germanjulian]

anyone?

[vivin1]

I have been tru it a lot. The HTML outputs on an xcel spreadsheet but no grid lines. Iworked around the problem.....

optput ur html using table tags
use <table border=1>

hope it helps

Viv

[germanjulian]

thats cell formatting not the excel gridlines 🙂

dont think I will figure out how to do this. if only i could use .net :rolleyes:

[ahundiak]

Instead of using .net you might consider learning how to search a forum. There are many threads on generating excel spread sheets using php.