src/data/spreadsheet-reader.h

   1 /* PSPP - a program for statistical analysis.
   2    Copyright (C) 2007, 2010, 2016 Free Software Foundation, Inc.
   3
   4    This program is free software: you can redistribute it and/or modify
   5    it under the terms of the GNU General Public License as published by
   6    the Free Software Foundation, either version 3 of the License, or
   7    (at your option) any later version.
   8
   9    This program is distributed in the hope that it will be useful,
  10    but WITHOUT ANY WARRANTY; without even the implied warranty of
  11    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12    GNU General Public License for more details.
  13
  14    You should have received a copy of the GNU General Public License
  15    along with this program.  If not, see <http://www.gnu.org/licenses/>. */
  16
  17 #ifndef SPREADSHEET_READ_H
  18 #define SPREADSHEET_READ_H 1
  19
  20 #include <stdbool.h>
  21
  22 struct casereeader;
  23
  24 /* Default width of string variables. */
  25 #define SPREADSHEET_DEFAULT_WIDTH 8
  26
  27 /* These elements are read/write.
  28    They may be passed in NULL (for pointers) or negative for integers, in which
  29    case they will be filled in be the function.
  30 */
  31 struct spreadsheet_read_options
  32 {
  33   char *sheet_name ;       /* The name of the sheet to open (in UTF-8) */
  34   int sheet_index ;        /* The index of the sheet to open (only used if sheet_name is NULL) */
  35   char *cell_range ;       /* The cell range (in UTF-8) */
  36   bool read_names ;        /* True if the first row is to be used as the names of the variables */
  37   int asw ;                /* The width of string variables in the created dictionary */
  38 };
  39
  40 int ps26_to_int (const char *str);
  41 char * int_to_ps26 (int);
  42
  43 bool convert_cell_ref (const char *ref,
  44                        int *col0, int *row0,
  45                        int *coli, int *rowi);
  46
  47
  48 #define _xml(X) (CHAR_CAST (const xmlChar *, (X)))
  49
  50 #define _xmlchar_to_int(X) ((X) ? atoi (CHAR_CAST (const char *, (X))) : -1)
  51
  52 enum spreadsheet_type
  53   {
  54     SPREADSHEET_NONE,
  55     SPREADSHEET_GNUMERIC,
  56     SPREADSHEET_ODS
  57   };
  58
  59
  60 struct spreadsheet
  61 {
  62   char *file_name;
  63
  64   enum spreadsheet_type type;
  65
  66   /* The total number of sheets in the "workbook" */
  67   int n_sheets;
  68
  69   /* The dictionary for client's reference.
  70      Client must clone if it needs a permanent or modifiable copy. */
  71   const struct dictionary *dict;
  72
  73   int ref_cnt;
  74 };
  75
  76
  77 struct casereader * spreadsheet_make_reader (struct spreadsheet *, const struct spreadsheet_read_options *);
  78
  79 const char * spreadsheet_get_sheet_name (struct spreadsheet *s, int n);
  80 char * spreadsheet_get_sheet_range (struct spreadsheet *s, int n);
  81
  82
  83 char * create_cell_ref (int col0, int row0);
  84 char *create_cell_range (int col0, int row0, int coli, int rowi);
  85
  86 void spreadsheet_unref (struct spreadsheet *);
  87 void spreadsheet_ref (struct spreadsheet *);
  88
  89
  90
  91
  92
  93 #define SPREADSHEET_CAST(X) ((struct spreadsheet *)(X))
  94
  95 #endif