X-Git-Url: https://pintos-os.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=src%2Fdata%2Fspreadsheet-reader.h;h=efba6f369fbf3577511aa01f422c64d241893db4;hb=8d6bfdd2a100bf8166b3b0b3f006d46f3e7a59e9;hp=77ed5ab9dbbe6551f59126ed21a6da2c3e53575f;hpb=5c210c96542db2a357cf1aa6b690ef2ea88a54b1;p=pspp diff --git a/src/data/spreadsheet-reader.h b/src/data/spreadsheet-reader.h index 77ed5ab9db..efba6f369f 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,9 @@ #define SPREADSHEET_READ_H 1 #include +#include + +struct casereeader; /* Default width of string variables. */ #define SPREADSHEET_DEFAULT_WIDTH 8 @@ -29,28 +32,24 @@ 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) */ -}; - - -struct spreadsheet_read_info -{ - char *file_name ; /* The name of the file to open (in filename encoding) */ 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 */ }; -int pseudo_base26 (const char *str); +int ps26_to_int (const char *str); +char * int_to_ps26 (int); bool convert_cell_ref (const char *ref, int *col0, int *row0, int *coli, int *rowi); -#define _xml(X) (CHAR_CAST (const xmlChar *, X)) +#define _xml(X) (CHAR_CAST (const xmlChar *, (X))) -#define _xmlchar_to_int(X) (atoi(CHAR_CAST (const char *, X))) +#define _xmlchar_to_int(X) ((X) ? atoi (CHAR_CAST (const char *, (X))) : -1) enum spreadsheet_type { @@ -59,29 +58,38 @@ enum spreadsheet_type SPREADSHEET_ODS }; + struct spreadsheet { + char *file_name; + enum spreadsheet_type type; /* The total number of sheets in the "workbook" */ - int sheets; + int n_sheets; - /* The dictionary */ + /* The dictionary for client's reference. + Client must ref or clone it if it needs a permanent or modifiable copy. */ struct dictionary *dict; + + int ref_cnt; }; -/* - Attempt to open the file called FILENAME as a spreadsheet. - It is not known a priori, what type of spreadsheet FILENAME is, or - even if it is a spreadsheet at all. - If it fails to open, then it will return NULL without any error or - warning messages. - */ -struct spreadsheet * spreadsheet_open (const char *filename); -void spreadsheet_close (struct spreadsheet *); -struct casereeader; -struct casereader * spreadsheet_make_reader (struct spreadsheet *s); +struct casereader * spreadsheet_make_reader (struct spreadsheet *, const struct spreadsheet_read_options *); + +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); + + +char * create_cell_ref (int col0, int row0); +char *create_cell_range (int col0, int row0, int coli, int rowi); + +void spreadsheet_unref (struct spreadsheet *); +void spreadsheet_ref (struct spreadsheet *); + + + #define SPREADSHEET_CAST(X) ((struct spreadsheet *)(X))