Test Excel Spreadsheet Generator Features

Environment

Operating systems support	Windows XP, Vista, 7, Windows 8/10 (desktop), Server 2003, 2008, 2012 or newer.
Additional client side software required	No. Optional ODBC driver for database access is required.
Does the tool support console mode?	Yes.
Does the software compatible with Windows Scheduler?	Yes.
Can I access product features from Excel directly?	Yes, with add-in edition of the software.

Data Generation Options

Has the tool sets of predefined value lists?	Yes, it is value library.
How many predefined data generators are present?	About 30 predefined generators are accessible.
Can the user define custom generator?	Yes, using pattern engine.
Can I specify regular expression as a data generator?	Yes.
Can I assign default format for date and time?	Yes.
How many rows can be generated per spreadsheet?	It depends on Excel version. There is no built-in limitation.

Output Options

Does installed Excel required for the tool?	No, for results viewing only.
Can the software generate unique file name for each execution?	Yes, with $DATE$ and $TIME$ macros.
Is it possible to generate a few dummy Excel files per one execution?	No, in command line (console) mode only.

Import/Export Structure

Can the user provide sample file to import structure?	Yes.
Can the tool generate CREATE TABLE statement for defined file structure?	Yes.

Assistance/Help

Is help for the tool built into the product?	Yes.
Is help for the tool available online?	Yes, see online help

See Also

See Also

Articles 2

How to build test worksheets fast and easy. Test data value distributions: even, normal, linear.

Related Tools

Flat File Generator Test XML Generator JSON Document Generator Test File Factory