Question

7.2 Write a Java program called to create an Excel spreadsheet

1. Create a class called Food to represent a Lunch food item. Fields include name, calories, carbs
2. In a main method (of a different class), ask the user "How many things are you going to eat for lunch?".
3. Loop through each food item and prompt the user to enter the name, calories, and grams of carbs for that food item. Create a Food object with this data, and store each Food object in an ArrayList
4. Create a method called printLunch(), that will take an ArrayList of Food objects as an argument and create an Excel spreadsheet. This method should loop through the ArrayList and write the data to a file called lunch.csv (CSV stands for Coma Separated Values)
5. The data should be printed in this format below. Be sure to include a header as the first line of code written the the file, and a total row at the end. You will see that every row will be a new row in the Excel spreadsheet, and every coma will create a new column.
6. After collecting all the food data in your main method, pass the ArrayList to the printLunch () method.  

Hint: To append to a file, check out https://www.youtube.com/watch?v=mkqbbkBqOaU

Example lunch.csv file (You should be able to open this file in Excel, but in Notepad it will look just like this)

Name, Calories, Carbs
Pizza, 1800, 46.3
Salad, 355, 6.4
Soda, 200, 12.1
Total, 2355, 64.8

Answer 1

Note: Could you plz go through this code and let me know if u need any changes in this.Thank You
_________________

// Food.java

public class Food {
   private String name;
   private int calories;
   private double carbs;

   public Food(String name, int calories, double carbs) {
       this.name = name;
       this.calories = calories;
       this.carbs = carbs;
   }

   public String getName() {
       return name;
   }

   public void setName(String name) {
       this.name = name;
   }

   public double getCalories() {
       return calories;
   }

   public void setCalories(int calories) {
       this.calories = calories;
   }

   public double getCarbs() {
       return carbs;
   }

   public void setCarbs(double carbs) {
       this.carbs = carbs;
   }

   @Override
   public String toString() {
       return name + ", " + calories + ", " + carbs;
   }

}
_____________________

// Test.java

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Scanner;

public class Test {

   public static void main(String[] args) {
       String name;
       int calories;
       double carbs;
      
       /*
       * Creating an Scanner class object which is used to get the inputs
       * entered by the user
       */
       Scanner sc = new Scanner(System.in);
       ArrayList<Food> arl=new ArrayList<Food>();
      
       System.out.print("How many things are you going to eat for lunch?");
       int size=sc.nextInt();
      
       for(int i=0;i<size;i++)
       {
           System.out.print("\nEnter Food name :");
           name=sc.next();
           System.out.print("Enter Calories :");
           calories=sc.nextInt();
           System.out.print("Enter Carbs :");
           carbs=sc.nextDouble();
           Food f=new Food(name, calories, carbs);
           arl.add(f);
       }
      
       printLunch(arl);
      

   }

   private static void printLunch(ArrayList<Food> arl) {
       int totCal=0;
       double totCarbs=0;
       try {
           FileWriter sc1=new FileWriter(new File("lunch.csv"));
           sc1.write("Name, Calories, Carbs"+"\n");
           for(int i=0;i<arl.size();i++)
           {
               sc1.write(arl.get(i)+"\n");
               totCal+=arl.get(i).getCalories();
               totCarbs+=arl.get(i).getCarbs();
           }
           sc1.write("total, "+totCal+", "+totCarbs+"\n");
           sc1.close();
       }catch (IOException e) {
           System.out.println(e);
       }
      
      
      
   }

}
________________________

Output:

How many things are you going to eat for lunch?3

Enter Food name :Pizza
Enter Calories :1800
Enter Carbs :46.3

Enter Food name :Salad
Enter Calories :355
Enter Carbs :6.4

Enter Food name :Soda
Enter Calories :200
Enter Carbs :12.1

______________________

// lunch.csv

Name, Calories, Carbs
Pizza, 1800, 46.3
Salad, 355, 6.4
Soda, 200, 12.1
total, 2355, 64.8

_______________Could you plz rate me well.Thank You