Benefits Testimonials Join the Team Archive Explore Contact Us
Cherniak Software Management Consulting System Integration Web Site Development Business Solutions
 

two Excellent tools for easily formatting your data

What is FormatX?
  • FormatX is a new way to easily format your data in Microsoft® Excel.
    No longer do you have to
    • change column widths
    • change fonts
    • put in borders and gridlines
    • add headers and footers (with page numbering)
    • bold or underline headers
    • insert other tedious formatting
  • FormatX does all the above for you automatically. FormatX works in two distinct modes:
    • FormatX: Format a set of data using default formatting automatically
    • FormatX+: Provide the ability for a data export program to add FormatX commands to the end of a set of data and have FormatX format a report according to your unique requirements.
 
FormatX Uses
Anytime you have a set of data in Excel that you want to easily clean up for printing
 
Formatting reports that are downloaded from your company database. Supports comma - delimited (CSV) and tab-delimited text files
 
Automatically formats 
  • Makes headers from the filename
  • Makes footers (date time at the bottom left, "Page X of Y" at the bottom right)
  • Makes borders around the text
  • Bolds headers and totals
  • Right justifies numeric columns
  • Puts lines above the totals
  • Chooses portrait or landscape and adjusts to fit an appropriate number of pages
  • Much more
     
     
     
     
     
     
     
 
FormatX+ Uses
Used to make a direct link from a data extraction program to show the data in a formatted Excel spreadsheet
The user running the data extraction program will not have to start any program; just extract the data, and they will have a formatted Excel spreadsheet
Can be used in three ways
  • automatically format in the same way FormatX does
  • use the default FormatX formatting, then add additional formatting commands, e.g.
    • Change headers or footers
    • Change fonts and sizes
    • Put bold, underline, or italics anywhere
    • Control where borders are drawn and their thicknesses
    • Change the number of decimal places shown for numbers
    • Right, left, or center justify
    • Much more
  • specify all the formatting commands that FormatX will do. Gives complete control to the programmer
 

FormatX Product Descriptions

Example Files

  FormatX FormatX+ specifying all commands FormatX+ with default and other commands
Before Formatting ABC Company Year Ended July 2002 Sales Orders ABC Company For FormatX+ with no defaults ABC Company For FormatX+ with defaults
After Formatting ABC Company Year Ended July 2002 Sales Orders ABC Company For FormatX+ with no defaults ABC Company For FormatX+ with defaults

FormatX Documents


Download

  • Download a free trial version of FormatX here.

Purchase

Get Acrobat Reader
Last Updated: March 24, 2017