/** * A factory method which takes input an excel file and reads input the contents. * * @exception IOException * @exception BiffException * @param file the excel 97 spreadsheet to parse * @param ws the settings for the workbook * @return a workbook instance */ public static Workbook getWorkbook(FileInfo file, WorkbookSettings ws) { Stream fis = new FileStream(file.FullName, FileMode.Open); // Always close down the input stream, regardless of whether or not the // file can be parsed. Thanks to Steve Hahn for this CSharpJExcel.Jxl.Read.Biff.File dataFile = null; try { dataFile = new CSharpJExcel.Jxl.Read.Biff.File(fis, ws); } catch (IOException e) { throw e; } catch (BiffException e) { throw e; } finally { fis.Close(); } Workbook workbook = new WorkbookParser(dataFile, ws); workbook.parse(); return(workbook); }
public WriteAccess(FileInfo file, TextWriter os) { WorkbookSettings ws = new WorkbookSettings(); Stream fis = new FileStream(file.FullName,FileMode.Open,FileAccess.Read); CSharpJExcel.Jxl.Read.Biff.File f = new CSharpJExcel.Jxl.Read.Biff.File(fis, ws); reader = new BiffRecordReader(f); display(ws,os); fis.Close(); }
/** * A factory method which takes input an excel file and reads input the contents. * * @param inStream an open stream which inStream the the excel 97 spreadsheet to parse * @param ws the settings for the workbook * @return a workbook instance * @exception IOException * @exception BiffException */ public static Workbook getWorkbook(Stream inStream, WorkbookSettings ws) { CSharpJExcel.Jxl.Read.Biff.File dataFile = new CSharpJExcel.Jxl.Read.Biff.File(inStream, ws); Workbook workbook = new WorkbookParser(dataFile, ws); workbook.parse(); return(workbook); }
public WriteAccess(FileInfo file, TextWriter os) { WorkbookSettings ws = new WorkbookSettings(); Stream fis = new FileStream(file.FullName, FileMode.Open, FileAccess.Read); CSharpJExcel.Jxl.Read.Biff.File f = new CSharpJExcel.Jxl.Read.Biff.File(fis, ws); reader = new BiffRecordReader(f); display(ws, os); fis.Close(); }
/** * Constructor * * @param file the file * @param os the output stream * @exception IOException * @exception BiffException */ public BiffDump(FileInfo file, TextWriter os) { FileStream fis = new FileStream(file.FullName,FileMode.Open); CSharpJExcel.Jxl.Read.Biff.File f = new CSharpJExcel.Jxl.Read.Biff.File(fis, new WorkbookSettings()); reader = new BiffRecordReader(f); buildNameHash(); dump(os); os.Flush(); // os.close(); fis.Close(); }
/** * Constructor * * @param file the file * @param os the output stream * @exception IOException * @exception BiffException */ public BiffDump(FileInfo file, TextWriter os) { FileStream fis = new FileStream(file.FullName, FileMode.Open); CSharpJExcel.Jxl.Read.Biff.File f = new CSharpJExcel.Jxl.Read.Biff.File(fis, new WorkbookSettings()); reader = new BiffRecordReader(f); buildNameHash(); dump(os); os.Flush(); // os.close(); fis.Close(); }
/** * A factory method which takes input an excel file and reads input the contents. * * @param inStream an open stream which inStream the the excel 97 spreadsheet to parse * @param ws the settings for the workbook * @return a workbook instance * @exception IOException * @exception BiffException */ public static Workbook getWorkbook(Stream inStream, WorkbookSettings ws) { CSharpJExcel.Jxl.Read.Biff.File dataFile = new CSharpJExcel.Jxl.Read.Biff.File(inStream,ws); Workbook workbook = new WorkbookParser(dataFile,ws); workbook.parse(); return workbook; }
/** * A factory method which takes input an excel file and reads input the contents. * * @exception IOException * @exception BiffException * @param file the excel 97 spreadsheet to parse * @param ws the settings for the workbook * @return a workbook instance */ public static Workbook getWorkbook(FileInfo file,WorkbookSettings ws) { Stream fis = new FileStream(file.FullName,FileMode.Open); // Always close down the input stream, regardless of whether or not the // file can be parsed. Thanks to Steve Hahn for this CSharpJExcel.Jxl.Read.Biff.File dataFile = null; try { dataFile = new CSharpJExcel.Jxl.Read.Biff.File(fis, ws); } catch (IOException e) { throw e; } catch (BiffException e) { throw e; } finally { fis.Close(); } Workbook workbook = new WorkbookParser(dataFile,ws); workbook.parse(); return workbook; }