JUnitTest for DeferredSXSSFWorkbook usage

DeferredTest.java (text/plain), 3.02 KB, created by jasmin.suess on 2021-10-22 13:21:33 UTC

(hide)

Description: JUnitTest for DeferredSXSSFWorkbook usage

Filename:

MIME Type:

Creator: jasmin.suess

Created: 2021-10-22 13:21:33 UTC

Size: 3.02 KB

patch

obsolete

>package test; > >import static org.junit.Assert.*; > >import java.io.File; >import java.io.FileOutputStream; >import java.io.IOException; >import java.io.OutputStream; > >import org.apache.poi.EncryptedDocumentException; >import org.apache.poi.ss.usermodel.Cell; >import org.apache.poi.ss.usermodel.Row; >import org.apache.poi.ss.usermodel.Sheet; >import org.apache.poi.ss.usermodel.Workbook; >import org.apache.poi.ss.usermodel.WorkbookFactory; >import org.apache.poi.xssf.streaming.DeferredSXSSFWorkbook; >import org.apache.poi.xssf.streaming.SXSSFWorkbook; >import org.junit.Before; >import org.junit.Test; > >public class DeferredTest >{ > File sxssfTempFile; > > File deferredTempFile; > > @Before > public void setUp() throws Exception > { > //Create and try to fill the (0,0) cell of a SXSSFWorkbook > SXSSFWorkbook sxssfWorkBook = new SXSSFWorkbook(100); > Sheet sxssfSheet = sxssfWorkBook.createSheet("Sheet"); > Row sxssfRow = sxssfSheet.createRow(0); > Cell sxssfCell = sxssfRow.createCell(0); > sxssfCell.setCellValue("test"); > > sxssfTempFile = File.createTempFile("testSxssf", ".xlsx"); > sxssfTempFile.deleteOnExit(); > > try (OutputStream outputStream = new FileOutputStream(sxssfTempFile)) > { > sxssfWorkBook.writeAvoidingTempFiles(outputStream); > sxssfWorkBook.dispose(); > sxssfWorkBook.close(); > } > catch (IOException e) > { > throw new IOException(e); > } > > //Create and try to fill the (0,0) cell of a DeferredSXSSFWorkbook > DeferredSXSSFWorkbook deferredWorkBook = new DeferredSXSSFWorkbook(100); > Sheet deferredSheet = deferredWorkBook.createSheet("Sheet"); > Row deferredRow = deferredSheet.createRow(0); > Cell deferredCell = deferredRow.createCell(0); > deferredCell.setCellValue("test"); > > deferredTempFile = File.createTempFile("testDeferred", ".xlsx"); > deferredTempFile.deleteOnExit(); > > try (OutputStream outputStream = new FileOutputStream(deferredTempFile)) > { > deferredWorkBook.writeAvoidingTempFiles(outputStream); > deferredWorkBook.dispose(); > deferredWorkBook.close(); > } > catch (IOException e) > { > throw new IOException(e); > } > > } > > @Test > public void testDeferredSXSSF() throws EncryptedDocumentException, IOException > { > Workbook workbook = WorkbookFactory.create(deferredTempFile); > > Sheet inputSheet = workbook.getSheetAt(0); > String firstCellContent = inputSheet.getRow(0).getCell(0) > .getStringCellValue(); > > assertEquals("Is the (0,0) cell of the SXSSFWorkbook filled?", > firstCellContent.equals("test"), true); > } > > @Test > public void testSXSSF() throws EncryptedDocumentException, IOException > { > Workbook workbook = WorkbookFactory.create(sxssfTempFile); > > Sheet inputSheet = workbook.getSheetAt(0); > String firstCellContent = inputSheet.getRow(0).getCell(0) > .getStringCellValue(); > > assertEquals("Is the (0,0) cell of the DeferredSXSSFWorkbook filled?", > firstCellContent.equals("test"), true); > } >} View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]