Re: Struggling with an excel file - Resolved (but don't understand it)

In debugging the application further I came across this oddity: I added the following to the downloadFile method:

(actually, I uncommented it)

int bytesread = source.read(buffer); // see how many bytes are read

and the spreadsheet started to open correctly again. I have no idea why. The buffer isn't altered, just read.

Whatever the source.read(buffer) does, it fixes the problem so I am going to go with it.

I am sure there is a rational explanation but I don't have time to get to the bottom of it.

Pete


Pete Helgren wrote:

I have been hunting around the Net for a solution and I have wondered if translation was an issue. I don't specifically translate anything I know of. Once the spreadsheet is created the getSpreadSheet method does the following:

public byte[] getSpreadSheet(String sheetname, UserContainer userContainer) throws IOException{
String userId = userContainer.getDaoContainer().getUserId();
String filePath = _spreadsheetPath + userId.trim();
byte[] outFile = null;
// We'll need some logic to use either the AS400 routines or the
// regular file utility
if(_i5os) // properties value
outFile = AS400FileUtility.downloadFile(userContainer.getDaoContainer(), filePath, sheetname);
else
outFile = FileUtility.downloadFile(filePath, sheetname);

return ourFile;
}

I originally thought the issue was here because the downloadFile method would use the AS400FileUtility class and it could account for the difference I was seeing when things ran on the System i vs on my notebook, but after the new war deployed to Tomcat (5.0.28) , both the System i and my local notebook produce a bad excel file.

FWIW the downloadFile method is:

public static byte[] downloadFile(String filepath, String filename) throws IOException {
FileInputStream source = null;
try {
String sourceName = filepath + File.separator + filename;
// Path and file should have been created by spreadsheet builder
// which puts the file into the folder. We are just retrieving it here

source = new FileInputStream(sourceName);
int available = source.available();
System.out.println("Source file successfully opened");

byte[] buffer = new byte[available];

//int bytesread = source.read(buffer);
//System.out.println("Bytes read:" + bytesread);

return buffer;

} catch (IOException e) {
e.printStackTrace();
return null;
} finally {
if (source != null)
source.close();

}
}

Not being a "raw" file reader, how would I go about "comparing the hex values"?

Thanks

Pete