File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is it possible to convert excel to csv format without loosing the excel format

 
anvi kon
Ranch Hand
Posts: 133
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I need to covert excel to csv without losing the excel format.

It should be exactly as original xls format without deleting the commas...

Thanks
 
Paul Clapham
Sheriff
Pie
Posts: 20191
26
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No.

When you convert your spreadsheet to CSV you're going to get lines of text line this:

ABC,37,today,-88.1329


As you can see there's nothing to say that the "37" was formatted as a number with 1 decimal place and displayed in Comic Sans 14-point font with a blue background.
 
fred rosenberger
lowercase baba
Bartender
Pie
Posts: 12022
25
Chrome Java Linux
  • 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
One of the primary points of having something in "excel format" is that it contains meta-data about how to format things. For example, it stores the font, color size, orientation, etc. of what is in the cells.

There is no real way to do this in a .csv file.

If you need all the formatting, why convert it away from what has what you need?
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic