Excel Application Help Please

[BuilderSpec]

Hi

Am trying to use the TExcelApplication suite to access an exsiting Excel spreadsheet. Quite simply i just want to read the data out of it one cell at a time. Here is my code so far...

...

if ( OpenDialog1->Execute() )
{
ExcelWorkbook *wb;
AnsiString FN = OpenDialog1->FileName;

ExcelApplication1->Connect();

ExcelApplication1->Workbooks->Open(WideString(FN));

}

I can open my sheet fine , how do I get the contents of cell A1 into a string ?

Can anyone show me the code how to get to the contents of cell A1 in C++ Builder.. i have seen the equiv in Delphi and cannot seem to convert it successfully.





Hope this helps!

Regards

BuilderSpec