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"
23 GtkListStore * list_store = gtk_list_store_new (2, G_TYPE_INT, G_TYPE_STRING);
25 for (i = 0; i < N; ++i)
27 gtk_list_store_append (list_store, &iter);
28 gtk_list_store_set (list_store, &iter,
37 struct spreadsheet *sp = NULL;
41 on_clicked (GtkButton *button, gpointer data)
44 gint x = gtk_combo_box_get_active (GTK_COMBO_BOX (combo_box));
45 struct casereader *reader ;
46 struct spreadsheet_read_info ri;
47 struct spreadsheet_read_options opts;
49 g_print( "%s %d\n", __FUNCTION__, x);
51 opts.sheet_index = x + 1;
52 opts.cell_range = NULL;
53 opts.sheet_name = NULL;
58 reader = gnumeric_make_reader (sp, &ri, &opts);
60 (c = casereader_read (reader)) != NULL; case_unref (c))
62 const double val = case_data_idx (c, 0)->f;
68 main (int argc, char *argv[] )
78 gtk_init (&argc, &argv);
81 g_error ("Usage: prog file\n");
83 sp = gnumeric_probe (argv[1]);
87 g_error ("%s is not a gnumeric file\n", argv[1]);
91 tm = psppire_spreadsheet_model_new (sp);
92 window = gtk_window_new (GTK_WINDOW_TOPLEVEL);
93 hbox = gtk_hbox_new (FALSE, 5);
94 vbox = gtk_vbox_new (FALSE, 5);
96 button = gtk_button_new_with_label ("Test reader");
97 g_signal_connect (button, "clicked", G_CALLBACK (on_clicked), NULL);
99 gtk_container_set_border_width (GTK_CONTAINER (window), 10);
101 combo_box = gtk_combo_box_new();
104 GtkCellRenderer *renderer = gtk_cell_renderer_text_new ();
105 gtk_cell_layout_pack_start (GTK_CELL_LAYOUT (combo_box), renderer, TRUE);
106 gtk_cell_layout_set_attributes (GTK_CELL_LAYOUT (combo_box), renderer,
111 gtk_combo_box_set_model (GTK_COMBO_BOX (combo_box), tm);
113 gtk_combo_box_set_active (GTK_COMBO_BOX (combo_box), 0);
115 treeview = gtk_tree_view_new_with_model (tm);
117 gtk_tree_view_insert_column_with_attributes (GTK_TREE_VIEW (treeview),
119 gtk_cell_renderer_text_new (),
124 gtk_tree_view_insert_column_with_attributes (GTK_TREE_VIEW (treeview),
126 gtk_cell_renderer_text_new (),
131 gtk_box_pack_start (GTK_BOX (hbox), treeview, TRUE, TRUE, 5);
133 gtk_box_pack_start (GTK_BOX (vbox), combo_box, FALSE, FALSE, 5);
134 gtk_box_pack_start (GTK_BOX (vbox), button, FALSE, FALSE, 5);
135 gtk_box_pack_start (GTK_BOX (hbox), vbox, TRUE, TRUE, 5);
137 gtk_container_add (GTK_CONTAINER (window), hbox);
139 g_signal_connect (window, "destroy", gtk_main_quit, 0);
141 gtk_widget_show_all (window);
145 gnumeric_destroy (sp);