Java

Challenges

1. Sweet Tooth

Create a program containing a class called IceCream. Your IceCream class should have at least 10 data variables. When the program is ran, it should create 5 new IceCream objects and print a line for each one describing it in full detail. Only one System.out.println() method may be used. Here are some examples of IceCream data:

  • String flavor;
  • Boolean hasChocolateChips;
  • int numScoops;

2. Dog Simulator

Create a program containing a class called Dog. Dog should have the data shown below with the defaults shown.

  • String name = Fido;
  • String color = Brown;
  • int weight = 50;
  • String eyeColor = Brown;
  • String temperament = Nice;

The class should have these eight different constructors:

  • Default
  • Name only
  • Weight only
  • Color and Temperament
  • Name, Color, and Temperament
  • Weight, Eye Color, and Temperament
  • Name, Color, Weight, and Eye Color
  • Name, Color, Weight, Eye Color, and Temperament

When your program runs, it should create a new Dog object for each of these different constructors, and print out each Dog's information.

Read Excel Spreadsheet

add this classpathentry:

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\poi-4.1.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\poi-ooxml-4.1.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\poi-excelant-4.1.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\poi-ooxml-schemas-4.1.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\poi-scratchpad-4.1.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\ooxml-lib\curvesapi-1.06.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\ooxml-lib\xmlbeans-3.1.0.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\activation-1.1.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\commons-codec-1.13.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\commons-collections4-4.4.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\commons-compress-1.19.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\commons-logging-1.2.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\commons-math3-3.6.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\jaxb-api-2.3.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\jaxb-core-2.3.0.1.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\jaxb-impl-2.3.2.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\junit-4.12.jar"/>

<classpathentry kind="lib" path="S:\HS\Osowski, Z\Programming\Java libs\poi-bin-4.1.1-20191023\poi-4.1.1\lib\log4j-1.2.17.jar"/>


library documentation: https://howtodoinjava.com/library/readingwriting-excel-files-in-java-poi-tutorial/#reading_excel_file 

IMPORT:
import org.apache.poi.*

DEFINE: 
InputStream ExcelFileToRead = new FileInputStream("C:\\Test.xlsx");
XSSFWorkbook  wb = new XSSFWorkbook(ExcelFileToRead);

READ:
wb.getSheetAt(sheet).getRow(row).getCell(column);

WRITE:
wb.getSheetAt(sheet).getRow(row).getCell(column).setCellValue("hello");