public class FieldDatabase
Example:
Document doc = new Document();
DocumentBuilder builder = new DocumentBuilder(doc);
// This DATABASE field will run a query on a database, and display the result in a table.
FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true);
field.setFileName(getDatabaseDir() + "Northwind.mdb");
field.setConnection("DSN=MS Access Databases");
field.setQuery("SELECT * FROM [Products]");
Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"",
field.getFieldCode());
// Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales.
field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true);
field.setFileName(getMyDir() + "Database\\Northwind.mdb");
field.setConnection("DSN=MS Access Databases");
field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " +
"FROM([Products] " +
"LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " +
"GROUP BY[Products].ProductName " +
"ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC");
// These attributes have the same function as LIMIT and TOP clauses.
// Configure them to display only rows 1 to 10 of the query result in the field's table.
field.setFirstRecord("1");
field.setLastRecord("10");
// This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu
// that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format.
field.setTableFormat("10");
// The FormatAttribute property is a string representation of an integer which stores multiple flags.
// We can patrially apply the format which the TableFormat property points to by setting different flags in this property.
// The number we use is the sum of a combination of values corresponding to different aspects of the table style.
// 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows).
field.setFormatAttributes("63");
field.setInsertHeadings(true);
field.setInsertOnceOnMailMerge(true);
doc.updateFields();
doc.save(getArtifactsDir() + "Field.DATABASE.docx");
Constructor Summary |
---|
Property Getters/Setters Summary | ||
---|---|---|
java.lang.String | getConnection() | |
void | setConnection(java.lang.Stringvalue) | |
Gets or sets a connection to the data. | ||
java.lang.String | getDisplayResult() | |
Gets the text that represents the displayed field result.
|
||
FieldEnd | getEnd() | |
Gets the node that represents the field end.
|
||
java.lang.String | getFileName() | |
void | setFileName(java.lang.Stringvalue) | |
Gets or sets the complete path and file name of the database | ||
java.lang.String | getFirstRecord() | |
void | setFirstRecord(java.lang.Stringvalue) | |
Gets or sets the integral record number of the first data record to insert. | ||
FieldFormat | getFormat() | |
Gets a |
||
java.lang.String | getFormatAttributes() | |
void | setFormatAttributes(java.lang.Stringvalue) | |
Gets or sets which attributes of the format are to be applied to the table. | ||
boolean | getInsertHeadings() | |
void | setInsertHeadings(booleanvalue) | |
Gets or sets whether to insert the field names from the database as column headings in the resulting table. | ||
boolean | getInsertOnceOnMailMerge() | |
void | setInsertOnceOnMailMerge(booleanvalue) | |
Gets or sets whether to insert data at the beginning of a merge. | ||
boolean | isDirty() | |
void | isDirty(booleanvalue) | |
Gets or sets whether the current result of the field is no longer correct (stale) due to other modifications made to the document. | ||
boolean | isLocked() | |
void | isLocked(booleanvalue) | |
Gets or sets whether the field is locked (should not recalculate its result). | ||
java.lang.String | getLastRecord() | |
void | setLastRecord(java.lang.Stringvalue) | |
Gets or sets the integral record number of the last data record to insert. | ||
int | getLocaleId() | |
void | setLocaleId(intvalue) | |
Gets or sets the LCID of the field. | ||
java.lang.String | getQuery() | |
void | setQuery(java.lang.Stringvalue) | |
Gets or sets a set of SQL instructions that query the database. | ||
java.lang.String | getResult() | |
void | setResult(java.lang.Stringvalue) | |
Gets or sets text that is between the field separator and field end. | ||
FieldSeparator | getSeparator() | |
Gets the node that represents the field separator. Can be null.
|
||
FieldStart | getStart() | |
Gets the node that represents the start of the field.
|
||
java.lang.String | getTableFormat() | |
void | setTableFormat(java.lang.Stringvalue) | |
Gets or sets the format that is to be applied to the result of the database query. | ||
int | getType() | |
Gets the Microsoft Word field type.
The value of the property is FieldType integer constant. |
Method Summary | ||
---|---|---|
java.lang.String | getFieldCode() | |
Returns text between field start and field separator (or field end if there is no separator).
Both field code and field result of child fields are included.
|
||
java.lang.String | getFieldCode(boolean includeChildFieldCodes) | |
Returns text between field start and field separator (or field end if there is no separator).
|
||
Node | remove() | |
Removes the field from the document. Returns a node right after the field. If the field's end is the last child
of its parent node, returns its parent paragraph. If the field is already removed, returns null.
|
||
boolean | unlink() | |
Performs the field unlink.
|
||
void | update() | |
Performs the field update. Throws if the field is being updated already.
|
||
void | update(boolean ignoreMergeFormat) | |
Performs a field update. Throws if the field is being updated already.
|
public java.lang.String getConnection() / public void setConnection(java.lang.String value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public java.lang.String getDisplayResult()
Example:
Shows how to get the real text that a field displays in the document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); builder.write("This document was written by "); FieldAuthor fieldAuthor = (FieldAuthor)builder.insertField(FieldType.FIELD_AUTHOR, true); fieldAuthor.setAuthorName("John Doe"); // We can use the DisplayResult attribute to verify what exact text // a field would display in its place in the document. Assert.assertEquals("", fieldAuthor.getDisplayResult()); // Fields do not maintain accurate result values in real-time. // To make sure our fields display accurate results at any given time, // such as right before a save operation, we need to update them manually. fieldAuthor.update(); Assert.assertEquals("John Doe", fieldAuthor.getDisplayResult()); doc.save(getArtifactsDir() + "Field.DisplayResult.docx");
public FieldEnd getEnd()
Example:
Shows how to work with a collection of fields.public void fieldCollection() throws Exception { Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); builder.insertField(" DATE \\@ \"dddd, d MMMM yyyy\" "); builder.insertField(" TIME "); builder.insertField(" REVNUM "); builder.insertField(" AUTHOR \"John Doe\" "); builder.insertField(" SUBJECT \"My Subject\" "); builder.insertField(" QUOTE \"Hello world!\" "); doc.updateFields(); // This collection stores all of a document's fields. FieldCollection fields = doc.getRange().getFields(); Assert.assertEquals(6, fields.getCount()); // Iterate over the field collection, and print contents and type // of every field using a custom visitor implementation. FieldVisitor fieldVisitor = new FieldVisitor(); Iterator<Field> fieldEnumerator = fields.iterator(); while (fieldEnumerator.hasNext()) { if (fieldEnumerator.next() != null) { Field currentField = fieldEnumerator.next(); currentField.getStart().accept(fieldVisitor); if (currentField.getSeparator() != null) { currentField.getSeparator().accept(fieldVisitor); } currentField.getEnd().accept(fieldVisitor); } else { System.out.println("There are no fields in the document."); } } System.out.println(fieldVisitor.getText()); } /// <summary> /// Document visitor implementation that prints field info. /// </summary> public static class FieldVisitor extends DocumentVisitor { public FieldVisitor() { mBuilder = new StringBuilder(); } /// <summary> /// Gets the plain text of the document that was accumulated by the visitor. /// </summary> public String getText() { return mBuilder.toString(); } /// <summary> /// Called when a FieldStart node is encountered in the document. /// </summary> public int visitFieldStart(final FieldStart fieldStart) { mBuilder.append("Found field: " + fieldStart.getFieldType() + "\r\n"); mBuilder.append("\tField code: " + fieldStart.getField().getFieldCode() + "\r\n"); mBuilder.append("\tDisplayed as: " + fieldStart.getField().getResult() + "\r\n"); return VisitorAction.CONTINUE; } /// <summary> /// Called when a FieldSeparator node is encountered in the document. /// </summary> public int visitFieldSeparator(final FieldSeparator fieldSeparator) { mBuilder.append("\tFound separator: " + fieldSeparator.getText() + "\r\n"); return VisitorAction.CONTINUE; } /// <summary> /// Called when a FieldEnd node is encountered in the document. /// </summary> public int visitFieldEnd(final FieldEnd fieldEnd) { mBuilder.append("End of field: " + fieldEnd.getFieldType() + "\r\n"); return VisitorAction.CONTINUE; } private /*final*/ StringBuilder mBuilder; }
public java.lang.String getFileName() / public void setFileName(java.lang.String value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public java.lang.String getFirstRecord() / public void setFirstRecord(java.lang.String value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public FieldFormat getFormat()
Example:
Shows how to format field results.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Use a document builder to insert a field that displays a result with no format applied. Field field = builder.insertField("= 2 + 3"); Assert.assertEquals("= 2 + 3", field.getFieldCode()); Assert.assertEquals("5", field.getResult()); // We can apply a format to a field's result using the field's attributes. // Below are three types of formats that we can apply to a field's result. // 1 - Numeric format: FieldFormat format = field.getFormat(); format.setNumericFormat("$###.00"); field.update(); Assert.assertEquals("= 2 + 3 \\# $###.00", field.getFieldCode()); Assert.assertEquals("$ 5.00", field.getResult()); // 2 - Date/time format: field = builder.insertField("DATE"); format = field.getFormat(); format.setDateTimeFormat("dddd, MMMM dd, yyyy"); field.update(); Assert.assertEquals("DATE \\@ \"dddd, MMMM dd, yyyy\"", field.getFieldCode()); System.out.println("Today's date, in {format.DateTimeFormat} format:\n\t{field.Result}"); // 3 - General format: field = builder.insertField("= 25 + 33"); format = field.getFormat(); format.getGeneralFormats().add(GeneralFormat.LOWERCASE_ROMAN); format.getGeneralFormats().add(GeneralFormat.UPPER); field.update(); int index = 0; Iterator<Integer> generalFormatEnumerator = format.getGeneralFormats().iterator(); while (generalFormatEnumerator.hasNext()) { int value = generalFormatEnumerator.next(); System.out.println(MessageFormat.format("General format index {0}: {1}", index++, value)); } Assert.assertEquals("= 25 + 33 \\* roman \\* Upper", field.getFieldCode()); Assert.assertEquals("LVIII", field.getResult()); Assert.assertEquals(2, format.getGeneralFormats().getCount()); Assert.assertEquals(GeneralFormat.LOWERCASE_ROMAN, format.getGeneralFormats().get(0)); // We can remove our formats to revert the field's result to its original form. format.getGeneralFormats().remove(GeneralFormat.LOWERCASE_ROMAN); format.getGeneralFormats().removeAt(0); Assert.assertEquals(0, format.getGeneralFormats().getCount()); field.update(); Assert.assertEquals("= 25 + 33 ", field.getFieldCode()); Assert.assertEquals("58", field.getResult()); Assert.assertEquals(0, format.getGeneralFormats().getCount());
public java.lang.String getFormatAttributes() / public void setFormatAttributes(java.lang.String value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public boolean getInsertHeadings() / public void setInsertHeadings(boolean value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public boolean getInsertOnceOnMailMerge() / public void setInsertOnceOnMailMerge(boolean value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public boolean isDirty() / public void isDirty(boolean value)
Example:
Shows how to use special property for updating field result.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Give the document's built-in "Author" property value, and then display it with a field. doc.getBuiltInDocumentProperties().setAuthor("John Doe"); FieldAuthor field = (FieldAuthor)builder.insertField(FieldType.FIELD_AUTHOR, true); Assert.assertFalse(field.isDirty()); Assert.assertEquals("John Doe", field.getResult()); // Update the property. The field still displays the old value. doc.getBuiltInDocumentProperties().setAuthor("John & Jane Doe"); Assert.assertEquals("John Doe", field.getResult()); // Since the field's value is out of date, we can mark it as "dirty". // This value will stay out of date until we update the field manually with the Field.Update() method. field.isDirty(true); OutputStream docStream = new FileOutputStream(getArtifactsDir() + "Filed.UpdateDirtyFields.docx"); try { // If we save without calling an update method, // the field will keep displaying the out of date value in the output document. doc.save(docStream, SaveFormat.DOCX); // The LoadOptions object has an option to update all fields // marked as "dirty" when loading the document. LoadOptions options = new LoadOptions(); options.setUpdateDirtyFields(updateDirtyFields); doc = new Document(String.valueOf(docStream), options); Assert.assertEquals("John & Jane Doe", doc.getBuiltInDocumentProperties().getAuthor()); field = (FieldAuthor) doc.getRange().getFields().get(0); // Updating dirty fields like this automatically set their "IsDirty" flag to false. if (updateDirtyFields) { Assert.assertEquals("John & Jane Doe", field.getResult()); Assert.assertFalse(field.isDirty()); } else { Assert.assertEquals("John Doe", field.getResult()); Assert.assertTrue(field.isDirty()); } } finally { if (docStream != null) docStream.close(); }
public boolean isLocked() / public void isLocked(boolean value)
Example:
Shows how to work with a FieldStart node.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); FieldDate field = (FieldDate) builder.insertField(FieldType.FIELD_DATE, true); field.getFormat().setDateTimeFormat("dddd, MMMM dd, yyyy"); field.update(); FieldChar fieldStart = field.getStart(); Assert.assertEquals(FieldType.FIELD_DATE, fieldStart.getFieldType()); Assert.assertEquals(false, fieldStart.isDirty()); Assert.assertEquals(false, fieldStart.isLocked()); // Retrieve the facade object which represents the field in the document. field = (FieldDate)fieldStart.getField(); Assert.assertEquals(false, field.isLocked()); Assert.assertEquals(" DATE \\@ \"dddd, MMMM dd, yyyy\"", field.getFieldCode()); // Update the field to show the current date. field.update();
public java.lang.String getLastRecord() / public void setLastRecord(java.lang.String value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public int getLocaleId() / public void setLocaleId(int value)
Example:
Shows how to insert a field and work with its locale.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Insert a DATE field, and then print the date it will display. // Your thread's current culture determines the formatting of the date. Field field = builder.insertField("DATE"); System.out.println("Today's date, as displayed in the \"{CultureInfo.CurrentCulture.EnglishName}\" culture: {field.Result}"); Assert.assertEquals(1033, field.getLocaleId()); // Changing the culture of our thread will impact the result of the DATE field. // Another way to get the DATE field to display a date in a different culture is to use its LocaleId attribute. // This way allows us to avoid changing the thread's culture to get this effect. doc.getFieldOptions().setFieldUpdateCultureSource(FieldUpdateCultureSource.FIELD_CODE); CultureInfo de = new CultureInfo("de-DE"); field.setLocaleId(1031); field.update(); System.out.println("Today's date, as displayed according to the \"{CultureInfo.GetCultureInfo(field.LocaleId).EnglishName}\" culture: {field.Result}");
public java.lang.String getQuery() / public void setQuery(java.lang.String value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public java.lang.String getResult() / public void setResult(java.lang.String value)
Example:
Shows how to insert a field into a document using a field code.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); Field dateField = builder.insertField("DATE \\* MERGEFORMAT"); Assert.assertEquals(FieldType.FIELD_DATE, dateField.getType()); Assert.assertEquals("DATE \\* MERGEFORMAT", dateField.getFieldCode());
public FieldSeparator getSeparator()
Example:
Shows how to work with a collection of fields.public void fieldCollection() throws Exception { Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); builder.insertField(" DATE \\@ \"dddd, d MMMM yyyy\" "); builder.insertField(" TIME "); builder.insertField(" REVNUM "); builder.insertField(" AUTHOR \"John Doe\" "); builder.insertField(" SUBJECT \"My Subject\" "); builder.insertField(" QUOTE \"Hello world!\" "); doc.updateFields(); // This collection stores all of a document's fields. FieldCollection fields = doc.getRange().getFields(); Assert.assertEquals(6, fields.getCount()); // Iterate over the field collection, and print contents and type // of every field using a custom visitor implementation. FieldVisitor fieldVisitor = new FieldVisitor(); Iterator<Field> fieldEnumerator = fields.iterator(); while (fieldEnumerator.hasNext()) { if (fieldEnumerator.next() != null) { Field currentField = fieldEnumerator.next(); currentField.getStart().accept(fieldVisitor); if (currentField.getSeparator() != null) { currentField.getSeparator().accept(fieldVisitor); } currentField.getEnd().accept(fieldVisitor); } else { System.out.println("There are no fields in the document."); } } System.out.println(fieldVisitor.getText()); } /// <summary> /// Document visitor implementation that prints field info. /// </summary> public static class FieldVisitor extends DocumentVisitor { public FieldVisitor() { mBuilder = new StringBuilder(); } /// <summary> /// Gets the plain text of the document that was accumulated by the visitor. /// </summary> public String getText() { return mBuilder.toString(); } /// <summary> /// Called when a FieldStart node is encountered in the document. /// </summary> public int visitFieldStart(final FieldStart fieldStart) { mBuilder.append("Found field: " + fieldStart.getFieldType() + "\r\n"); mBuilder.append("\tField code: " + fieldStart.getField().getFieldCode() + "\r\n"); mBuilder.append("\tDisplayed as: " + fieldStart.getField().getResult() + "\r\n"); return VisitorAction.CONTINUE; } /// <summary> /// Called when a FieldSeparator node is encountered in the document. /// </summary> public int visitFieldSeparator(final FieldSeparator fieldSeparator) { mBuilder.append("\tFound separator: " + fieldSeparator.getText() + "\r\n"); return VisitorAction.CONTINUE; } /// <summary> /// Called when a FieldEnd node is encountered in the document. /// </summary> public int visitFieldEnd(final FieldEnd fieldEnd) { mBuilder.append("End of field: " + fieldEnd.getFieldType() + "\r\n"); return VisitorAction.CONTINUE; } private /*final*/ StringBuilder mBuilder; }
public FieldStart getStart()
Example:
Shows how to work with a collection of fields.public void fieldCollection() throws Exception { Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); builder.insertField(" DATE \\@ \"dddd, d MMMM yyyy\" "); builder.insertField(" TIME "); builder.insertField(" REVNUM "); builder.insertField(" AUTHOR \"John Doe\" "); builder.insertField(" SUBJECT \"My Subject\" "); builder.insertField(" QUOTE \"Hello world!\" "); doc.updateFields(); // This collection stores all of a document's fields. FieldCollection fields = doc.getRange().getFields(); Assert.assertEquals(6, fields.getCount()); // Iterate over the field collection, and print contents and type // of every field using a custom visitor implementation. FieldVisitor fieldVisitor = new FieldVisitor(); Iterator<Field> fieldEnumerator = fields.iterator(); while (fieldEnumerator.hasNext()) { if (fieldEnumerator.next() != null) { Field currentField = fieldEnumerator.next(); currentField.getStart().accept(fieldVisitor); if (currentField.getSeparator() != null) { currentField.getSeparator().accept(fieldVisitor); } currentField.getEnd().accept(fieldVisitor); } else { System.out.println("There are no fields in the document."); } } System.out.println(fieldVisitor.getText()); } /// <summary> /// Document visitor implementation that prints field info. /// </summary> public static class FieldVisitor extends DocumentVisitor { public FieldVisitor() { mBuilder = new StringBuilder(); } /// <summary> /// Gets the plain text of the document that was accumulated by the visitor. /// </summary> public String getText() { return mBuilder.toString(); } /// <summary> /// Called when a FieldStart node is encountered in the document. /// </summary> public int visitFieldStart(final FieldStart fieldStart) { mBuilder.append("Found field: " + fieldStart.getFieldType() + "\r\n"); mBuilder.append("\tField code: " + fieldStart.getField().getFieldCode() + "\r\n"); mBuilder.append("\tDisplayed as: " + fieldStart.getField().getResult() + "\r\n"); return VisitorAction.CONTINUE; } /// <summary> /// Called when a FieldSeparator node is encountered in the document. /// </summary> public int visitFieldSeparator(final FieldSeparator fieldSeparator) { mBuilder.append("\tFound separator: " + fieldSeparator.getText() + "\r\n"); return VisitorAction.CONTINUE; } /// <summary> /// Called when a FieldEnd node is encountered in the document. /// </summary> public int visitFieldEnd(final FieldEnd fieldEnd) { mBuilder.append("End of field: " + fieldEnd.getFieldType() + "\r\n"); return VisitorAction.CONTINUE; } private /*final*/ StringBuilder mBuilder; }
public java.lang.String getTableFormat() / public void setTableFormat(java.lang.String value)
Example:
Shows how to extract data from a database and insert it as a field into a document.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // This DATABASE field will run a query on a database, and display the result in a table. FieldDatabase field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getDatabaseDir() + "Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT * FROM [Products]"); Assert.assertEquals(" DATABASE \\d \"{DatabaseDir.Replace('\\', '\\\\') + 'Northwind.mdb'}\" \\c \"DSN=MS Access Databases\" \\s \"SELECT * FROM [Products]\"", field.getFieldCode()); // Insert another DATABASE field with a more complex query that sorts all products in descending order by gross sales. field = (FieldDatabase)builder.insertField(FieldType.FIELD_DATABASE, true); field.setFileName(getMyDir() + "Database\\Northwind.mdb"); field.setConnection("DSN=MS Access Databases"); field.setQuery("SELECT [Products].ProductName, FORMAT(SUM([Order Details].UnitPrice * (1 - [Order Details].Discount) * [Order Details].Quantity), 'Currency') AS GrossSales " + "FROM([Products] " + "LEFT JOIN[Order Details] ON[Products].[ProductID] = [Order Details].[ProductID]) " + "GROUP BY[Products].ProductName " + "ORDER BY SUM([Order Details].UnitPrice* (1 - [Order Details].Discount) * [Order Details].Quantity) DESC"); // These attributes have the same function as LIMIT and TOP clauses. // Configure them to display only rows 1 to 10 of the query result in the field's table. field.setFirstRecord("1"); field.setLastRecord("10"); // This attribute is the index of the format we want to use for our table. The list of table formats is in the "Table AutoFormat..." menu // that shows up when we create a DATABASE field in Microsoft Word. Index #10 corresponds to the "Colorful 3" format. field.setTableFormat("10"); // The FormatAttribute property is a string representation of an integer which stores multiple flags. // We can patrially apply the format which the TableFormat property points to by setting different flags in this property. // The number we use is the sum of a combination of values corresponding to different aspects of the table style. // 63 represents 1 (borders) + 2 (shading) + 4 (font) + 8 (color) + 16 (autofit) + 32 (heading rows). field.setFormatAttributes("63"); field.setInsertHeadings(true); field.setInsertOnceOnMailMerge(true); doc.updateFields(); doc.save(getArtifactsDir() + "Field.DATABASE.docx");
public int getType()
Example:
Shows how to insert a field into a document using a field code.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); Field dateField = builder.insertField("DATE \\* MERGEFORMAT"); Assert.assertEquals(FieldType.FIELD_DATE, dateField.getType()); Assert.assertEquals("DATE \\* MERGEFORMAT", dateField.getFieldCode());
public java.lang.String getFieldCode()
Example:
Shows how to get a field's field code.// Open a document which contains a MERGEFIELD inside an IF field. Document doc = new Document(getMyDir() + "Nested fields.docx"); FieldIf fieldIf = (FieldIf)doc.getRange().getFields().get(0); // There are two ways of getting a field's field code: // 1 - Omit its inner fields: Assert.assertEquals(" IF > 0 \" (surplus of ) \" \"\" ", fieldIf.getFieldCode(false)); // 2 - Include its inner fields: Assert.assertEquals(" IF \u0013 MERGEFIELD NetIncome \u0014\u0015 > 0 \" (surplus of \u0013 MERGEFIELD NetIncome \\f $ \u0014\u0015) \" \"\" ", fieldIf.getFieldCode(true)); // By default, the GetFieldCode method displays inner fields. Assert.assertEquals(fieldIf.getFieldCode(), fieldIf.getFieldCode(true));
Example:
Shows how to insert a field into a document using a field code.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); Field dateField = builder.insertField("DATE \\* MERGEFORMAT"); Assert.assertEquals(FieldType.FIELD_DATE, dateField.getType()); Assert.assertEquals("DATE \\* MERGEFORMAT", dateField.getFieldCode());
public java.lang.String getFieldCode(boolean includeChildFieldCodes)
includeChildFieldCodes
- True
if child field codes should be included.
Example:
Shows how to get a field's field code.// Open a document which contains a MERGEFIELD inside an IF field. Document doc = new Document(getMyDir() + "Nested fields.docx"); FieldIf fieldIf = (FieldIf)doc.getRange().getFields().get(0); // There are two ways of getting a field's field code: // 1 - Omit its inner fields: Assert.assertEquals(" IF > 0 \" (surplus of ) \" \"\" ", fieldIf.getFieldCode(false)); // 2 - Include its inner fields: Assert.assertEquals(" IF \u0013 MERGEFIELD NetIncome \u0014\u0015 > 0 \" (surplus of \u0013 MERGEFIELD NetIncome \\f $ \u0014\u0015) \" \"\" ", fieldIf.getFieldCode(true)); // By default, the GetFieldCode method displays inner fields. Assert.assertEquals(fieldIf.getFieldCode(), fieldIf.getFieldCode(true));
public Node remove() throws java.lang.Exception
Example:
Shows how to process PRIVATE fields.public void fieldPrivate() throws Exception { // Open a Corel WordPerfect document which we have converted to .docx format. Document doc = new Document(getMyDir() + "Field sample - PRIVATE.docx"); // WordPerfect 5.x/6.x documents like the one we have loaded may contain PRIVATE fields. // Microsoft Word preserves PRIVATE fields during load/save operations, // but provides no functionality for them. FieldPrivate field = (FieldPrivate)doc.getRange().getFields().get(0); Assert.assertEquals(" PRIVATE \"My value\" ", field.getFieldCode()); Assert.assertEquals(FieldType.FIELD_PRIVATE, field.getType()); // We can also insert PRIVATE fields using a document builder. DocumentBuilder builder = new DocumentBuilder(doc); builder.insertField(FieldType.FIELD_PRIVATE, true); // These fields are not a viable way of protecting sensitive information. // Unless backward compatibility with older versions of WordPerfect is essential, // we can safely remove these fields. We can do this using a DocumentVisiitor implementation. Assert.assertEquals(2, doc.getRange().getFields().getCount()); FieldPrivateRemover remover = new FieldPrivateRemover(); doc.accept(remover); Assert.assertEquals(remover.getFieldsRemovedCount(), 2); Assert.assertEquals(doc.getRange().getFields().getCount(), 0); } /// <summary> /// Removes all encountered PRIVATE fields. /// </summary> public static class FieldPrivateRemover extends DocumentVisitor { public FieldPrivateRemover() { mFieldsRemovedCount = 0; } public int getFieldsRemovedCount() { return mFieldsRemovedCount; } /// <summary> /// Called when a FieldEnd node is encountered in the document. /// If the node belongs to a PRIVATE field, the entire field is removed. /// </summary> public int visitFieldEnd(final FieldEnd fieldEnd) throws Exception { if (fieldEnd.getFieldType() == FieldType.FIELD_PRIVATE) { fieldEnd.getField().remove(); mFieldsRemovedCount++; } return VisitorAction.CONTINUE; } private int mFieldsRemovedCount; }
Example:
Shows how to remove fields from a field collection.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); builder.insertField(" DATE \\@ \"dddd, d MMMM yyyy\" "); builder.insertField(" TIME "); builder.insertField(" REVNUM "); builder.insertField(" AUTHOR \"John Doe\" "); builder.insertField(" SUBJECT \"My Subject\" "); builder.insertField(" QUOTE \"Hello world!\" "); doc.updateFields(); // This collection stores all of a document's fields. FieldCollection fields = doc.getRange().getFields(); Assert.assertEquals(6, fields.getCount()); // Below are four ways of removing fields from a field collection. // 1 - Get a field to remove itself: fields.get(0).remove(); Assert.assertEquals(5, fields.getCount()); // 2 - Get the collection to remove a field that we pass to its removal method: Field lastField = fields.get(3); fields.remove(lastField); Assert.assertEquals(4, fields.getCount()); // 3 - Remove a field from a collection at an index: fields.removeAt(2); Assert.assertEquals(3, fields.getCount()); // 4 - Remove all the fields from the collection at once: fields.clear(); Assert.assertEquals(0, fields.getCount());
public boolean unlink() throws java.lang.Exception
Replaces the field with its most recent result.
Some fields, such as XE (Index Entry) fields and SEQ (Sequence) fields, cannot be unlinked.
True
if the field has been unlinked, otherwise false
.
Example:
Shows how to unlink a field.Document doc = new Document(getMyDir() + "Linked fields.docx"); doc.getRange().getFields().get(1).unlink();
public void update() throws java.lang.Exception
Example:
Shows how to format field results.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Use a document builder to insert a field that displays a result with no format applied. Field field = builder.insertField("= 2 + 3"); Assert.assertEquals("= 2 + 3", field.getFieldCode()); Assert.assertEquals("5", field.getResult()); // We can apply a format to a field's result using the field's attributes. // Below are three types of formats that we can apply to a field's result. // 1 - Numeric format: FieldFormat format = field.getFormat(); format.setNumericFormat("$###.00"); field.update(); Assert.assertEquals("= 2 + 3 \\# $###.00", field.getFieldCode()); Assert.assertEquals("$ 5.00", field.getResult()); // 2 - Date/time format: field = builder.insertField("DATE"); format = field.getFormat(); format.setDateTimeFormat("dddd, MMMM dd, yyyy"); field.update(); Assert.assertEquals("DATE \\@ \"dddd, MMMM dd, yyyy\"", field.getFieldCode()); System.out.println("Today's date, in {format.DateTimeFormat} format:\n\t{field.Result}"); // 3 - General format: field = builder.insertField("= 25 + 33"); format = field.getFormat(); format.getGeneralFormats().add(GeneralFormat.LOWERCASE_ROMAN); format.getGeneralFormats().add(GeneralFormat.UPPER); field.update(); int index = 0; Iterator<Integer> generalFormatEnumerator = format.getGeneralFormats().iterator(); while (generalFormatEnumerator.hasNext()) { int value = generalFormatEnumerator.next(); System.out.println(MessageFormat.format("General format index {0}: {1}", index++, value)); } Assert.assertEquals("= 25 + 33 \\* roman \\* Upper", field.getFieldCode()); Assert.assertEquals("LVIII", field.getResult()); Assert.assertEquals(2, format.getGeneralFormats().getCount()); Assert.assertEquals(GeneralFormat.LOWERCASE_ROMAN, format.getGeneralFormats().get(0)); // We can remove our formats to revert the field's result to its original form. format.getGeneralFormats().remove(GeneralFormat.LOWERCASE_ROMAN); format.getGeneralFormats().removeAt(0); Assert.assertEquals(0, format.getGeneralFormats().getCount()); field.update(); Assert.assertEquals("= 25 + 33 ", field.getFieldCode()); Assert.assertEquals("58", field.getResult()); Assert.assertEquals(0, format.getGeneralFormats().getCount());
Example:
Shows how to insert a field into a document using FieldType.Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Insert two fields while passing a flag which determines whether to update them as the builder inserts them. // In some cases, updating fields could be computationally expensive, and it may be a good idea to defer the update. // Not all field types require updating, exceptions include BARCODE and MERGEFIELD. doc.getBuiltInDocumentProperties().setAuthor("John Doe"); builder.write("This document was written by "); builder.insertField(FieldType.FIELD_AUTHOR, updateInsertedFieldsImmediately); builder.insertParagraph(); builder.write("\nThis is page "); builder.insertField(FieldType.FIELD_PAGE, updateInsertedFieldsImmediately); Assert.assertEquals(" AUTHOR ", doc.getRange().getFields().get(0).getFieldCode()); Assert.assertEquals(" PAGE ", doc.getRange().getFields().get(1).getFieldCode()); if (updateInsertedFieldsImmediately) { Assert.assertEquals("John Doe", doc.getRange().getFields().get(0).getResult()); Assert.assertEquals("1", doc.getRange().getFields().get(1).getResult()); } else { Assert.assertEquals("", doc.getRange().getFields().get(0).getResult()); Assert.assertEquals("", doc.getRange().getFields().get(1).getResult()); // We will need to update these fields using the update methods manually. doc.getRange().getFields().get(0).update(); Assert.assertEquals("John Doe", doc.getRange().getFields().get(0).getResult()); doc.updateFields(); Assert.assertEquals("1", doc.getRange().getFields().get(1).getResult()); }
public void update(boolean ignoreMergeFormat) throws java.lang.Exception
ignoreMergeFormat
-
If true
then direct field result formatting is abandoned, regardless of the MERGEFORMAT switch, otherwise normal update is performed.