Write a c++ program to read file and complete the 7 given tasks i should read excel sheet plz i need a proper code
Following are the steps to do this challenging task. 1. Read the excel file that is attached below. Recommendation of reading the file in the form of comma-separated format otherwise you can use any format for reading the file). 2. Create one function that reads each index of the excel file by using the while or for loop. The loop reads all the text of the file until it reached the end of the file. There are three recommended methods to store each reading index of the file that is: a. Variables b. Single arrays c. Multidimensional arrays 3. Create a second function that generates the text file after successfully reading each index of the excel sheet. The text file must be in formatted form. Examples are given below. 4. Create a third function that calculates the total percentages of Quizzes, Assignments, and mid-term and final-term marks. The percentages are given below: a. Quizzes =10% b. Assignments =10% c. Midterm =30% d. Final term =50% In the end, it also computes the overall percentage of the result which is 100%. The recommendation is to store these percentages in arrays, variables, or multidimensional arrays. 5. Create a fourth function that computes average marks of midterm, and final term and an overall average of total marks that includes all quizzes, assignments, midterm, and final term marks. 6. Create a fifth function that adds percentages and Averages columns in the given below excel sheet by using the third and fourth functions. After successfully adding the percentages and Averages columns in the given below excel sheet you can generate a complete CSV file that displays all the Results of your course including percentages and averages in it. 7. Finally Create a sixth Function that generates the histogram by using the overall result that you are adding to the excel sheet. The histogram will show the ranges in percentages