X-Git-Url: https://pintos-os.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=src%2Fdata%2Fspreadsheet-reader.h;h=d7783bab7fdf12eb88ae6697e6c12ffd987370d5;hb=2bf186a3ffb77c2706223d24bad200cb3148cc8a;hp=c03cf71642135f0ef12331e247a4fe44d58fb9a7;hpb=df2866a475d36298a14cc1e97c6118e088ac85da;p=pspp diff --git a/src/data/spreadsheet-reader.h b/src/data/spreadsheet-reader.h index c03cf71642..d7783bab7f 100644 --- a/src/data/spreadsheet-reader.h +++ b/src/data/spreadsheet-reader.h @@ -1,5 +1,5 @@ /* PSPP - a program for statistical analysis. - Copyright (C) 2007, 2010 Free Software Foundation, Inc. + Copyright (C) 2007, 2010, 2016 Free Software Foundation, Inc. This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -18,6 +18,7 @@ #define SPREADSHEET_READ_H 1 #include +#include struct casereeader; @@ -31,7 +32,8 @@ struct casereeader; struct spreadsheet_read_options { char *sheet_name ; /* The name of the sheet to open (in UTF-8) */ - int sheet_index ; /* The index of the sheet to open (only used if sheet_name is NULL) */ + int sheet_index ; /* The index of the sheet to open (only used if sheet_name is NULL). + The first index is 1 NOT 0 */ char *cell_range ; /* The cell range (in UTF-8) */ bool read_names ; /* True if the first row is to be used as the names of the variables */ int asw ; /* The width of string variables in the created dictionary */ @@ -49,44 +51,74 @@ bool convert_cell_ref (const char *ref, #define _xmlchar_to_int(X) ((X) ? atoi (CHAR_CAST (const char *, (X))) : -1) -enum spreadsheet_type - { - SPREADSHEET_NONE, - SPREADSHEET_GNUMERIC, - SPREADSHEET_ODS - }; - +struct sheet_detail +{ + /* The name of the sheet (utf8 encoding) */ + char *name; + + /* The extents of the sheet. */ + int first_col; + int last_col; + int first_row; + int last_row; +}; struct spreadsheet { + /** General spreadsheet object related things. */ + int ref_cnt; + + /* A 3 letter string (null terminated) which identifies the type of + spreadsheet (eg: "ODS" for opendocument; "GNM" for gnumeric etc). */ + char type[4]; + + void (*destroy) (struct spreadsheet *); + struct casereader* (*make_reader) (struct spreadsheet *, + const struct spreadsheet_read_options *); + const char * (*get_sheet_name) (struct spreadsheet *, int); + char * (*get_sheet_range) (struct spreadsheet *, int); + int (*get_sheet_n_sheets) (struct spreadsheet *); + unsigned int (*get_sheet_n_rows) (struct spreadsheet *, int); + unsigned int (*get_sheet_n_columns) (struct spreadsheet *, int); + char * (*get_sheet_cell) (struct spreadsheet *, int , int , int); + char *file_name; - enum spreadsheet_type type; + struct sheet_detail *sheets; - /* The total number of sheets in the "workbook" */ - int n_sheets; - /* The dictionary */ - struct dictionary *dict; + /** Things specific to casereaders. */ - int ref_cnt; + /* The dictionary for client's reference. + Client must ref or clone it if it needs a permanent or modifiable copy. */ + struct dictionary *dict; + struct caseproto *proto; + struct ccase *first_case; + bool used_first_case; + + /* Where the reader should start and stop. */ + int start_row; + int start_col; + int stop_row; + int stop_col; }; struct casereader * spreadsheet_make_reader (struct spreadsheet *, const struct spreadsheet_read_options *); -const char * spreadsheet_get_sheet_name (struct spreadsheet *s, int n); -char * spreadsheet_get_sheet_range (struct spreadsheet *s, int n); +const char * spreadsheet_get_sheet_name (struct spreadsheet *s, int n) OPTIMIZE(2); +char * spreadsheet_get_sheet_range (struct spreadsheet *s, int n) OPTIMIZE(2); +int spreadsheet_get_sheet_n_sheets (struct spreadsheet *s) OPTIMIZE(2); +unsigned int spreadsheet_get_sheet_n_rows (struct spreadsheet *s, int n) OPTIMIZE(2); +unsigned int spreadsheet_get_sheet_n_columns (struct spreadsheet *s, int n) OPTIMIZE(2); +char * spreadsheet_get_cell (struct spreadsheet *s, int n, int row, int column); char * create_cell_ref (int col0, int row0); char *create_cell_range (int col0, int row0, int coli, int rowi); +struct spreadsheet * spreadsheet_ref (struct spreadsheet *s) WARN_UNUSED_RESULT; void spreadsheet_unref (struct spreadsheet *); -void spreadsheet_ref (struct spreadsheet *); - - - #define SPREADSHEET_CAST(X) ((struct spreadsheet *)(X))