• 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:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

Problem in Export to Excel using Jexcel api  RSS feed

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

Iam implementing Export to Excel functionality using Jexcel api in my dynpage coding.

Say I have given excel sheet name as MySampleExcel.xls in the coding.

1. I click on Export to Excel button - > open, an excel sheet is opened with the values exported to it from the backend.
2. If you see the excel sheet name in the top left corner, it is displaying as MySampleExcel(1). Next time, when you open , it is displaying MySampleExcel[2]. If you try to do "Save As" under File menu, it is saving with the numbers at the end of filename which is something like:

MySampleExcel[2]
MySampleExcel[3]
MySampleExcel(1)

It is randomly generating these numbers.

What could be the problem? Please suggest.

Regards,
Padmalatha.K
 
Rancher
Posts: 42974
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My guess would be that the browser sees that a file called MySampleExcel.xls already exists, so it gives it a new, distinctive name in order to avoid overwriting the existing one.
 
Padmalatha Kontham
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

We tried to clear the cache but no luck.
Could you please suggest some other options?

Regards,
Padmalatha.K
 
Padmalatha Kontham
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

The issue is happening with the IE Browser. we have no issue when we click on " export excel " > " save".

we find the issue ( observation ) only when we click on " export excel " > "open".

filename(n).xls gets opened.

can we make it as filename.xls?.

Please Suggest.

Thanks in Advance.

Regards,
Padmalatha.K
 
Ranch Hand
Posts: 211
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
permaculture is giving a gift to your future self. After reading this tiny ad:
ScroogeXHTML - small and flexible RTF to HTML converter library
https://coderanch.com/t/710903/ScroogeXHTML-RTF-HTML-XHTML-converter
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!