7 #include "psppire-spreadsheet-model.h"
9 #include "data/gnumeric-reader.h"
10 #include "data/spreadsheet-reader.h"
11 #include "data/casereader.h"
12 #include "data/case.h"
22 GtkListStore * list_store = gtk_list_store_new (2, G_TYPE_INT, G_TYPE_STRING);
24 for (i = 0; i < N; ++i)
26 gtk_list_store_append (list_store, &iter);
27 gtk_list_store_set (list_store, &iter,
36 struct spreadsheet *sp = NULL;
40 on_clicked (GtkButton *button, gpointer data)
43 gint x = gtk_combo_box_get_active (GTK_COMBO_BOX (combo_box));
44 struct casereader *reader ;
45 struct spreadsheet_read_info ri;
46 struct spreadsheet_read_options opts;
48 g_print( "%s %d\n", __FUNCTION__, x);
50 opts.sheet_index = x + 1;
51 opts.cell_range = NULL;
52 opts.sheet_name = NULL;
57 reader = gnumeric_make_reader (sp, &ri, &opts);
59 (c = casereader_read (reader)) != NULL; case_unref (c))
61 const double val = case_data_idx (c, 0)->f;
67 main (int argc, char *argv[] )
77 gtk_init (&argc, &argv);
80 g_error ("Usage: prog file\n");
82 sp = gnumeric_probe (argv[1]);
86 g_error ("%s is not a gnumeric file\n", argv[1]);
90 tm = psppire_spreadsheet_model_new (sp);
91 window = gtk_window_new (GTK_WINDOW_TOPLEVEL);
92 hbox = gtk_hbox_new (FALSE, 5);
93 vbox = gtk_vbox_new (FALSE, 5);
95 button = gtk_button_new_with_label ("Test reader");
96 g_signal_connect (button, "clicked", G_CALLBACK (on_clicked), NULL);
98 gtk_container_set_border_width (GTK_CONTAINER (window), 10);
100 combo_box = gtk_combo_box_new();
103 GtkCellRenderer *renderer = gtk_cell_renderer_text_new ();
104 gtk_cell_layout_pack_start (GTK_CELL_LAYOUT (combo_box), renderer, TRUE);
105 gtk_cell_layout_set_attributes (GTK_CELL_LAYOUT (combo_box), renderer,
110 gtk_combo_box_set_model (GTK_COMBO_BOX (combo_box), tm);
112 gtk_combo_box_set_active (GTK_COMBO_BOX (combo_box), 0);
114 treeview = gtk_tree_view_new_with_model (tm);
116 gtk_tree_view_insert_column_with_attributes (GTK_TREE_VIEW (treeview),
118 gtk_cell_renderer_text_new (),
123 gtk_tree_view_insert_column_with_attributes (GTK_TREE_VIEW (treeview),
125 gtk_cell_renderer_text_new (),
130 gtk_box_pack_start (GTK_BOX (hbox), treeview, TRUE, TRUE, 5);
132 gtk_box_pack_start (GTK_BOX (vbox), combo_box, FALSE, FALSE, 5);
133 gtk_box_pack_start (GTK_BOX (vbox), button, FALSE, FALSE, 5);
134 gtk_box_pack_start (GTK_BOX (hbox), vbox, TRUE, TRUE, 5);
136 gtk_container_add (GTK_CONTAINER (window), hbox);
138 g_signal_connect (window, "destroy", gtk_main_quit, 0);
140 gtk_widget_show_all (window);
144 gnumeric_destroy (sp);