Java Doc for TestWorkbook.java in » Collaboration » poi-3.0.2-beta2 » org » apache » poi » hssf » usermodel » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation

1.	6.0 JDK Core
2.	6.0 JDK Modules
3.	6.0 JDK Modules com.sun
4.	6.0 JDK Modules com.sun.java
5.	6.0 JDK Modules sun
6.	6.0 JDK Platform
7.	Ajax
8.	Apache Harmony Java SE
9.	Aspect oriented
10.	Authentication Authorization
11.	Blogger System
12.	Build
13.	Byte Code
14.	Cache
15.	Chart
16.	Chat
17.	Code Analyzer
18.	Collaboration
19.	Content Management System
20.	Database Client
21.	Database DBMS
22.	Database JDBC Connection Pool
23.	Database ORM
24.	Development
25.	EJB Server geronimo
26.	EJB Server GlassFish
27.	EJB Server JBoss 4.2.1
28.	EJB Server resin 3.1.5
29.	ERP CRM Financial
30.	ESB
31.	Forum
32.	GIS
33.	Graphic Library
34.	Groupware
35.	HTML Parser
36.	IDE
37.	IDE Eclipse
38.	IDE Netbeans
39.	Installer
40.	Internationalization Localization
41.	Inversion of Control
42.	Issue Tracking
43.	J2EE
44.	JBoss
45.	JMS
46.	JMX
47.	Library
48.	Mail Clients
49.	Net
50.	Parser
51.	PDF
52.	Portal
53.	Profiler
54.	Project Management
55.	Report
56.	RSS RDF
57.	Rule Engine
58.	Science
59.	Scripting
60.	Search Engine
61.	Security
62.	Sevlet Container
63.	Source Control
64.	Swing Library
65.	Template Engine
66.	Test Coverage
67.	Testing
68.	UML
69.	Web Crawler
70.	Web Framework
71.	Web Mail
72.	Web Server
73.	Web Services
74.	Web Services apache cxf 2.0.1
75.	Web Services AXIS2
76.	Wiki Engine
77.	Workflow Engines
78.	XML
79.	XML UI

Java

Java Tutorial

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Collaboration » poi 3.0.2 beta2 » org.apache.poi.hssf.usermodel

Source Cross Reference

Class Diagram

Java Document (Java Doc)

org.apache.poi.hssf.usermodel .TestWorkbook

TestWorkbook
public class TestWorkbook extends TestCase (Code)
	Class to test Workbook functionality author: Andrew C. Oliver author: Greg Merrill author: Siggi Cherem

Constructor Summary
public	TestWorkbook(String name)

