EasyExcel - 4.08

Have you ever dream to export or import your data to Excel in 1 minute?

EasyExcel is a Class and a set of Templates, providing you with the ability to:

Create a new sheet and name it,
Delete a range of cells (or row, or column),
Draw a box around a range of cells,
Create a table,
Search a range of cells for a text string,
Retrieve Excel properties,
Fill a Clarion queue with a selected range of cells,
Export a Clarion queue to a workbook starting at a user selectable position,
Merge a range of cells together,
Print the currently open Excel sheet,
Find and replace operation on a range of cells,
Save the current Excel sheet,
Turn screen updating on or off to speed up data exporting,
Find a free cell after a range of cells,
Set the alignment for a range of cells,
Set the background color for a range of cells,
Set the font for a range of cells,
Set the data format for a range of cells,
Set cell width for a range of cells, Set row height for a range of cells,
Set text wrapping for a range of cells,
Set vertical alignment for a range of cells,
Assign an Excel property value,
Auto fit columns and cells,
Convert a Clarion date to an Excel recognized date,
Convert Clarion time to Excel recognized time,
Insert row or column,
Create a page footer,
Create a page header,
Set paper size, Set printing zoom,
Run an Excel macro,
Import your data,
Create a charts
Conditional Format template - sets conditional format for a range of cells
and do much more in Excel from your Clarion application!

These templates and methods allows the programmer to manipulate data on both sides. Data can be read from the Excel sheet, modified, and then written back to the sheet, formulas can be added to the sheet, macros can be added and executed.

This release is the first EasyExcel release, that uses COM technology, so you receive now a full control over Microsoft Excel.

EasyExcel supports all Excel version that support COM automation (NOT starter, student or home version).

You'll get libraries (LIBs and DLLs), templates, examples and complete documentation for the class and templates (CHM file).

Scarica Trial/Demo Scaricato: 9921

Product Screenshots

Product Compatibility

Operating System for Deployment

Windows 2000
Windows 7
Windows 8
Windows 98
Windows ME
Windows NT
Windows NT 4.0
Windows Server 2003
Windows Server 2008
Windows Vista Business
Windows Vista Enterprise
Windows Vista Home Basic
Windows Vista Home Premium
Windows Vista Starter
Windows Vista Ultimate
Windows XP

Architecture of Product

32Bit

Product Type

Add-In

Component Type

DLL
LIB
Template ABC
Template Legacy

Compatible Containers

Microsoft Office 2000
Microsoft Office 2003
Microsoft Office 2007
Microsoft Office 97
SoftVelocity Clarion 10.0
SoftVelocity Clarion 11.0
SoftVelocity Clarion 11.1
SoftVelocity Clarion 6.3
SoftVelocity Clarion 9.0

Documentation

Install Type

Install Executable

Novità

2022 2013 2011 2010 2007 2006 2001

04/05/2011	EasyExcel ver 4.06 - Clarion8-aware setup available.	EasyExcel
	Clarion8-aware setup available for EasyExcel 4.06..
13/04/2011	EasyExcel ver 4.06 released!	EasyExcel
	Libraries were recompiled for CW 7.3 (7995) Added Header/Footer format codes description into EasyExcel documentation, to insert special objects (date, page number etc.) Bug fixes SheetVisible - fixed a bug with unhiding sheets (parameter was changed from BYTE to SHORT). MoveSheet - hang in Excel 2007 and higher (if Excel language doesn't match Windows locale). CopySheet - hang in Excel 2007 and higher (if Excel language doesn't match Windows locale). List2Excel method - was an error in setting formats in Excel List2Excel code template - removed "duplicate variable" error SetPageAlign - error setiing margins in measure units, other then centimetres New methods EnableEvents - enables/disables event generation in Excel. SetFormula - sets cell's formula using A1 notation SetPageHeadFootProps - sets different options for headers/footers SetPageHeaderPict - sets page header picture SetPageFooterPict - sets page footer picture GetIntl - gets different localization parameters to be used in format strings SetRangeFilter - filters previously selected range ShrinkToFit - causes text in selected range to automatically shrink ViewMode - returns or sets the view showing in the window Changed methods SetFormat - added CellFormat:Percent equate to set "percent" format of selected range ColumnWidth - ColWidth parameter type was changed from LONG to REAL and added pMeasureUnit parameter: you can set column width now in different measure units SelectRange - if all parameters are omitted, the whole sheet will be selected SetColour - pIsColourIndex parameter was added RowHeight - added pMeasureUnit parameter: you can set row height now in different measure units New templates Set Range Filter code template - set custom filter ot unique values on a previously selected range Sort Range code template - sorts currently selected range. Changed templates SetFormat code template - added "Percent" format SetColour code template - added Colour index check-box Select Range code template - added range addressing and autofit options SetPageAlign code template - you can set margins now in inches also Set Cells alignment code template - added measure units and shrink to fit options Free upgrade for all customers who have a current (valid) subscription plan.

Let's make your life Easy...

EasyExcel - 4.08

Product Screenshots

Product Compatibility

Operating System for Deployment

Architecture of Product

Product Type

Component Type

Compatible Containers

Documentation

Install Type

Categories

Novità

EasyExcel ver 4.06 - Clarion8-aware setup available.

EasyExcel ver 4.06 released!

Prodotto

Condividi

Compria ora!

Download Information

Ricerca Prodotti