An object model similar to the MS Excel object model was created in litXLS.
It make the development easy and it keeps the learning curve small for developers who already know the Excel object model.
litXLS fully supports VB's intellisense that gives the programmer
help while creating the code. Care is taken to make working with
litXLS as easy as possible. Should programmers need to refer to a
full API description, we have written a full specification for
view the litXLS API documentation
With a few lines of code you
can instantiate the component. Most of the work will be done in litXLS's Worksheet object where you use the Cells
property to access the cells on the sheet. Putting values in the sheet is as simpel as the following command shows:
When you have populated all the cells, you call the Workbook.SaveAs method. The new .xls file
Sample projects are supplied with litXLS. Detailed examples are provided
in the Visual Basic language (version 6), in VBS script and in VB.Net. It is perfectly possible to use the component
in other development languages. Check the documentation that came with your development language whether you can
use ActiveX dlls to find out whether you can use the litXLS component.
litXLS can be tried out before you buy it. When using the evaluation copy you can only populate cells in row
5. If a fully working trial version is required, please let us know.
As an example of how easy it is to create a .xls file with litXLS consider the following VB code that will create
the file test.xls with the table of 7.
Dim wkb as litXLS.Workbook
Dim wks as litXLS.Worksheet
Dim xls as litXLS.clsXLS
Dim lngLoop as Long
Set xls = New litXLS.clsXLS
'Create a new workbook and a new worksheet
Set wkb =
Set wks =
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.