<div>
Use instaled components or You must generate COM objects, and use they as explained below:<br />
<a href="http://www.vbforums.com/showthread.php?t=391665" rel="ugc">http://www.vbforums.com/showthread.php?t=391665</a>
</div>


Use instaled components or You must generate COM objects, and use they as explained below:
http://www.vbforums.com/showthread.php?t=391665 [http://www.vbforums.com/showthread.php?t=391665]

<div>
Where do I find &quot;Installed Components&quot; ?
</div>


<div>
Aside from COM, you could use ODBC to obtain data from Excel, see e.g. <a href="http://support.microsoft.com/kb/130137" rel="ugc nofollow">http://support.microsoft.com/kb/130137</a>&nbsp;(&quot;HOWTO: How to Use ODBC to Run SQL SELECT on Microsoft Excel Data&quot;) - you'll find some helpful classes for managing a SQL connection at <a href="http://www.codeguru.com/Cpp/data/mfc_database/article.php/c1173" rel="ugc">http://www.codeguru.com/Cpp/data/mfc_database/article.php/c1173</a>&nbsp;(&quot;Classes for direct SQL calls with ODBC&quot;)
</div>


Aside from COM, you could use ODBC to obtain data from Excel, see e.g. http://support.microsoft.com/kb/130137 [http://support.microsoft.com/kb/130137] ("HOWTO: How to Use ODBC to Run SQL SELECT on Microsoft Excel Data") - you'll find some helpful classes for managing a SQL connection at http://www.codeguru.com/Cpp/data/mfc_database/article.php/c1173 [http://www.codeguru.com/Cpp/data/mfc_database/article.php/c1173] ("Classes for direct SQL calls with ODBC")

<div>
<div class="content wysiwyg-content">
I have just installed Embarcadero XE2 C++ Builder Enterprise.<br />
How can I open an Excel spreadsheet and read data from a particular Cell and &nbsp;Worksheet?<br />
&nbsp;
</div>
</div>


I have just installed Embarcadero XE2 C++ Builder Enterprise.
How can I open an Excel spreadsheet and read data from a particular Cell and  Worksheet?
 

How to read data from an Excel spreadsheet Cell in XE2 C++ builder

C++ is an intermediate-level general-purpose programming language, not to be confused with C or C#. It was developed as a set of extensions to the C programming language to improve type-safety and add support for automatic resource management, object-orientation, generic programming, and exception handling, among other features.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.