473,385 Members | 1,317 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,385 software developers and data experts.

Access to excel spread sheets

Hello,

can anyone tell what is the best way to access to a excel spread sheet from
c++?
I would be interested in read it and write it.

Thank you in advance
Jordi
Feb 2 '06 #1
8 1977
Jordi wrote:
Hello,

can anyone tell what is the best way to access to a excel spread sheet from
c++?
I would be interested in read it and write it.

Good luck!

Excel is a closed format.

--
Ian Collins.
Feb 2 '06 #2
Tom
On Thu, 2 Feb 2006 08:24:27 +0100, "Jordi" <jl***@terra.es> wrote:
Hello,

can anyone tell what is the best way to access to a excel spread sheet from
c++?
I would be interested in read it and write it.

Thank you in advance
Jordi

There is an extensive Visual Basic interface into Excel and several
books available on the topic. I'd start there and if you are dedicated
to C++ ... use the examples in the Visual Basic/Excel books as a
starting point.

Feb 2 '06 #3
Ian Collins wrote:

Excel is a closed format.


OpenOffice can handle Excel spreadsheets can't it?

--
Ben Radford
"Why is it drug addicts and computer aficionados are both called users?"
Feb 2 '06 #4

Jordi wrote:
Hello,

can anyone tell what is the best way to access to a excel spread sheet from
c++?
I would be interested in read it and write it.


First, ask you question in an appropriate newsgroup. This group is not
OS specific and so questions of an OS specific nature are not topical
and besides...nobody necessarily knows.

As I recall, MS opens office files as databases so go look at the
database functionality.

Feb 2 '06 #5
Jordi wrote:
Hello,

can anyone tell what is the best way to access to a excel spread
sheet from c++?
I would be interested in read it and write it.


For all your file format questions, try wotsit first:

http://www.wotsit.org/search.asp?page=2&s=database

Brian
--
Please quote enough of the previous message for context. To do so from
Google, click "show options" and use the Reply shown in the expanded
header.
Feb 2 '06 #6
Ben Radford wrote:
Ian Collins wrote:

Excel is a closed format.


OpenOffice can handle Excel spreadsheets can't it?

Yes, but it ain't C++!

I suppose you could answer the OP by saying 'import into OO and save in
OO's native format, then open the OO XML files with C++'

--
Ian Collins.
Feb 2 '06 #7

Ian Collins wrote:
Ben Radford wrote:
Ian Collins wrote:

Excel is a closed format.


OpenOffice can handle Excel spreadsheets can't it?

Yes, but it ain't C++!

I suppose you could answer the OP by saying 'import into OO and save in
OO's native format, then open the OO XML files with C++'


Obviously he can answer as he wants to....besides, XML isn't C++ either.

Feb 2 '06 #8
ro**********@gmail.com wrote:
Ian Collins wrote:
Ben Radford wrote:
Ian Collins wrote:
Excel is a closed format.
OpenOffice can handle Excel spreadsheets can't it?


Yes, but it ain't C++!

I suppose you could answer the OP by saying 'import into OO and save in
OO's native format, then open the OO XML files with C++'

Obviously he can answer as he wants to....besides, XML isn't C++ either.

I didn't say it was, but it's a relatively trivial task in C++ to work
with a plain text file than a closed binary one.

--
Ian Collins.
Feb 2 '06 #9

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

Similar topics

0
by: peterforsberg | last post by:
Hello all, If you look at the portion of the code ... public TestClass(ref FarPoint.Win.Spread.FpSpread fpSpread1, int MySheet, int MyCol, int MyRow) ... I'm passing a reference to a...
6
by: gumbystation | last post by:
I am looking to take data from an excel spreadsheet into a csharp application to manipulate the data in various ways. Currently, I am using VS2005 (self-taught C#) and Excel 2000. I have...
1
by: casbi01 | last post by:
We have just converted a lot of our Excel spread sheets into Access. In Excel I can format a cell and use word rap. Is there a way to do this in Access? How can I format a cell to use more...
3
by: Falcon | last post by:
I'm displaying an Excel spreadsheet using a data gird control in a winform using oleDB objects and so far Data is displaying correctly. I'm having difficulties getting cell style information for...
0
by: Vader | last post by:
I am new to this forum. Thanks in advance for and help. The following is what I am looking for: 1. I need help with VB code to open a MS Word (.doc) file. 2. Read lines from the MS Word (.doc)...
0
by: DrewYK | last post by:
I have the project that may never end in front of me. I am creating a routine that will take SpreadSheets from Excel and bring them into Access. I am not using any "DoCmd"s because the goal...
1
by: afr0ninja | last post by:
Hello! I'm having an issue with the OutputTo function of Access. I have a few queries that I export to excel (by way of the OutputTo function) This works fine. I then take an excel sheet...
0
by: beebelbrox | last post by:
Greetings all. Once more I must dip into the font of your collective wisdom and request help: I have been given the task of taking an exsisting Access Query and exporting it to excel. There...
1
by: nckinfutz | last post by:
hello, I am having a problem with an access database. this is not my database and I did not create it, nor am I very good at access. however, I am a network engineer and that is why this problem...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.