How to dynamically set the gridline on when exporting to a excel file?
Posted on 2003-02-25
I have dynamically generated an excel- formated document using jsp. Basically it is a dynamically generated html table and I set the border="0". However, when I click-open the excel file, the gridline is missing. I tried to set the preference to have the gridline on but still, when the file is opened, gridline is not there. Is it possible I could add a line of code in my jsp program so that when it is opened in Excel, the gridline will be on?
Can I also set the font?
Thanks a lot,