Ariadne Software Ariadne Software Help Desk Knowledgebase
CoolSpools Database
Suggested knowledgebase articles:

Knowledgebase CoolSpools Database

Articles in this category

How to use CVTDBFXL and CVTDBFXLSX (V7) with maps, to create professional looking spreadsheets.

Converting Database Files to Excel. This article contains a link to presentations that show 'How To' create professional looking spreadsheets. The presentation covers the following :- How to crea...

2,045
(16,353)
Using the new V7 command functionality to create dynamic and professional Excel Spreadsheets.

Importing Excel Data, combine with existing data and create Professional Excel Spreadsheet. This article contains a link to a presentation that show 'How To' create professional looking spreadsheets,...

1,010
(16,463)
Assigning styles to rows in excel when using a Database-to-Excel map

When using a Database-to-excel map CoolSpools can not determine the type of row (e.g. header, column header, data, etc) to apply the relevant styles. In this circumstance, to associate a style with a ...

1,494
(15,502)
Using CVTDBFXL with Excel Pivot Tables

CoolSpools will not create pivot tables but it can be used to populate them as follows:   1. Use CoolSpools to create the 'base' spreadsheet. CVTDBFXL FROMFILE(...) TOSTMF('pivot.xlsx')STMFOPT(*REPLAC...

1,958
(10,219)
Excel encryption/passwords

Excel encryption/passwords If you need help with any of the techniques described below, feel free to contact our support team. Can CoolSpools password-

787
(10,037)
CoolSpools Database Variables

FAQ: Database Variables What are CoolSpools Database variables? CoolSpools Database variables The CoolSpools Database commands that convert database files support a number of special values known a...

4,683
(10,475)
Issues opening files in Microsoft Excel

FAQ: CoolSpools and Microsoft Excel I'm running CoolSpools  and am having problems opening spreadsheets in Excel. There are a number of known issues relating to Microsoft Excel opening spreadsheets ...

896
(10,538)
CVTDBF* using QMQRY failing with SQL0012

On IBM i V7R1M0 CVTDBF* fails with the warning message SQL0012 but completes succssfully on IBM i V6R1M0. This is due to a change in the way warning messages are returned. From the 'Memo to users V7...

1,042
(10,169)
CVTDBF* using QMQRY failing with SQL0012

On IBM i V7R1M0 CVTDBF* fails with the warning message SQL0012 but completes succssfully on IBM i V6R1M0. This is due to a change in the way warning messages are returned. From the 'Memo to users V7...

850
(10,032)
Using variables with CVTDBFXL

A question frequently asked is 'How do I use a variable with the CoolSpools CVTDBFXL command'. These examples demonstrate the CVTDBFXL command but similar methods can be used with any of the CoolSpool...

1,115
(15,040)
XML parser errors

If the XML parser detects an error in the XML document during parsing, message RNX0351 will be issued. From the message, you can get the specific error code associated with the error, as well as the ...

17,543
(3,911)
Including sub-totals with CVTDBFXL

Quite a common question to the helpdesk is ‘How can I include sub-totals in the excel spreadsheet?’ The CVTDBFXL command does not include functionality to calculate any form of totals. CVTDBFXL with Q...

610
(1)

© Ariadne Software Ltd. 2023

Search this site

Sitemap

Terms and Conditions