Question

Write a Java program that will read in this XLS file and store them in an ArrayList or LinkedList or HashMap

Ask user to input what country they wish to search for and then output the country population.

Also ask user which other countries they wish to compare. then compare the two countries by outputting both country population

NOTE: THIS IS AN XLS FILE

F9 Population 1 Country 2 31056997 3581655 32930091 57794 71201 12127071 13477 69108 39921833 2976372 71891 20264082 8192880 7961619 303770 698585 3 Afghanistan 4 Albania 5 Algeria 6 American Samoa 7 Andorra 8 Angola 9 Anguilla 10 Antigua & Barbuda 11 Argentina 12 Armenia 13 Aruba 14 Australia 15 Austria 16 Azerbaijan 17 Bahamas, The 18 Bahrain 19 Bangladesh 20 Barbados 21 Belarus 22 Belgium 23 Belize 24 Benin 147365352 279912 10293011 10379067 287730 7862944 65773 2279723 8989046 4498976 1639833 188078227 23098 379444 7385367 13902972 47382633 25 Bermuda 26 Bhutan 27 Bolivia 28 Bosnia & Herzegovina 29 Botswana 30 Brazil 31 British Virgin Is 32 Brunei 33 Bulgaria 34 Burkina Faso 35 Burma 36 Burundi 37 Cambodia 38 Cameroon 39 Canada 13881427 17340702 33098932

Answer 1

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.sql.Date;

import java.util.HashMap;

import java.util.Iterator;

import java.util.Map;

import java.util.Set;

import java.util.Scanner;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

importorg.apache.poi.xssf.usermodel.XSSFSheet;

public class XLSReader {

public static void main(String[] args) {

                   int arr[][]= new int[100][2];

                   int i=0,j;

                  

try {

File excel = new File("C://user/Country.xls");

FileInputStream fis = new FileInputStream(excel);

XSSFWorkbook book =new XSSFWorkbook(fis);

XSSFSheet sheet = book.getSheetAt(0);

Iterator<Row> itr = sheet.iterator();

// Iterating over Excel file in Java

while (itr.hasNext()) {

Row row = itr.next();

Iterator<Cell> cellIterator = row.cellIterator();

while (cellIterator.hasNext()) {

  Cell cell = cellIterator.next();

switch (cell.getCellType()) {

     case Cell.CELL_TYPE_STRING:              a[i][1]=cell.getStringCellValue();

break;

   case Cell.CELL_TYPE_NUMERIC:

          a[i][2]=cell.getNumericCellValue();

          break;

}

i++;

                 }

       }

book.close();

Scanner scan = new Scanner(System.in);

System.out.print(“Enter the name of the country”);

          String s=scan.nextLine();

for(j=0;j<i;j++)

if(s.compareTo(a[i][1]==0)

System.out.println(“ Population is” + a[i][2]);

  }

  }
}