Excel file read error

[Asvin]

I was working on a project that involves importing data from .csv file and then printing that on the screen!

Here is what I have so far:

import java.io.*;

class ExcelFileRead
{
	public static void main(String[] args)
	{
		try
		{
			FileInputStream fstream = new FileInputStream("AAPL.csv");
			DataInputStream in = new DataInputStream(fstream);

			BufferedReader br = new BufferedReader(new InputStreamReader(in));

			String strLine;

			while(strLine == br.readLine() && != null)
			{
				String str2 = strLine.replace(',',' ');

				System.out.println(str2);
			}

			in.close();
		}

		catch(Exception e)
		{
			System.err.println("Error: " + e.getMessage());
		}
	}
}

I am getting an error on the while loop.. Here is what it says:

ExcelFileRead.java:16: illegal start of expression
while(strLine == br.readLine() && != null)

Any help will be much appreciated!

[erversteeg]

while(strLine == br.readLine() && strLine != null) will fix the illegal start of expression.

[Asvin]

It fixed the illegal start of expression error, but now it's saying

strLine may not be initialized

[erversteeg]

Whenever you get that message just give the variable a starting value when you initialize it. So try "String strLine = null"

[Asvin]

Now it's giving me the following errors when I compile:

ExcelFileRead.java.61: 'catch' without 'try'
catch(Exception e)
ExcelFileRead.java.61: '}' expected
catch(Exception e)
ExcelFileRead.java.61: not a statement
catch(Exception e)
ExcelFileRead.java.61: ';' expected
catch(Exception e)
ExcelFileRead.java.24: 'try' without 'catch' or 'finally'
try
5 errors
Press any key to continue . . .

Here is the code I have right now:

import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.io.IOException;

public class ExcelFileRead
{
		public static double convertJDN(String date)
		{
				String[] str = date.split("/");
				int Y = Integer.parseInt(str[2]);
				int M = Integer.parseInt(str[0]);
				int D = Integer.parseInt(str[1]);

				double JDN = (1461 * (Y + 4800 + (M - 14) / 12)) / 4 + (367 * (M - 2 - 12 * ((M - 14) / 12))) / 12 - (3 * ((Y + 4900 + (M - 14) / 12) / 100)) / 4 + D - 32075;

				return JDN;
		}

		public static void main(String[] args)
		{
					try
					{
						FileInputStream fstream = new FileInputStream("AAPL.csv");
						DataInputStream in = new DataInputStream(fstream);

						BufferedReader br = new BufferedReader(new InputStreamReader(in));

						String strLine = null;

						while((strLine = br.readLine()) && strLine != null)
						{
								String strAy[] = strLine.split(",");

								for(int i = 0; i < strAy.length; i++)
								{
										if(strAy[i].contains("/"))
										{
											double jdn = convertJDN(strAy[i]);

											System.out.format("%-12s",jdn);
										}

										else
										{
											double d;


												d = Double.parseDouble(strAy[i]);

												System.out.format("$-12s",strAy[i]);

										}
								}

								in.close();
						}

						catch(Exception e)
						{
							System.err.println("Error: " + e.getMessage());
						}
			}
		}
	}

I am using openoffice to open up the .csv file.. I don't have office installed on my laptop.. could that be the issue?

[Asvin]

Bumping for help

[Asvin]

Here is the updated code:

import java.io.*;
import java.io.BufferedReader;
import java.io.DataInputStream;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.io.IOException;
import java.io.File;
import java.io.FileNotFoundException;
import java.util.Scanner;


public class ExcelFileRead1
{

	public static double convertJDN(String date)
	{
			String[] str = date.split("/");
			int Y = Integer.parseInt(str[2]);
			int M = Integer.parseInt(str[0]);
			int D = Integer.parseInt(str[1]);

			double JDN = (1461 * (Y + 4800 + (M - 14) / 12)) / 4 + (367 * (M - 2 - 12 * ((M - 14) / 12))) / 12 - (3 * ((Y + 4900 + (M - 14) / 12) / 100)) / 4 + D - 32075;

			return JDN;
	}

	public static void main(String[] args)
	{

		String fileName = "AAPL.csv";

		Scanner inputStream = null;

		System.out.println("The file " + fileName + "contains the following values: ");

		try
		{
			inputStream = new Scanner(new File(fileName));
		}

		catch(FileNotFoundException e)
		{
			System.out.println("Error opening the file " + fileName);

			System.exit(0);
		}

		while(inputStream.hasNextLine())
		{
			String line = inputStream.nextLine();

			System.out.println(line);
		}

		inputStream.close();
	}
}

It compiles perfectly, but when I run it, it outputs:

"Error opening the file AAPL.csv"

^ This is what it should output if the file is not reachable or openable.. The file, it's class file, and AAPL.csv are all in my flash drive.. I also use open office, instead of excel.. Could those be the causes for this error?

[Asvin]

Anyone? Please?

[Asvin]

Bump.. Anyone? Lol!

[Asvin]

Bump! Anyone??????????????????????

[pbrockway2]

It compiles perfectly, but when I run it, it outputs:

"Error opening the file AAPL.csv"

^ This is what it should output if the file is not reachable or openable.. The file, it's class file, and AAPL.csv are all in my flash drive.

Insert some code so you can exactly what file the program is looking for when you get the error. Also it's a good idea to get as much information as you can from the exception itself.

try
{
    [color=blue]File file = new File(fileName);
    System.out.println("About to open " + file.getAbsolutePath());
    inputStream = new Scanner(file);[/color]
}

catch(FileNotFoundException e)
{
    System.out.println("Error opening the file " + fileName);
    [color=blue]e.printStackTrace();[/color]
    System.exit(0);
}