error : upload excel file

[Rajni Patel]

Hi,

I want to upload excel file using struts1.

In my action class below code I have written,

Error is coming on line
fileSystem = new POIFSFileSystem(fs);

java.io.IOException: Invalid header signature; read 63361219987247567, expected
-2226271756974174256

I have find from some forum, because of Excel file format error is coming.

I have excel 2003 and just I create 2 rows and 2 column, simple excel file.

Please, could anybody can tell me , what's the problem?

thanks,

UploadExcelForm uploadExcel = (UploadExcelForm) form;
	

		FormFile excelFile = uploadExcel.getExcelFile();

		FileInputStream fs = null;
		
		System.out.println("excelFile.getFileName() = "	+ excelFile.getFileName());
		POIFSFileSystem fileSystem = null;
		
		try {
			fs = new FileInputStream("c:\\Temp\\temp.xls");
			
		} catch (FileNotFoundException fe) {
			System.out.println("File not found in the specified path.");
			fe.printStackTrace();

		} catch (Exception fe) {
			System.out.println("Exception File not found in the specified path.");
			fe.printStackTrace();
		}

		try {
			System.out.println(" fs.toString() = " +fs.toString());
			fileSystem = new POIFSFileSystem(fs);
			System.out.println("fileSystem = " + fileSystem);

			HSSFWorkbook workbook = new HSSFWorkbook(fileSystem);
			System.out.println("workbook = " + workbook);

			HSSFSheet sheet = workbook.getSheetAt(0);
			System.out.println("sheet = " + sheet.getLastRowNum());
			}
			return mapping.findForward("add");
		}

		catch (IOException ex) {
			System.out.println("IOException ");
			ex.printStackTrace();
			return mapping.findForward("add");
		}

[Radovan Vukovic]

This error coming probably from your file, could be that is corrupted?

Or (I did not work with version after 3.5) i know that this version did not support excel autofilter. Can be that this is in your file?

[Rajni Patel]

just I did entry in 2 row & 2 column like name and no. and I close the file.
I have Excel 2003.

Please, Give me some suggestion.

Thanks

[Radovan Vukovic]

Why you are using POIFSFileSystem?
Only to create HSSFWorkbook?

If this is only reason then you can try and create HSSFWorkbook directly from InputStream

Check please

[Rajni Patel]

Thanks for reply.

My intense is to read excel file, and insert into database. I have change in my code. but still same error is coming.

Invalid header.

try {
		fs = new FileInputStream("c:\\Temp\\report.xls");
		System.out.println("fs.read = " + fs.read());
	} catch (FileNotFoundException fe) {
		System.out.println("File not found in the specified path.");
		fe.printStackTrace();
	} catch (Exception fe) {
		System.out.println("Exception File not found in the specified path.");
		fe.printStackTrace();
	}

	try {
			HSSFWorkbook workbook = new HSSFWorkbook(fs);
			System.out.println("workbook = " + workbook);

			HSSFSheet sheet = workbook.getSheetAt(0);
			System.out.println("sheet = " + sheet.getLastRowNum());
			
		}
	catch (IOException ex) {
			System.out.println("IOException ");
			ex.printStackTrace();
			return mapping.findForward("add");
		}

please guide me.

Thanks

[Rajni Patel]

I print message of getContenttype() for excel file. What it should come?
getContentType() = application/octet-stream or
getContentType() = application/vnd.ms-excel
Is it necessary t any fix contenttype?

thanks,