LibXL for Windows 3.8.6 Retail with Serial Key
Developer.Team » Misc. Development » LibXL for Windows 3.8.6 Retail
Home

LibXL for Windows 3.8.6 Retail

LibXL for Windows 3.8.6 Retail
LibXL for Windows 3.8.6 Retail


LibXL is a library that can read and write Excel files. It doesn't require Microsoft Excel and .NET framework, combines an easy to use and powerful features. Library can be used to

Generate a new spreadsheet from scratch
Extract data from an existing spreadsheet
Edit an existing spreadsheet

LibXL can help your applications in exporting and extracting data to/from Excel files with minimum effort. Also it can be used as report engine. Library can be used in C, C++, C#, Delphi, Fortran and other languages. Supports Excel 97-2003 binary formats (xls) and Excel 2007-2013 xml formats (xlsx/xlsm). Supports Unicode and 64-bit platforms. There are a wrapper for .NET developers and separate Linux, Mac and iOS editions. See features of the library in demo.xls or demo.xlsx files.

Simple interoperate, no more Excel dependency
LibXL has C/C++ headers, Delphi unit and .NET assembly for including in your project. No OLE automation.

Customizing the look and feel
LibXL supports numerous formatting options: alignments, borders, colors, fill patterns, fonts, merging cells and so on.

High performance
Writing speed is about 2 100 000 cells per second for numbers and 240 000 cells per second for 8-character random strings in binary xls format (CPU 3.2 GHz).

Royalty-free distribution with your application
Our customers can use this library in theirs commercial applications without any fees.

Version 3.8.6 (2019-10-21)
added support of new formula functions in Excel for Office 365 / Excel 2019 (xlsx)
added new properties for the Sheet::setPicture() method:
scale > 0 - the picture is aligned to the left top corner of the cell or merged area with the specified scale factor
scale = 0 - the picture is stretched inside the specified cell or merged area
scale < 0 - the picture is aligned to the center of the cell or merged area with the specified scale factor
added Sheet::rowHeightPx() and Sheet::colWidthPx() methods
Sheet::firstRow(), Sheet::lastRow(), Sheet::firstCol() and Sheet::lastCol() methods ignore blank cells now
added parial support of formula arrays for xlsx files, for example now the Sheet::writeFormula() can accept {=SUM(A2:F2)} value
added a change of AutoFilter position together with Sheet::insertRow(), Sheet::removeRow(), Sheet::insertCol(), Sheet::removeCol() methods (xlsx)
fixed autofit feature for non-standard Windows scaling (High DPI)
fixed a bug in the Book::load() method for using a path with drive part for temporary file (xlsx)
fixed some bugs with loading some xls and xlsx files
fixed a bug in the Sheet::getNamedRange() when a xls file is parially loaded by the Book::loadSheet() method (xls)
fixed bugs in Sheet::removeRow() and Sheet::removeCol() methods when row or column contains merged cells
fixed a bug with crash in the Book::addFormat() when workbook is xlsx and initFormat is from xls file
fixed a bug with saving workbook with complicated OfficeArt objects (xls)
fixed a bug in Sheet::setPicture2() with default width/height (-1,-1) for some Excel versions and LibreOffice
fixed a bug in Sheet::setAutoFitArea() with default parameters for xls files
New methods:
Sheet::colWidthPx()
Sheet::rowHeightPx()


Code example: generate a new spreadsheet from scratch
class Program
{ 
    static void Main(string[] args)
    {
        try 
        {
            Book book = new BinBook(); // use XmlBook() for xlsx
            Sheet sheet = book.addSheet("Sheet1");
            sheet.writeStr(2, 1, "Hello, World !");
            sheet.writeNum(3, 1, 1000);
            book.save("example.xls");    
        }
        catch (System.Exception e)
        {
            Console.WriteLine(e.Message);
        }
    }
}


Only for V.I.P
Warning! You are not allowed to view this text.
Misc. Development