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.
