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.