• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Problem in downloading the .xlsm file from action class  RSS feed

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

My requirement is to write the data into .xlsm file which is in server and download it to the local system by using struts 1.1

I am able to write the data into excel file successfully. I have used Apache POI jars for this.

While downloading the file only facing the issue like "Excel can not open the file filename.xlsm because the file format or extension is not valid"

Below is my code in action class



Please help me to find out anything is wrong in the above code.

Thanks,
Pavani
 
Saloon Keeper
Posts: 4734
52
Eclipse IDE Firefox Browser Java MySQL Database VI Editor Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From Apache POI documentation:
Macros can not be created. The are currently no plans to support macros. However, reading and re-writing files containing macros will safely preserve the macros.

Don't know if that's your problem or not, you haven't given us much to go on.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!