Method Summary
public static void	main(String[] ignored_args)
public void	testBackupRecord() Test the backup field gets set as expected.
public void	testManyRows()
public void	testModifyEmployee() TEST NAME: Test Modify Employee Sheet OBJECTIVE: Test that HSSF can read a simple spreadsheet with string values and replace them with other string values despite any styling.
public void	testModifySimple() TEST NAME: Test Modify Sheet Simple OBJECTIVE: Test that HSSF can read a simple spreadsheet with a string value and replace it with another string value. SUCCESS: HSSF reads a sheet.
public void	testModifySimpleWithSkip() TEST NAME: Test Modify Sheet Simple With Skipped cells OBJECTIVE: Test that HSSF can read a simple spreadsheet with string values and replace them with other string values while not replacing other cells. SUCCESS: HSSF reads a sheet.
public void	testModifySimpleWithStyling() TEST NAME: Test Modify Sheet With Styling OBJECTIVE: Test that HSSF can read a simple spreadsheet with string values and replace them with other string values despite any styling.
public void	testReadEmployeeSimple() TEST NAME: Test Read Employee Simple OBJECTIVE: Test that HSSF can read a simple spreadsheet (Employee.xls). SUCCESS: HSSF reads the sheet.
public void	testReadSheetWithRK() TEST NAME: Test Read Sheet with an RK number OBJECTIVE: Test that HSSF can read a simple spreadsheet with and RKRecord and correctly identify the cell as numeric and convert it to a NumberRecord.
public void	testReadSimple() TEST NAME: Test Read Simple OBJECTIVE: Test that HSSF can read a simple spreadsheet (Simple.xls). SUCCESS: HSSF reads the sheet.
public void	testReadSimpleWithDataFormat() TEST NAME: Test Read Simple w/ Data Format OBJECTIVE: Test that HSSF can read a simple spreadsheet (SimpleWithDataFormat.xls). SUCCESS: HSSF reads the sheet.
public void	testRepeatingBug() This tests is for bug [ #506658 ] Repeating output.
public void	testRepeatingColsRows()
public void	testWriteDataFormat() TEST NAME: Test Read/Write Simple w/ Data Format OBJECTIVE: Test that HSSF can write a sheet with custom data formats and then read it and get the proper formats. SUCCESS: HSSF reads the sheet.
public void	testWriteModifySheetMerged() TEST NAME: Test Write/Modify Sheet Simple OBJECTIVE: Test that HSSF can create a simple spreadsheet with numeric and string values, remove some rows, yet still have a valid file/data. SUCCESS: HSSF creates a sheet.
public void	testWriteModifySheetSimple() TEST NAME: Test Write/Modify Sheet Simple OBJECTIVE: Test that HSSF can create a simple spreadsheet with numeric and string values, remove some rows, yet still have a valid file/data. SUCCESS: HSSF creates a sheet.
public void	testWriteSheetSimple() TEST NAME: Test Write Sheet Simple OBJECTIVE: Test that HSSF can create a simple spreadsheet with numeric and string values. SUCCESS: HSSF creates a sheet.

Constructor Detail

TestWorkbook
public TestWorkbook(String name)(Code)
	Constructor TestWorkbook Parameters: name -

Method Detail

main
public static void main(String[] ignored_args)(Code)

testBackupRecord
public void testBackupRecord() throws Exception(Code)
	Test the backup field gets set as expected.

testManyRows
public void testManyRows() throws Exception(Code)

testModifyEmployee

public void testModifyEmployee() throws IOException(Code)

TEST NAME: Test Modify Employee Sheet

OBJECTIVE: Test that HSSF can read a simple spreadsheet with string values and replace them with other string values despite any styling. In this release of HSSF styling will probably be lost and is NOT tested.

SUCCESS: HSSF reads a sheet. HSSF replaces the cell values with other cell values. HSSF writes the sheet out to another file. HSSF reads the result and ensures the value has been properly replaced.

FAILURE: HSSF does not read a sheet or excepts. HSSF does not write the sheet or excepts. HSSF does not re-read the sheet or excepts. Upon re-reading the sheet the value is incorrect or has not been replaced.

testModifySimple

public void testModifySimple() throws IOException(Code)

TEST NAME: Test Modify Sheet Simple

OBJECTIVE: Test that HSSF can read a simple spreadsheet with a string value and replace it with another string value.

SUCCESS: HSSF reads a sheet. HSSF replaces the cell value with another cell value. HSSF writes the sheet out to another file. HSSF reads the result and ensures the value has been properly replaced.

testModifySimpleWithSkip

public void testModifySimpleWithSkip() throws IOException(Code)

TEST NAME: Test Modify Sheet Simple With Skipped cells

OBJECTIVE: Test that HSSF can read a simple spreadsheet with string values and replace them with other string values while not replacing other cells.

SUCCESS: HSSF reads a sheet. HSSF replaces the cell value with another cell value. HSSF writes the sheet out to another file. HSSF reads the result and ensures the value has been properly replaced and unreplaced values are still unreplaced.

testModifySimpleWithStyling

public void testModifySimpleWithStyling() throws IOException(Code)

TEST NAME: Test Modify Sheet With Styling

SUCCESS: HSSF reads a sheet. HSSF replaces the cell values with other cell values. HSSF writes the sheet out to another file. HSSF reads the result and ensures the value has been properly replaced.

testReadEmployeeSimple

public void testReadEmployeeSimple() throws IOException(Code)

TEST NAME: Test Read Employee Simple

OBJECTIVE: Test that HSSF can read a simple spreadsheet (Employee.xls).

SUCCESS: HSSF reads the sheet. Matches values in their particular positions.

FAILURE: HSSF does not read a sheet or excepts. HSSF cannot identify values in the sheet in their known positions.

testReadSheetWithRK

public void testReadSheetWithRK() throws IOException(Code)

TEST NAME: Test Read Sheet with an RK number

OBJECTIVE: Test that HSSF can read a simple spreadsheet with and RKRecord and correctly identify the cell as numeric and convert it to a NumberRecord.

SUCCESS: HSSF reads a sheet. HSSF returns that the cell is a numeric type cell.

FAILURE: HSSF does not read a sheet or excepts. HSSF incorrectly indentifies the cell

testReadSimple

public void testReadSimple() throws IOException(Code)

TEST NAME: Test Read Simple

OBJECTIVE: Test that HSSF can read a simple spreadsheet (Simple.xls).

SUCCESS: HSSF reads the sheet. Matches values in their particular positions.

FAILURE: HSSF does not read a sheet or excepts. HSSF cannot identify values in the sheet in their known positions.

testReadSimpleWithDataFormat

public void testReadSimpleWithDataFormat() throws IOException(Code)

TEST NAME: Test Read Simple w/ Data Format

OBJECTIVE: Test that HSSF can read a simple spreadsheet (SimpleWithDataFormat.xls).

SUCCESS: HSSF reads the sheet. Matches values in their particular positions and format is correct

FAILURE: HSSF does not read a sheet or excepts. HSSF cannot identify values in the sheet in their known positions.

testRepeatingBug
public void testRepeatingBug() throws Exception(Code)
	This tests is for bug [ #506658 ] Repeating output. We need to make sure only one LabelSSTRecord is produced.

testRepeatingColsRows
public void testRepeatingColsRows() throws IOException(Code)
	Generate a file to visually/programmatically verify repeating rows and cols made it

testWriteDataFormat

public void testWriteDataFormat() throws IOException(Code)

TEST NAME: Test Read/Write Simple w/ Data Format

OBJECTIVE: Test that HSSF can write a sheet with custom data formats and then read it and get the proper formats.

SUCCESS: HSSF reads the sheet. Matches values in their particular positions and format is correct

FAILURE: HSSF does not read a sheet or excepts. HSSF cannot identify values in the sheet in their known positions.

testWriteModifySheetMerged

public void testWriteModifySheetMerged() throws IOException(Code)

TEST NAME: Test Write/Modify Sheet Simple

OBJECTIVE: Test that HSSF can create a simple spreadsheet with numeric and string values, remove some rows, yet still have a valid file/data.

SUCCESS: HSSF creates a sheet. Filesize matches a known good. HSSFSheet objects Last row, first row is tested against the correct values (74,25).

FAILURE: HSSF does not create a sheet or excepts. Filesize does not match the known good. HSSFSheet last row or first row is incorrect.

testWriteModifySheetSimple

public void testWriteModifySheetSimple() throws IOException(Code)

TEST NAME: Test Write/Modify Sheet Simple

OBJECTIVE: Test that HSSF can create a simple spreadsheet with numeric and string values, remove some rows, yet still have a valid file/data.

SUCCESS: HSSF creates a sheet. Filesize matches a known good. HSSFSheet objects Last row, first row is tested against the correct values (74,25).

FAILURE: HSSF does not create a sheet or excepts. Filesize does not match the known good. HSSFSheet last row or first row is incorrect.

testWriteSheetSimple

public void testWriteSheetSimple() throws IOException(Code)

TEST NAME: Test Write Sheet Simple

OBJECTIVE: Test that HSSF can create a simple spreadsheet with numeric and string values.

SUCCESS: HSSF creates a sheet. Filesize matches a known good. HSSFSheet objects Last row, first row is tested against the correct values (99,0).

FAILURE: HSSF does not create a sheet or excepts. Filesize does not match the known good. HSSFSheet last row or first row is incorrect.

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.