This week's book giveaway is in the JavaScript forum.
We're giving away four copies of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js and have Paul Jensen on-line!
See this thread for details.
Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
anvi kon
Ranch Hand
Posts: 133
  • 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
Posts: 22374
42
Eclipse IDE Firefox Browser MySQL Database
  • 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
Posts: 12527
48
Chrome Java Linux
  • Likes 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?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!