473,322 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

c++ spreadsheet libraries?

Does anyone know of any c++ libraries that can load some spreadsheet
from a file and manipulate it?

I'm making a simple address book so I can learn applications design and
I'm trying to store user data such as addresses and phone numbers etc.

Dec 18 '05 #1
6 6039
There are under UNI*X, but M$Win.... no, I don't think so.

twoeyedhuman1111 wrote:
Does anyone know of any c++ libraries that can load some spreadsheet
from a file and manipulate it?

I'm making a simple address book so I can learn applications design and
I'm trying to store user data such as addresses and phone numbers etc.


Dec 18 '05 #2
twoeyedhuman1111 wrote:

I'm making a simple address book so I can learn applications design and
I'm trying to store user data such as addresses and phone numbers etc.


Try sqlite, I think it will be good solution for your problem:
http://www.sqlite.org

Cheers
--
Mateusz £oskot
http://mateusz.loskot.net

Dec 18 '05 #3
twoeyedhuman1111 wrote:
Does anyone know of any c++ libraries that can load some spreadsheet
from a file and manipulate it?

I'm making a simple address book so I can learn applications design and
I'm trying to store user data such as addresses and phone numbers etc.

You can use a CSV file to store your data, and with Excel or OpenOffice
Calc you can use it.

Regards,

Stephane
Dec 18 '05 #4
"twoeyedhuman1111" <tw**************@gmail.com> wrote:
Does anyone know of any c++ libraries that can load some spreadsheet
from a file and manipulate it?
I'm making a simple address book so I can learn applications design and
I'm trying to store user data such as addresses and phone numbers etc.


Using such libraries won't teach you application design.
Why not design your program using just C++ and the STL?
Create your own file format and save the data in that.
If you want GUI, get MS-VC++, read Petzold's "Programming
Windows", and learn Win32API. Then you'll have forced
yourself to design an app, pretty much from the ground
up. Finding some library that does most of the work
may speed design time, but will hardly serve to "teach
you to design apps".

Hint: there's something in the C++ STL called "multimap".
I think you'll find it very useful for phonebook design.

--
Robbie Hatley
Tustin, CA, USA
email: lonewolfintj at pacbell dot net
web: home dot pacbell dot net slant earnur slant
Dec 18 '05 #5
"twoeyedhuman1111" <tw**************@gmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Does anyone know of any c++ libraries that can load some spreadsheet
from a file and manipulate it?

I'm making a simple address book so I can learn applications design and
I'm trying to store user data such as addresses and phone numbers etc.


A simple array of structures would do this for you.

struct sAddress
{
std::string Name;
std::string Address1;
std::string Address2;
std::string City;
std::string State;
std::string Zipcode;
std::string Phone;
};

std::vector<sAddress> PhoneBook;

Read up on vectors. Read up on structures. Basically you can now build an
address object and populate it with information. Then "push" it onto the
vector.

Then read up on file IO to read from/write to a file.

This is what you need to learn, basic file IO, not using some library that
you're not going to learn a thing from.
Dec 18 '05 #6
twoeyedhuman1111 wrote:
Does anyone know of any c++ libraries that can load some spreadsheet
from a file and manipulate it?

I'm making a simple address book so I can learn applications design and
I'm trying to store user data such as addresses and phone numbers etc.


I agree with the other replies, that if you're learning to write Windows
applications then read Petzold, although I personally think 'Win32 Programming'
by Rector and Newcomer is far superior.

But basically forget the idea of reading spreadsheet data like out of a binary
..xls file - thats a deep exercise in file IO and binary file formats that
although its _really_ interesting doesn't sound like its what you want to achieve.

If you're trying to write a small app that reads XLS files directly (for
example) then look into COM programming. Of course, there is an argument that
for this problem domain you're better off with other technologies, like VB, C#,
or I know wxPython would do a good job of an address book that can interface to
Excel files (if you have Excel installed, naturally).

HTH
Dec 18 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Wayne Wood | last post by:
i am now working on a financial calculating application, in which there are so many number cells to calculate. the relation between them are very like the formula in MS Excel, we need all result...
1
by: Vlad | last post by:
I am trying to decide whether I should buy Visual Basic.NET Standard. I’d like to know the answer to the following questions to help me decide 1. Can I use Visual Basic.NET Standard to create a...
3
by: Brooke | last post by:
I am new to ASP.NET, but have been programming for about 14 years (C# about 2 years). My manager asked me to develop a web application that would allow employees to view a spreadsheet that is used...
3
by: GH | last post by:
Does anyone know how I can access (using OleDbConnection, I presume) a spreadsheet embedded in a cell of another spreadsheet (with vb.net)? Thanks, GH
0
by: mix01 | last post by:
Hi, I am trying to get some VBA code working, but am preplex as to why it does not work. I would really appreciate any level of help. Many thanks, Mix01 Version of the program
1
by: platski | last post by:
I have learned a bit about vb recently and have been using it for my job, I still have questions and dont know how to do many things yet. I appreciate your time and efforts and hopefully I can...
8
by: Perl Beginner | last post by:
I am using Win32. I have created an excel spreadsheet, formatted the columns and rows, and would like to write to the cells…all of this using Spreadsheet::WriteExcel. My issue is, my script is very...
2
by: S_K | last post by:
Hi, I have a need to read data from an Excel spreadsheet using ASP.NET (C# ). The data is then displayed in various locations on the web site. This should be very simple and I have been...
0
by: dutsnekcirf | last post by:
Okay, I think this one is a really hard one for yous geniuses out there. I'm going to try my best to explain in as much detail as I can. And for the most part I just want to know if I'm doing this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.