• 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
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Jj Roberts
  • Carey Brown
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

Problem in Export to Excel using Jexcel api

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 43016
76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
 
Don't mess with me you fool! I'm cooking with gas! Here, read this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic