M
Macca
hi,
I have been using Automation with MFC to write data to an excel spread
sheet. Part of code is shown below :-
// Start Excel and get Application object.
if(!m_objApp.CreateDispatch("Excel.Application"))
{
AfxMessageBox("Couldn't start Excel and get Application object.");
//return;
}
//Get a new workbook.
m_objBooks = m_objApp.GetWorkbooks();
//book = objBooks.Add (COleVariant((short)-4167));
m_objBook = m_objBooks.Add (covOptional);
//Get the first sheet.
m_objSheets = m_objBook.GetSheets();
I have been using Automation with MFC to write data to an excel spread
sheet. Part of code is shown below :-
// Start Excel and get Application object.
if(!m_objApp.CreateDispatch("Excel.Application"))
{
AfxMessageBox("Couldn't start Excel and get Application object.");
//return;
}
//Get a new workbook.
m_objBooks = m_objApp.GetWorkbooks();
//book = objBooks.Add (COleVariant((short)-4167));
m_objBook = m_objBooks.Add (covOptional);
//Get the first sheet.
m_objSheets = m_objBook.GetSheets();