import data from excel

[Denis Tkachov]

Hi,

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

 

[Bob Greenblatt]

Hi,

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

If you are looking for documentation describing the Excel file format, I
can¹t help. However, why not just save the Excel file in delimited text
format?

 

[Denis Tkachov]

If you are looking for documentation describing the Excel file format, I

can¹t help. However, why not just save the Excel file in delimited text
format?

I think it is too long to implement excel file reader. I am rather
looking for ready to use solution: something like odbc driver on Mac
or some 3rd party library.
Saving Excel file to delimited text format not appropriate for the
project. Users of the application should just provide a file and
application must process it.

 

[JE McGimpsey]

If you are looking for documentation describing the Excel file format, I
can?t help. However, why not just save the Excel file in delimited text
format?

I think it is too long to implement excel file reader. I am rather
looking for ready to use solution: something like odbc driver on Mac
or some 3rd party library.
Saving Excel file to delimited text format not appropriate for the
project. Users of the application should just provide a file and
application must process it.[/QUOTE]

This may help:

http://www.agentjim.com/MVP/Excel/RelationalOffice.htm

and

http://www.actualtechnologies.com/download.php

 

[Denis Tkachov]

This may help:

http://www.agentjim.com/MVP/Excel/RelationalOffice.htm
and
http://www.actualtechnologies.com/download.php

Thank you!
I know about their products. The only problem with this approach (odbc
driver) that it is necessary to purchase and install their license
with each copy of our product.

Any other ideas?

 

[Bob Greenblatt]

Thank you!
I know about their products. The only problem with this approach (odbc
driver) that it is necessary to purchase and install their license
with each copy of our product.

Any other ideas?

No, No more ideas unless you can describe what you are trying to do and why
the suggested approaches will not work.

 

[Denis Tkachov]

It will work.
But there is a need to purchase and install odbc driver with each copy
of our product in such case.

The question is whether there is another way (except odbc driver) to
read data from excel file under Mac OS.

What I am trying to do:
Our product will read data from a variety of source. One of sources
must be excel. That is why I am looking for a way to read data from
excel files.

 

[Bob Greenblatt]

It will work.
But there is a need to purchase and install odbc driver with each copy
of our product in such case.

The question is whether there is another way (except odbc driver) to
read data from excel file under Mac OS.

What I am trying to do:
Our product will read data from a variety of source. One of sources
must be excel. That is why I am looking for a way to read data from
excel files.

Then, I guess you will need to understand the file structure so you can
parse it and get the data you need. It may be pretty simple, or pretty
complex depending on how the data exists in the workbook. For example, is it
always on 1 work sheet, or several worksheets; a single workbook, or linked
workbooks? Is the structure identical, i.e. data always in the same cells?
Is the range size variable? Are the data ranges identifiable with defined
names? Is some of the data in defined names? Etc. etc.

One fairly straightforward way may be to construct an Excel workbook of your
own that can get at the data with formulas and links. Then script this
workbook with VBA (which won¹t work for Excel 2008), or apple script or XLM
to open the user¹s work books and extract the needed data. Your application
can keep this workbook hidden so the user will never see the data extraction
happening.

 

[Denis Tkachov]

Then, I guess you will need to understand the file structure so you can
parse it and get the data you need. It may be pretty simple, or pretty
complex depending on how the data exists in the workbook. For example, is it
always on 1 work sheet, or several worksheets; a single workbook, or linked
workbooks? Is the structure identical, i.e. data always in the same cells?
Is the range size variable? Are the data ranges identifiable with defined
names? Is some of the data in defined names? Etc. etc.

Data format in unknown. Actually it user depended. Application allow
user define column mapping to excel file datasheet/columns.

So I think implementing parser itself is too complex and I hope there
must be any exists solution.

 

[Jim Gordon MVP]

Hi Denis,

Write to AcutalTechnologies support and ask them to come up with some sort
of custom licensing arrangement. I think they would be pleased to discuss
this with you.

-Jim

Thank you!
I know about their products. The only problem with this approach (odbc
driver) that it is necessary to purchase and install their license
with each copy of our product.

Any other ideas?

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info