News

08-May-2008

OLE XLSFile v.4.0.

  • Formula's parser and compiler modules support references to external workbooks, and named areas from local and external workbooks.
  • Images of PNG format now can be inserted into sheets.
  • Cell validation rules added.

 

05-May-2008

TXLSFile v.4.0.

  • Formula's parser and compiler modules support references to external workbooks, and named areas from local and external workbooks.
  • Images of PNG format now can be inserted into sheets.
  • Cell validation rules added.

 

30-Mar-2008

OLE XLSFile v.4.0.

  • Protection methods added for sheets, workbooks, and files.
  • Overall performance improved by 50%.

 

07-Mar-2008

TXLSFile v.4.0.

  • Workbook's protection methods added to TWorkbook class.
  • File's protection methods added to TXLSFile class.

 

25-Feb-2008

TXLSFile v.4.0.

  • Sheet's protection methods added to TSheet class.
  • Cells' copy, move, insert methods improved.

 

17-Aug-2007

TXLSFile v.4.0. source code is compatible with Delphi 2007.

 

01-Feb-2007

TXLSFile v.4.0., OLE XLSFile v.4.0. Minor bugs fixed in default cells' formatting.

 

24-Nov-2006

TXLSFile v.4.0. All limitations removed in demo version. You may use a fully-functional demo version with Borland Delphi IDE running.

 

30-Sep-2006

OLEXLSFile v.4.0. AutoFit methods added to fit columns.

 

07-Sep-2006

TXLSFile v.4.0.

  • AutoFit methods added to fit columns.
  • Minor bugs fixed.

 

09-Aug-2006

TXLSFile v.4.0. source code is compatible with Delphi 2006 (Win32).

 

17-Jun-2006

XLS files produced by OLE XLSFile v.4.0 and TXLSFile v.4.0 now may be opened in OpenOffice.

 

09-May-2006

New version: OLE XLSFile v.4.0 released.

  • Now it is possible to read formulas.
  • Formatting of substrings in text values added.
  • Now it is possible to set format and font properties directly to Row and Column, while in earlier versions only Cell and Range may be formatted.
  • Writing of logical functions in formulas added.
  • Writing of cross-sheet references in formulas added.

 

21-Jan-2006

New version: TXLSFile v.4.0 released.

  • Now it is possible to read formulas.
  • Sheets' names now support Unicode values.
  • Formatting of substrings in text values added.
  • Product's documentation is refined, syntax is highlighted in code samples.

 

24-Jul-2005

TXLSFile v.3.1

  • Now it is possible to set format and font properties directly to Row and Column, while in earlier versions only Cell and Range may be formatted.
  • Writing of logical functions in formulas added.
  • Writing of cross-sheet references in formulas added.

 

16-Dec-2004

TXLSFile v.3.1

  • Reading of custom numeric formats added.
  • Reading of a last saved formula's value added.

 

16-Dec-2004

OLE XLSFile v.3.1

  • Memory usage reduced about 2 times.
  • Reading of custom numeric formats added.
  • Reading of a last saved formula's value added.

 

31-Oct-2004

TXLSFile v.3.1 Memory usage optimized.

 

26-Jul-2004

TXLSFile v.3.1 Memory consumption have been reduced by 25%.

 

03-May-2004

OLE XLSFile v.3.1: new features added.

  • Now sheet data may be saved to HTML, TXT file.
  • Copy and delete methods added to sheets collection.
  • New useful methods added to clear, copy, move, delete, insert cells, rows, and columns.

 

16-Mar-2004

TXLSFile v.3.1: new features added.

  • Now sheet data may be saved to HTML, TXT file or stream.
  • Copy and delete methods added to sheets collection.

 

25-Jan-2004

TXLSFile v.3.1: new useful methods to clear, copy, move, delete, insert cells, rows, and columns.

 

07-Jan-2004

New version: OLE XLSFile v.3.1 released.

  • Memory consumption is reduced. Now reading and writing are even faster.
  • Unicode values processing improved.
  • Some memory freeing errors fixed.

 

20-Dec-2003

New version: TXLSFile v.3.1 released.

  • Memory consumption is reduced significantly. Now reading and writing are even faster.
  • Now you can read and write WideString (Unicode) cell values.
  • Some memory freeing errors fixed.

 

02-Sep-2003

New version: OLE XLSFile v.3.0 released. All TXLSFile v.3.0. Delphi library features now available in OLE XLSFile v.3.0 OLE library.
Now you can also read data from Excel files. With v.3.0 you can read the following Excel file elements:

  • strings (Unicode strings supported), numbers, dates
  • cell colors, borders, font styles
  • cell alignment, text rotation
  • row heights and column widths
  • cell formats (e.g. #00.00, yy/mm/dd etc.)
  • merged cells.

 

22-Jul-2003

TXLSFile v.3.0: rows and columns grouping added

 

12-May-2003

TXLSFile v.3.0: merged cells reading added

 

03-Apr-2003

New version: TXLSFile v.3.0 released. Now you can also read data from Excel files. With v.3.0 you can:

  • read strings (Unicode strings supported), numbers, dates
  • read cell colors, borders, font styles
  • read cell alignment, text rotation
  • read row heights and column widths
  • read cell formats (e.g. #00.00, yy/mm/dd etc.).

 

12-Feb-2003

TXLSFile v.2.1 now available for Delphi 7

 

11-Jan-2003

We are moved to new domain sm-software.com

 

03-Jan-2003

New version: TXLSFile v.2.1 released. New features:

  • Now you can insert images into Excel workbooks (supported formats are BMP and JPEG).
  • With sheet window options you can show/hide grids, show/hide row and column headers, show/hide zero values.
  • You can insert hyperlinks into the worksheet.
  • A paper size can be specified in page setup options.
  • A bug with limited count of merged ranges now fixed. You can create so much merged ranges as you need.

 

30-Dec-2002

We are Borland Technology Partner.

 

24-Nov-2002

New version: XLSExport v.1.1 released. New features:

  • New XLSExportFile component provides access to Workbook object. Now you can export grids and datasets using XLSExport components, and working with the same workbook using TXLSFile library objects.
  • OnSaveFooter event added to TXLSExportDBGrid, TXLSExportDataSource components. Now you can add totals row after dataset export.
  • Options property added to TXLSExportDBGrid, TXLSExportDataSource components. Now it contains eoptVisibleOnly option, and you can use it to export only visible dataset columns.

 

25-Sep-2002

New version: OLE XLSFile v.2.0 released. Now all new features of TXLSFile v.2.0 also available for OLE XLSFile.

 

19-Sep-2002

Demo version of TXLSFile v.2.0 and XLSExport v.1.0 now contains demo DCU files. With demo version you can test all TXLSFile features, but you can not write more than 100 cells on each Excel worksheet.
Install library and components, and try them in your application.

 

12-Aug-2002

New version: TXLSFile v.2.0 released. New features:

  • You can use ranges for batch cells operations
  • Now you can specify built-in or create custom format string (e.g. '#,##0.00') for cell or range value
  • You can use A1-cell reference style (e.g. 'A1', 'AA100') when refer cell in a sheet
  • You can use PageSetup object to specify page setup options for a sheet and to specify a print area.
  • Now columns widths and rows heights can be specified in pixels
  • Now colors for cell and range background and foreground, borders, and font can be specified also as RGB colors
  • You can merge cells to create more attractive reports
  • You can create named areas
  • You can use formulas for cell or range
  • Minor bug with borders fixed. Now single and outline borders work correctly.

 

©SM Software, 2000-2008