aspose file tools*
The moose likes Java in General and the fly likes Is it possible to convert excel to csv format without loosing the excel format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Is it possible to convert excel to csv format without loosing the excel format" Watch "Is it possible to convert excel to csv format without loosing the excel format" New topic
Author

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

anvi kon
Ranch Hand

Joined: Jan 08, 2010
Posts: 133
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
Bartender

Joined: Oct 14, 2005
Posts: 18904
    
    8

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

Joined: Oct 02, 2003
Posts: 11479
    
  16

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?

There are only two hard things in computer science: cache invalidation, naming things, and off-by-one errors
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Is it possible to convert excel to csv format without loosing the excel format