PL/OFFX - The MS Office file generator

XLSX related features

XLSX Creation
  • Create XLSX programatically from scratch
  • Generate XLSX reports from databases
  • Create XLSX documents on a Web server in real time
Program Init
  • Choose between 1900 date system or 1904 date system
XLSX
  • Set the title of the document
  • Set the subject
  • Set keywords to the document
  • Set the description to the document
  • Set the category of the document
  • Set status of the content
XLSX Font
  • Set font name
  • Set font size
  • Set the font italic, bold or underlined
  • Set font color
Defines a format style
  • Set numeric format from predefined formats
  • Set horizontal and vertical alignment
  • Set text rotation in degrees
  • Set wrap text property
XLSX Cell Border
  • Set the border style
  • Set the border color
Set comment to a cell
  • Set comment text
  • Set comment author
  • Set width and height for the comment box
Add an image to a cell
  • Set width and height of the image
  • Set description for the image
  • Set offset from row and column
Set printer settings for a document
  • Set the document to be printed in black and white
  • Set page orientation
  • Set paper size

DOCX related features


DOCX Creation
  • Create DOCX programatically from scratch
  • Generate DOCX reports from databases
  • Create DOCX documents on a Web server in real time
Text Properties
  • Font Name, Size
  • Font Style: Bold, Italic, Underline, Strike
  • Uppercase, Smallcap
  • Vertical Align
  • Text Width
  • Vertical Position
  • Spacing
  • Highlight
  • Fittext
Paragraph
  • Set the paragraph to be bidirectional
  • Set text alignment, identation, vertical alignment and spacing
  • Set a border to the paragraph
  • Set the paragraph to be displayed on a new page
  • Allow first and last line of the paragraph to be displayed on a separate page
DOCX Header or Footer
  • Set the header to be displayed on the first page
  • Set the header to be displayed on even pages
  • Set the header to be displayed on every page.
Table Border
  • Set the border type
  • Set the border color
  • Set the border width
  • Set the space between content and border
TabStop
  • Set image height and width
  • Set the position of the image
  • Set text wrapping preferences
  • Lock the position of the image
  • Specify image behaviour in table cells
  • Display the image behind or above the content
HyperLink
  • Set the url of the hyperlink
  • Set the text bold, italic, underlined or strikeout
  • Set font name and font size
  • Expand or compress text
  • Set Vertical align and position
  • Set text spacing
  • Set text color, highlight and border
Field
  • Add go to buttons
  • Add number of chars, words or pages
  • Add user name or user initials
  • Add save date or print date
  • Add greeting line
List
  • Specify the starting number for the numbering
  • Specify the symbol or number before the elements of the list