Product Search Information Firm
qtXLS

  • create files in the Excel data format
  • create tables (sheets) in these files
  • write data to tables (sheets)
  • read data from tables (sheets)
  • enquire information about tables (sheets) and columns

To perform these functions the library provides you with the following routines::

Function group /
qtXLS routine

Function

File functions

qtXLSCreateEXCELFile

Create Excel file

qtXLSOpenEXCELFile

Open Excel file

qtXLSCloseEXCELFile

Close Excel file

Table functions

qtXLSCreateTable

Create a table (sheet) and define columns

qtXLSReadRows

Read rows from table (sheet)

qtXLSWriteRows

Write rows to table (sheet)

Information functions

qtXLSGetTableNames

Get table (sheet) names in the file

qtXLSDoesTableNameExist

Check if a table (sheet) name exists

qtXLSGetColumnInfo

Enquire information about columns

qtXLSGetRowCount

Enquire number of rows in a table (sheet)

qtXLSGetNumericValue

Convert the value of a SQL numeric type into a real value

Error handling functions

qtXLSGetErrorMessages

Get error messages

qtXLSSetErrorLevel

Control error handling

qtXLSSetErrorMessagesDisplay

Set up display of error messages

Other functions

qtXLSGetszStringLength

Get length of a null-terminated string

qtSetLicence_qtXLS

Authorize usage of qtXLS (Fortran only)

qtXLSSetLicencePath

Set path for licence file

The example program

qtXLSDemoWriteTable.f90 (Fortran 95 source file)

qtXLSDemoWriteTable.cpp (C/C++ source file)

demonstrates how the qtXLS routines are used, and creates the following Excel sheet.

The qtXLS software is supplied as a dynamic-link-library (qtXLS.dll) together with bindings determined to use with your compiler (import libraries and other files necessary to compile and link), and sample programs.

At present two variants of qtXLS exist:

  • qtXLS - Version 2007, 32-Bit
    • Absoft ProFortran for Windows v10.0
    • Compaq Visual Fortran v6.6
    • Intel Visual Fortran (v8.1 and higher)
    • Lahey/Fujitsu Fortran for Windows (LF95) v5.7
    • Microsoft Visual C++ v6 and v7 (2003)
    • Silverfrost FTN95 (for Win32) v5.0 and higher

  • qtXLS - Version 2013, 32- and 64-Bit
    • Intel Visual Fortran (v11.1 and higher, 32-Bit)
    • Intel Visual Fortran (v12.1 and higher, 64-Bit)

These binding may be suitable also for newer versions of the compilers and possibly also for compatible compilers. If your compiler is not listed, but you would like to use qtXLS nevertheless, simply try out the binding to which your compiler manufacturer claims to be compatible. If you have difficulties here, don't hesitate to ask. Perhaps we can help.

Download

You can download an evaluation copy of qtXLS (software and documentation in PDF format(2)) here. The software is limited in function (1). Size of the download file approx. 4 to 5 MB:

(1) The evaluation copy allows to import and export of rows limited to 50 rows of a single table (sheet). Upon start of a program based on qtXLS there will be a message informing about this limitation.
(2) The Adobe Acrobat Reader (to read documents in PDF format) can be found here.

The evaluation copy can be changed into a version without limitation (1) by purchase of a qtXLS licence.
The licence allows you to use the qtXLS software for the development of programs, i.e. to create executable files (.exe). In addition, the licence covers the right to pass on the qtXLS.dll or qtXLS64.dll, respectively, which contains the main qtXLS functionality. This means, there are no royalty or run-time fees to pay.

We deliver the licence by sending a licence file via eMail (no shipping costs apply). The licence file contains the data specified by you (for example, name and address), a licence number and a licence key.


System Requirements

To be able to use the qtXLS software, the following is required::

  • PC, hard disk with at least 15 MB memory available, a minimum of 32 MB RAM.
  • one of the following operating systems: Microsoft Windows XP or higher and compatible.

qtXLS is based on Microsoft Excel ODBC drivers. At installation of Excel these are usually installed. If these drivers are missing, they are either supplied by installation of Microsoft Excel or by installation of the

Microsoft Data Access Components (MDAC)

This is probably the cheaper alternative, because the MDAC can be downloaded for free from Microsoft's WebSite. If the link above doesn't help you to find them, try the search function in Microsoft's "Download Center”.
Of course, besides the above a compiler system is needed (see the list of supported compilers above).


Download Delivery and ESD Electronic Software Delivery:
We send a download link, which allows to download the software (incl. documentation). And we deliver a serial number or a license key and if applicable, an installation code.
In case you order support (maintenance), you will obtain the eligibility to download the most recent version of the software for the support period (usually 1 year) and to use it.
Educational License: This license type is available only to educational institutions (schools, colleges, universities). They may not be used for commercial purposes.
Academic License: This license type is available only to academic non-profit organisations (e.g. governmental research institutions). They may not be used for commercial purposes.
Commercial License: Commercial licenses permit a commercial use.
Lizensing: If not specified something else, the software is available only as a single user license for a named user (no networ or multi-user licenses available).

Tags Variant Selection of qtXLS Write Product Review
You have to be logged in to write a review.
No review available for this item.
Current product qtXLS qtXLS
Art.No.: QTXLS  
Library for Excel Data Im- & Export
from 177,31 €*