English Italiano

Let's make your life Easy...

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).

http://Scarica Trial/Demo  Scaricato: 9922

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

  • CHM

Install Type

  • Install Executable

Categories

Programming Languages
     Clarion
Programming
     Components & Libraries
        Data Conversion
        Database Reporting
        Development
        Office automation
        Spreadsheet

Novità



06/12/2001

New demo application available for EasyExcel 1.02!
New demo application available for EasyExcel 1.02!
06/12/2001

EasyExcel ver 1.02 released !!!
EasyExcel ver 1.02 released !!!

What's new:
Bug fixes:
  • Include bug fixes from the patch to ver. 1.01 (This patch fix a bug in the libraries, that cause incorrect work with the big cells ranges)
  • Fixed a SetDubugMode bug, so in debug mode will show the EasyExcel library error messages.
  • Fixed columns range selection bug.

New methods:
  • GetRange - get data from the selected range of cells into a queue
  • SelectUsedRange - select "used" (filled) range in a sheet
  • SetCellWidth - no comments
  • SetRowHeight - no comments
  • GetRow - get data from row cells into GROUP or file RECORD
  • SetTextWrap - set cell's text wrap mode
  • SetHorizAlign - set horizontal cell's text justification
  • SetVertAlign - set vertical cell's text justification
  • SelectEnd - select and return a position of last cell in a filled range

New code templates:
  • Set Cells alignment - set cells dimensions and text alignment
  • Select last cell - select and return a position of last cell in a filled range
  • Get Range - get data from the selected range of cells into a queue

Changed methods and templates:
  • SelectRange code template - added SelectUsedRange
  • AutoFit method - added AutoFit modes parameter
14/11/2001

EasyExcel Version 1.01.1 (patch) released!

This package includes a patch for EasyExcel Class Libraries and Code Templates. This patch will fix a bug in the libraries, that cause incorrect work with the big cells ranges. This patch requires that you have installed EasyExcel ver. 1.01.
17/09/2001

EasyExcel Class and Templates ver 1.01 released! More powerful and more easy!
EasyExcel Class and Templates ver 1.01 released! More powerful and more easy!
It includes some minor bug fixes and new features listed below:

  • Extended cell formats. Now you can set such cells format as General, Numeric and Money (according to locale settings), Text directly from class methods or from templates simply by selecting an appropriate radio-button.
  • Switching data transfer between TEXT or Unicode (important for data export in local languages).
  • Passing data "As Is" (fixed problem with passing some special strings such as '1-1', '3/4', '010' etc. (Excel consider such data not as strings, but as date, numeric or whatever format and internally formats them with unpredictable result).
  • Ability to select or create a new sheet within an Excel workbook for data export/import.
  • Ability to rename a sheet.

Registered users of previous version of EasyExcel can receive new version certainly free.
21/08/2001

In the near future there will be the next EasyExcel release 1.01
In the near future there will be the next EasyExcel release 1.01. It will include some minor bug fixes and new features listed below:
  • Extended cell formats. Now you can set such cells format as General, Numeric and Money (according to locale settings), Text directly from class methods or from templates simply by checking radio-button.
  • Data transfer as TEXT or Unicode (important for data export in local languages).
  • Passing data "AsIs" (fixed problem with passing some special strings such as '1-1', '3/4', '010' etc. Excel consider such data not as strings, but data, numeric or whatever format and internally formats them with unpredictable result).
  • Ability to select a sheet within an Excel workbook for data export/import.
  • DLLs and LIBs will be compatible with C5.5E release.

PS. This list can be extended in the final release.

Registered users of previous version of EasyExcel can receive new version certainly free.
14/06/2001

Original 1-st release of EasyExcel
Original 1-st release of EasyExcel

Prodotto

Have you ever dreamt to export or import your data from your Clarion application to Excel in 1 minute?

Condividi

Compria ora!

IngasoftPlus's products are available at www.motleysoft.com - the world softfair! Compria ora!
da  59000000.0

Download Information

The following downloads are available for this products:
  • Demo (free)
  • Setups (password protected)
  • Setups (password protected) - old

Vai a scaricare

Ricerca Prodotti