php-gtk2 Cookbook: How to use GtkSheet - Part 3 - set values?

Google's new CSE Search

PHP-GTK2 eBooks

Main Menu

Home

Sample Codes

List all sample codes

Browse all sample codes

RSS Feed (PHP-GTK2)

Joomla Samples Menu

Links

link1
link2
link3
link4
link5

PHP-GTK2 Newsletter

PHP-GTK2 Tips & Techniques
FREE Newsletter
by kksou

Your privacy is respected.

Sample Code 248: How to use GtkSheet - Part 3 - set values?

Written by kksou

Monday, 04 June 2007

Problem

You have displayed a 2D array in a GtkTable in How to display a 2D array in table - Part 1?.

You have also displayed a 2D array in a GtkTreeView in How to display a 2D array in GtkTreeView - Part 1?.

Now you would like to display the 2D array in a GtkSheet as shown below:

How to use GtkSheet - Part 3 - set values?

Solution

Make sure your version of PHP-GTK2 has the GtkExtra library, and the feature turned on in php.ini. (See notes below.)
Create the spreadsheet as outlined in How to use GtkSheet - Part 1 - create the spreadsheet?
Set the value of a cell with GtkSheet::set_cell_text($row, $col, $value)

Important Note: This only works for PHP-GTK2 compliled with the additional library GtkExtra. For linux, you can download the files from http://gtkextra.sourceforge.net/ and do a recompile. For windows, you may use the builds by Elizabeth Smith or the official php-gtk2 beta release available at http://gtk.php.net/download.php. Both contain all the required gtkextra libraries and dll's. In the php.ini, don't forget to add php-gtk.extensions = php_gtk_extra2.dll to turn on GtkExtra.

Sample Code

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

<?php
$window = new GtkWindow();
$window->set_title($argv[0]);
$window->set_size_request(400, 250);
$window->connect_simple('destroy', array('Gtk','main_quit'));
$window->add($vbox = new GtkVBox());

// display title
$title = new GtkLabel("Using GtkSheet\n".
"Part 3 - Display 2D Array in GtkSheet");
$title->modify_font(new PangoFontDescription("Times New Roman Italic 10"));
$title->modify_fg(Gtk::STATE_NORMAL, GdkColor::parse("#0000ff"));
$title->set_size_request(-1, 40);
$title->set_justify(Gtk::JUSTIFY_CENTER);
$alignment = new GtkAlignment(0.5, 0, 0, 0);
$alignment->add($title);
$vbox->pack_start($alignment, 0, 0);
$vbox->pack_start(new GtkLabel(), 0, 0);

// the 2D table
$data = array( // note 1
array('row0', 'item 42', 2, 3.1),
array('row1', 'item 36', 20, 6.21),
array('row2', 'item 21', 8, 9.36),
array('row3', 'item 10', 11, 12.4),
array('row4', 'item 7', 5, 15.5),
array('row5', 'item 4', 17, 18.6),
array('row6', 'item 3', 20, 21.73));

display_table($vbox, $data);

$window->show_all();
Gtk::main();

function display_table($vbox, $data) {

$scrolled_win = new GtkScrolledWindow();

Note that this is only 70% of the sample code. You have to be a registered member to see the entire sample code. Please login or register.
Registration is free and immediate.
Have some doubt about the registration? Please read this forum article.

Explanation

The 2D data.
Set the value of a cell in GtkSheet.

Add comment

JComments

< Prev		Next >

[ Back ]