/// <summary> /// Processes a DocumentInputStream into essentially Record events. /// </summary> /// <param name="req">an Instance of HSSFRequest which has your registered listeners</param> /// <param name="in1">a DocumentInputStream obtained from POIFS's POIFSFileSystem object</param> /// <returns>numeric user-specified result code.</returns> protected short GenericProcessEvents(HSSFRequest req, RecordInputStream in1) { bool going = true; short userCode = 0; Record r = null; // Create a new RecordStream and use that HSSFRecordStream recordStream = new HSSFRecordStream(in1); // Process each record as they come in while (going) { r = recordStream.NextRecord(); if (r != null) { userCode = req.ProcessRecord(r); if (userCode != 0) { break; } } else { going = false; } } // All done, return our last code return(userCode); }
/// <summary> /// Processes a DocumentInputStream into essentially Record events. /// If an /// <c>AbortableHSSFListener</c> /// causes a halt to Processing during this call /// the method will return just as with /// <c>abortableProcessEvents</c> /// , but no /// user code or /// <c>HSSFUserException</c> /// will be passed back. /// </summary> /// <param name="req">an Instance of HSSFRequest which has your registered listeners</param> /// <param name="in1">a DocumentInputStream obtained from POIFS's POIFSFileSystem object</param> public void ProcessEvents(HSSFRequest req, Stream in1) { try { GenericProcessEvents(req, new RecordInputStream(in1)); } catch (HSSFUserException) { /*If an HSSFUserException user exception Is thrown, ignore it.*/ } }
/// <summary> /// Processes a DocumentInputStream into essentially Record events. /// </summary> /// <param name="req">an Instance of HSSFRequest which has your registered listeners</param> /// <param name="in1">a DocumentInputStream obtained from POIFS's POIFSFileSystem object</param> /// <returns>numeric user-specified result code.</returns> public short AbortableProcessEvents(HSSFRequest req, Stream in1) { return(GenericProcessEvents(req, new RecordInputStream(in1))); }
/// <summary> /// Processes a file into essentially record events. /// </summary> /// <param name="req">an Instance of HSSFRequest which has your registered listeners</param> /// <param name="fs">a POIFS filesystem containing your workbook</param> /// <returns>numeric user-specified result code.</returns> public short AbortableProcessWorkbookEvents(HSSFRequest req, POIFSFileSystem fs) { Stream in1 = fs.CreateDocumentInputStream("Workbook"); return(AbortableProcessEvents(req, in1)); }
/// <summary> /// Processes a file into essentially record events. /// </summary> /// <param name="req">an Instance of HSSFRequest which has your registered listeners</param> /// <param name="fs">a POIFS filesystem containing your workbook</param> public void ProcessWorkbookEvents(HSSFRequest req, POIFSFileSystem fs) { Stream in1 = fs.CreateDocumentInputStream("Workbook"); ProcessEvents(req, in1); }