Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ Library : Other (not classified elsewhere) » Excel to CVS convertion
Excel to CVS convertion [message #8081] Tue, 06 February 2007 16:03 Go to next message
jibe is currently offline  jibe
Messages: 294
Registered: February 2007
Location: France
Experienced Member
Hi,

I just discover Ultimate++ and I worry if there is some library class or function to read Excel files (xls) in an array or them convert to CSV format ?

The xls files I'll have to read are very simple and mostly text-oriented.

Thansk.

[Updated on: Tue, 06 February 2007 17:39]

Report message to a moderator

Re: Excel to CVS convertion [message #8090 is a reply to message #8081] Tue, 06 February 2007 23:24 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
No. But would you write one, let us know Smile

Mirek
Re: Excel to CVS convertion [message #8094 is a reply to message #8081] Wed, 07 February 2007 02:40 Go to previous messageGo to next message
mr_ped is currently offline  mr_ped
Messages: 825
Registered: November 2005
Location: Czech Republic - Praha
Experienced Contributor
IMHO you can use some MS OLE/COM/Whatever_they_use_now interface to access Excel's functionality and use excel itself for the conversion.

a) you need Excel (windows only)
b) .NET will be probably much better platform to get into such things.
c) I don't follow MS technologies, so I can't help more.

Another longshot may be to try use command line and Open Office calc to convert the files. While I do use Open Office almost daily, I don't know if you can run such conversion from command line or by some other means, sorry.
Re: Excel to CVS convertion [message #8095 is a reply to message #8094] Wed, 07 February 2007 07:44 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
mr_ped wrote on Tue, 06 February 2007 20:40


Another longshot may be to try use command line and Open Office calc to convert the files. While I do use Open Office almost daily, I don't know if you can run such conversion from command line or by some other means, sorry.


d) Look into openoffice sources.... (but beware of licence).

Mirek
Re: Excel to CVS convertion [message #8120 is a reply to message #8095] Sun, 11 February 2007 07:59 Go to previous messageGo to next message
Ulti is currently offline  Ulti
Messages: 108
Registered: September 2006
Experienced Member
this one will help,based on STL

http://www.codeproject.com/useritems/BasicExcel.asp
Re: Excel to CVS convertion [message #8304 is a reply to message #8081] Thu, 01 March 2007 18:09 Go to previous message
jibe is currently offline  jibe
Messages: 294
Registered: February 2007
Location: France
Experienced Member
Hi,

Thanks to everybody Smile

Finally, I used ssconvert, that comes with gnumeric. It's an easy solution, and works well.

Previous Topic: How to compile a upp program in MS Visual Studio?
Next Topic: Problem with key mapping using key_header & key_source
Goto Forum:
  


Current Time: Fri Apr 26 05:02:00 CEST 2024

Total time taken to generate the page: 0.02561 seconds