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.
Instagram Marketing for Professionals Category: Content Writing, Facebook Marketing, Internet Marketing, Marketing, Social Media Marketing Budget: $30 - $250 USD