MS SQL Data Wizard online Help

Return to chapter overview

Excel

This step allows you to customize options for target MS Excel file.

The Data Format tab contains general options allowing you to adjust the format for each kind of Excel cells. This means that you can specify such parameters as font, borders, filling color and method, etc. for each entity (such as header, footer, caption, data, hyperlink and so on) separately. It is also possible to specify these parameters for each exported data field (the Fields tab) and create styles to make target Excel file be striped by columns or rows (the Styles tab).

The Extensions tab provides an ability to add hyperlinks and notes to any cell of the target file. Click the Plus button to add a new hyperlink or a note to the target Excel sheet and adjust its parameters. Click the Minus button to delete the added hyperlink or note.

The Advanced tab allows you to define the page header, the page footer and the title for target Excel sheet.

Return to chapter overview

Company news

Apr 30, 2008

Data Wizard product family updated to version 8.4

New version features support for system tasks, command line options, a lot of improvements in PHP Generator and much more.

Aug 22, 2007

New version of Data Wizard product family released

Features ASP.NET Generator wizard and a new Shell Application with the Ribbon toolbar. There are versions for MySQL, Oracle, SQL Server, PostgreSQL, SQLite, Firebird and MaxDB.

May 29, 2007

New purchase option available

Now you can purchase all our products and bundles with 3 year upgrades included.

More news

Feature of the day

Tray Agent

Tray agent can execute tasks scheduled in MS SQL Data Wizard, but does not require Data Wizard to be running at that time.

Data Pump

MS SQL Data Wizard: Data Pump allows you to pump database (both of structure and data) from such sources as MySQL or MS Access database to MS SQL database.