Anoop Prakash - 2007-05-03

Hi,

I am using Diaply tag displaytag 1.1 jar file for my J2EE application. I am using Tiles and Struts in my application. I am using Spring for the Database access modules.

The problem I am facing is as follows.When i am exporting the data in a diplay table as an excel, say I give a name(Name1.xls) also to the excel sheet using "export.excel.filename".
I am able to do the export successfully using this name,but when I open the document the work sheet name is as follows - ".xls]Name1(1)". Since when I try to rename the worksheet name I get the follwing excel error message :

<I>
While renaming a sheet or column,you entered an invlaid name.Try one of the following:

  • Make sure that the name you have entered has not exceeded 31 characters
  • Make sure that the name does not contain any of the following characters: : \/?*[ or ]
  • make sure that you did not leave the name blank
    </I>

The error is due to the special characters that is there in the worksheet name.Is there any workaround for this? Is this a know bug?

One more thing I noticed is that this happens only when I access the application through IE,bit it works fine when I access the application throught Forefox.

Any help will be much appreciated.

Thanks,
Anoop