What's the equivalent way of "Cells" method for the C++(ATL)

[David K. Kim]

As in VB's

MyWorksheet.Cells(2,3) = "Hello1"

If I wanna do this in VC++,
What's the equivalent way(using ATL).

More specifically,
I've downloaded the following code from a Web source.

.............
CoInitialize(NULL);

Excel::_ApplicationPtr excel;
HRESULT hr = excel.CreateInstance(L"Excel.Application");

Excel::_WorkbookPtr workbook =
excel->Workbooks->Add(static_cast<long>(Excel::xlWorksheet));
Excel::_WorksheetPtr worksheet = excel->ActiveSheet;

worksheet->Range["A1"]->Value = "Hello1"; // Set a value

workbook->Close();
excel->Quit();
CoUninitialize();
........

In this source code,
How can I change this
worksheet->Range["A1"]->Value = "Hello1";
to the following way
worksheet->Cells ?

Thanks, In advance.

 

[Bill Manville]

In this source code,
How can I change this
worksheet->Range["A1"]->Value = "Hello1";
to the following way
worksheet->Cells ?

Thanks, In advance.

I guess nobody in this Excel newsgroup speaks C++ (including me).
But it would seem reasonable, by analogy, that

worksheet->Cells[2,3]->Value = "Hello1";

might work.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup