Welcome to the homepage of
if you are interessted in our
which allows you to run SQL-queries against textfiles/logfiles/.txt/.csv ...
if you are interessted in our
which allow you access Hardware/Networking and WMI functions under RealBASIC...
if you are interessted in our tool
that allows VBScript developers to use include files in their VBS
xListbox is a Realbasic listbox class.
It features the following capabilities :
Sort columns by date, number, text
Multiple Column Sorting
run SQL queries against a listbox creating recordsets
copy recordsets to a listbox
read & save a listbox content from / to a TXT/CSV file
read & save a listbox content from / a to .RSD (Sqlite)
Toggle alternating rowcolors during runtime
set attributes like color, bold, italic per cell based
on a cellís content
export a listbox to MS Excel 2000/2003 (under Windows
//add some data to a xListbox (without heading)
// - set type of data in columns of the xListbox
// - Do some conditional formatting of the columns
// - Do a sort for each column (Button click)
//add some data to the xlistbox
//set column types
//Conditional formatting of cells / rows:
//red cell backgroundcolor if the number in a cell is <= 0 - else green for all
//green cell forecolor for all dates between 25/11/1966 and 10/01/2009 - else
xListbox1.xSetColumnFormat 2,"between","19661125 20090110","green","blue","Cell"
//blue cell backgroundcolor if the text in a cell is "Peter" (else no action)
//sort column 1 (first column) based on its
columnType (as previously set using xSetColumnType)
The above sample code will create the following listbox :
The xListbox can be sorted using a header-click
Some screenshots of the the Demo-Project that comes with the download :
- Negative numeric values in column "Session" have a red cell
- if Status is "Disconnected" then the cell has a red
backgroundcolor - else green
- if the Current Date is between 2000 and 2001 then set the cell to blue
The xListbox can be sorted using a
SQL queries can be run against a xListbox. For example: Run a SQL-Query selecting all Users "BRAIN"
from xListbox1 and display result in a new
In the new listbox set the rowcolor to red backgroundcolor if Session is <
0 - else set green row backgroundcolor
The x Listbox can be sorted using a header-click
Download the xListbox class including a demo-project.
xListbox was developed and tested under windows, but it should run
under MAC, too (except MS Excel export which will not work on a MAC)
Download xListbox v 1.2
After the download has finished you can start the REALBasic Demo-Project.
Use the "Load CSV" Button to load the "SampleData1.csv" file into the
- xListbox is free for private usage. You will find informations about how
to use xListbox in the sourcecode of the demo-project.
- If you use xListbox in commercial projects or would like to have some
documentation and email-support please buy a licence.
If you buy a licence of xListbox you will receive:
- email support : info@Scout-Soft.com
- a documentation file of all xListbox methods (PDF, 10 pages)
- 2 small sample RB-projects showing the basic methods of the class (adding
data, conditional coloring, sorting)
to process your order
25 Euro for xListbox
All prices are plus
local TAX / VAT
(C) 2008, 2009 www.Scout-Soft.com