New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Development and Darwin Discussion and questions about development for Mac OS X.

excel data import on Mac OS X


Post Reply New Thread Subscribe

 
Thread Tools
dtkachov

 
Member Since: Nov 06, 2007
Posts: 4
dtkachov is on a distinguished road

dtkachov is offline
I am looking for a way to import data from excel on Mac OS X.
Development platform - c++ (xcode).
Can anybody point me to the way how it may by done on Mac OS?
Any help is appreciated.

Best regards,
Denis
QUOTE Thanks
Del

 
Member Since: Dec 24, 2006
Location: N. Ireland
Posts: 901
Del has a spectacular aura about
Mac Specs: Mac Pro 2xQuad core 2.8GHZ

Del is offline
Is the excel data saved as CSV format?

I dont code in C++ myself but if it is, just read the data in line by line and use a string tokeniser (or C++ equivalent) to get at each individual value
QUOTE Thanks
dtkachov

 
Member Since: Nov 06, 2007
Posts: 4
dtkachov is on a distinguished road

dtkachov is offline
No, files are in native excel format, not CSV.
QUOTE Thanks
Del

 
Member Since: Dec 24, 2006
Location: N. Ireland
Posts: 901
Del has a spectacular aura about
Mac Specs: Mac Pro 2xQuad core 2.8GHZ

Del is offline
Quote:
Originally Posted by dtkachov View Post
No, files are in native excel format, not CSV.
Again not sure about C++ but in Java you can make a JDBC connection to an excel spreadsheet and treat it as if it was a database and therefore read the rows of data and manipulate them as you please.

I could be wrong but i think i read that xcode can be used for java development, and given that its syntax is very similar to C++ maybe you should consider adding Java to your list of skills?
QUOTE Thanks
dtkachov

 
Member Since: Nov 06, 2007
Posts: 4
dtkachov is on a distinguished road

dtkachov is offline
Thank you for reply.
I don't mind about learning Java or anything else but this must be a module in huge project. And it is necessary to write module that will import dfata from excel files. It will not be very good (from a lot of points) if one of modules in the projects will be build using other platform.
So, it is expected to be c++.
QUOTE Thanks
Del

 
Member Since: Dec 24, 2006
Location: N. Ireland
Posts: 901
Del has a spectacular aura about
Mac Specs: Mac Pro 2xQuad core 2.8GHZ

Del is offline
Well fire up google, im sure there is an equivalent way of reading data from an excel file using C++, its not an uncommon thing to want to do now is it.
QUOTE Thanks
Del

 
Member Since: Dec 24, 2006
Location: N. Ireland
Posts: 901
Del has a spectacular aura about
Mac Specs: Mac Pro 2xQuad core 2.8GHZ

Del is offline
http://www.codeproject.com/wtl/WTLExcel.asp

http://www.supershareware.com/info/e...iewer-ocx.html

etc
QUOTE Thanks
dtkachov

 
Member Since: Nov 06, 2007
Posts: 4
dtkachov is on a distinguished road

dtkachov is offline
Thank you, but this is actually samples for windows. That is not a problem to do it under windows (I did it actually).
A question was about Mac OS.
Obviously, before posting these questions I have googgled around. Founding nothing I have posted message here.

Any ideas about how excel file might be read programatically under Mac OS ?
QUOTE Thanks
danielb
Guest
 
Posts: n/a

Here is a link to some c code that converts excel to html. You may be able to modify it to complete the task.

http://chicago.sourceforge.net/xlhtml/
QUOTE Thanks
scanchan

 
Member Since: Dec 11, 2007
Posts: 6
scanchan is an unknown at this point

scanchan is offline
Save Excel data to CSV Fomate?
QUOTE Thanks

Post Reply New Thread Subscribe


« Xcode help please =( | Question for the Coders out there »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Toast Titanium error..better burner available for Mac??? coolmel OS X - Apps and Games 7 02-27-2008 09:10 AM
Has The Mac Been Hacked...... MaDDoG Apple Rumors and Reports 5 05-01-2007 07:06 PM
Issues w/ printing in Microsoft Excel for MAC! AAAAARGH MacNewbie OS X - Apps and Games 1 02-01-2007 02:51 AM
How to best handle data with Parallels markw10 Running Windows (or anything else) on your Mac 3 11-13-2006 01:29 PM
Mac Users Get More ISP Choices schweb Apple Rumors and Reports 1 03-06-2003 10:57 AM

All times are GMT -4. The time now is 05:17 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?