Excel Automation

I have used VS2022 to create a dialog based mfc app in VC++. I will provide you that “roughed in” project.
Your task is to modify the project so as to create a simple task of:

• Opening excel
• Opening a workbook
• Reading a column of 3 numbers
• Create a new worksheet
• Write the data read in to the new sheet
• Close the workbook
• Exit excel

I have indicated where in the ExcelAutomationDlg.cpp file:


// TODO: Add extra initialization here

// 0 - open excel

// 1 - open up c:\temp\AutoTestIn.xlsx

// 2 - read in the data in three rows of data - Sheet1- d4:d6 (x)

// 3 - add a worksheet name "new"

// 4 - in new write 3 rows 2 columns in f2:g6

// 5 - save workbook as c:\AutoTestOut.xlsx

// 6 - exit excel

return TRUE; // return TRUE unless you set the focus to a control


I will provide a zip file with the project and the initial excel worksheet needed.