View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David K. Kim David K. Kim is offline
external usenet poster
 
Posts: 1
Default What's the equivalent way of "Cells" method for the C++(ATL)

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.