Final Group or Individual Project for CSC172: Simple File Processing

Final Project End Goal

 

First Step: Final Project Simple File Processing

1) Create a spreadsheet of your inventory item. The item can be anything you and your partner want to track. It should have at least 8 columns: The ID number, a name or description, and 6 attributes of that item. List one item per row, and have at least 10 rows. Save that spreadsheet as a comma separated file. Open the file in notepad to see what the file data looks like. Give both team members that file to use for testing.

2) Create one item class that has a variable for each item attribute (each column in the excel spreadsheet). It needs a tostring method and a setter method for each item attribute. .

3) Write one program that asks for all the values of the item and then writes the item to the file. It should then ask whether the user wants to enter another item. Use an object created by the item class instead of creating 8 variables for the item variables. This program should create a file that looks just like the one produced by Excel. (It will be helpful to add a getCommaSeparatedString to the item class.)

4) Write a program that prints every item with its description and the 6 attributes. (It will be helpful to add a constructor that takes in a comma separated string to the item class.)  The items need to be printed nicely with either labels for each field or a sentence that makes sense or with column headings.

Both group members should turn in the same program. Put both group member names at the top of the program. Be sure to include good comments on all files.