Reding excel file

guyss this is the code for reading and sending the mail

package com.abhi;

import java.io.BufferedReader;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.io.IOException;

import java.io.InputStreamReader;

import java.util.ArrayList;

import java.util.Collection;

import java.util.Collections;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import java.util.Properties;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class Main {

public static FileReader reader;

public static Properties properties = new Properties();

private static String password = "";

public static void main(String[] args)

{

String dataSourceType = "";

try {

reader = new FileReader("D:\\APNAKHATA\\CS\\Java\\Resource\\pro perties1.properties");

properties.load(reader);

dataSourceType = properties.getProperty("DataSource_Type");

int datasourceType = 0;

if(dataSourceType.equalsIgnoreCase("XLS")){

datasourceType = 1;

}

if(dataSourceType.equalsIgnoreCase("XML")){

datasourceType = 2;

}

if(dataSourceType.equalsIgnoreCase("ORACLE")){

datasourceType = 3;

}

if(dataSourceType.equalsIgnoreCase("MySQL")){

datasourceType = 4;

}

switch(datasourceType)

{

case 1: readFromXLS();

case 2: readFromXML();

case 3: readFromOracle();

case 4: readFromMySql();

}

}

catch (FileNotFoundException e) {

System.out.println("cannot find the file! exiting program!!");

System.exit(0);

} catch (IOException e) {

System.out.println("cannot read from the file! exiting program!!");

System.exit(0);

}

}

private static void readFromMySql() {

// TODO Auto-generated method stub

}

private static void readFromOracle() {

// TODO Auto-generated method stub

}

private static void readFromXML() {

// TODO Auto-generated method stub

}

private static void readFromXLS() {

String xls_file_path = "D:\\APNAKHATA\\CS\\Java\\Resource\\maildetail.xls ";

//xls_file_path = properties.getProperty("file_path");

try {

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(xls_file_path));

HSSFWorkbook wb = new HSSFWorkbook(fs);

HSSFSheet sheet = wb.getSheetAt(0);

HSSFRow row;

HSSFCell cell;

//System.out.println("file:"+xls_file_path);

int rows; // No of rows

rows = sheet.getPhysicalNumberOfRows();

System.out.println("No. of rows:"+rows);

HashMap namesMap =new HashMap<>();

HashMap socnamesmap=new HashMap<>();

HashMap monthMap =new HashMap<>();

HashMap currencyMap =new HashMap<>();

HashMap billamntMap =new HashMap<>();

HashMap duedateMap =new HashMap<>();

HashMap emailMap =new HashMap<>();

HashMap OutputMap =new HashMap<>();

int cols = 0; // No of columns

for(int r = 0; r <=rows; r++) {

row = sheet.getRow(r);

if(row != null) {

cols = sheet.getRow(r).getPhysicalNumberOfCells();

for(int c = 0; c < cols; c++) {

cell = row.getCell((short) c);

if(cell != null)

{

for (r = 0; r <=rows; r++)

{

if(cell.getCellType()== 1 || cell.getCellType()== 2)

{

if(c == 1)

namesMap.put(r, cell.getNumericCellValue());

if(c == 2)

socnamesmap.put(r, cell.getStringCellValue());

if(c == 3)

monthMap.put(r, cell.getStringCellValue());

if(c == 4)

currencyMap.put(r, cell.getStringCellValue());

if(c == 5)

billamntMap.put(r, cell.getStringCellValue());

if(c == 6)

duedateMap.put(r, cell.getNumericCellValue());

if(c == 7)

emailMap.put(r, cell.getNumericCellValue());

if(c == 8)

emailMap.put(r, cell.getStringCellValue());

}

if (cell.getCellType()==1 && c == 2 && c == 3 && c == 4 && c == 5 && c == 6 && c == 7 && c == 8)

{

OutputMap.put(r, cell.getNumericCellValue());

}

}

}

}

}

System.out.println("name:"+namesMap);

System.out.println("Society Name:"+socnamesmap);

System.out.println("Month:"+monthMap);

System.out.println("Currency:"+currencyMap);

System.out.println("Bill Amount:"+billamntMap);

System.out.println("Due Date:"+duedateMap);

System.out.println("Email-id:"+emailMap);

Collection OutputList = OutputMap.values();

List list = new ArrayList(OutputList);

// Collections.sort(list);

// Collections.reverse(list);

// System.out.println("ticketList:"+list);

Integer[] OutputArray = new Integer[list.size()];

for (int i = 0; i < list.size(); i++) {

OutputArray[i] = getKey(OutputMap, list.get(i));

}

// for (int i = 0; i < sortedArray.length; i++) {

// System.out.println(sortedArray[i]);

// }

//System.out.println("Sorted list:");

// for (int i = 0; i < sortedArray.length; i++) {

//System.out.println("Name:"+namesMap.get(sortedArra y[i]));

//System.out.println("No Of Tickets:"+ticketMap.get(sortedArray[i]));

//System.out.println("email:"+emailMap.get(sortedArr ay[i]));

//}

int totalNoOfMembers = OutputArray.length;

// if(OutputArray.length>10) totalNoOfValuedCustomers = 10;

// int i = OutputArray.length;

String password_text = properties.getProperty("password_text");

System.out.println(password_text);

BufferedReader bufferRead = new BufferedReader(new InputStreamReader(System.in));

password = bufferRead.readLine();

for (int i = 0; i < totalNoOfMembers; i++)

{

//SendMail.sendMailToMembers((String)emailMap.get(Ou tputArray[i]), (String)namesMap.get(OutputArray[i]),(String)socnamesmap.get(OutputArray[i]), (String)monthMap.get(OutputArray[i]) , (String)currencyMap.get(OutputArray[i]) ,(double)billamntMap.get(OutputArray[i]), (double)duedateMap.get(OutputArray[i]) ,password);

}

}

//}

// }

}

catch(Exception ioe) {

ioe.printStackTrace();

}

}

static Integer getKey(HashMap<Integer, String> map, Object value) {

Integer key = null;

for(Map.Entry<Integer, String> entry : map.entrySet()) {

if((value == null && entry.getValue() == null) || (value != null && value.equals(entry.getValue()))) {

key = entry.getKey();

break;

}

}

return key;

}

}

its showing error like..

BIFFVIEWER REQUIRES A FILENAME***

java.lang.NullPointerException

at java.io.FileInputStream.<init>(Unknown Source)

at java.io.FileInputStream.<init>(Unknown Source)

at org.apache.poi.hssf.dev.BiffViewer.run(BiffViewer. java:68)

at org.apache.poi.hssf.dev.BiffViewer.main(BiffViewer .java:649)