The missing pieces of information are
1) HOW are you creating your file for Excel to open:
2) WHAT style template are you currently using? (Do you have STYLE= in your ODS invocation or not? If yes, what is the STYLE= template that you are using?)
sorry..not sure I was clear.The report table itself had grid lines. But what I would like to have is to show all the grid lines in the excel sheet. When I open an excel file which is created with the ODS, the sheet's option of gridline is not checked. Is there way I can make it to show gridlines when the excel report get created by ODS.
Ah, got it. What you want to do is some piece of Page Setup that is available from an Excel pulldown menu. Remember that you are creating an HTML file and Excel just knows how to open that HTML file. There's no way in HTML tags to touch the internal Excel Page Setup option.
However, it is possible using either the MSOFFICE2K tagset or the ExcelXP tagset to gain better control over options and settings inside Excel. MSOFFICE2K generates Microsoft specific HTML and ExcelXP creates Spreadsheet Markup Language XML. Since you only have Excel 2000, you would have to use the MSOFFICE2K tagset to create your file.
Again, you probably should talk to Tech Support, because I believe you would need to insert the appropriate XML for gridlines into a custom MSOFFICE2K tagset.