1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
|
/* vim: set sw=8 ts=8: -*- Mode: C; tab-width: 8; indent-tabs-mode: t; c-basic-offset: 8 -*- */
/**
* ms-excel.h: MS Excel support for Gnumeric
*
* Authors:
* Jody Goldberg (jody@gnome.org)
* Michael Meeks (michael@ximian.com)
*
* (C) 1998-2001 Michael Meeks
* (C) 2002-2005 Jody Goldberg
**/
#ifndef GNM_MS_EXCEL_READ_H
#define GNM_MS_EXCEL_READ_H
#include "ms-biff.h"
#include "ms-excel-biff.h"
#include "ms-container.h"
#include <expr.h>
#include <mstyle.h>
#include <goffice-data.h>
#include <pango/pango-attributes.h>
#include <gdk-pixbuf/gdk-pixbuf.h>
typedef struct {
Sheet *first, *last;
unsigned supbook;
} ExcelExternSheetV8;
typedef enum {
EXCEL_SUP_BOOK_STD,
EXCEL_SUP_BOOK_SELFREF,
EXCEL_SUP_BOOK_PLUGIN
} ExcelSupBookType;
typedef struct {
ExcelSupBookType type;
Workbook *wb;
GPtrArray *externname;
} ExcelSupBook;
typedef struct {
MSContainer container;
Sheet *sheet;
GHashTable *shared_formulae, *tables;
gboolean freeze_panes;
unsigned active_pane;
GnmFilter *filter;
int biff2_prev_xf_index;
} ExcelReadSheet;
typedef struct {
GnmCellPos key;
guint8 *data;
guint32 data_len, array_data_len;
gboolean is_array;
} XLSharedFormula;
typedef struct {
GnmRange table;
GnmCellPos c_in, r_in;
} XLDataTable;
/* Use the upper left corner as the key to a collection of shared formulas */
XLSharedFormula *excel_sheet_shared_formula (ExcelReadSheet const *sheet,
GnmCellPos const *key);
XLDataTable *excel_sheet_data_table (ExcelReadSheet const *esheet,
GnmCellPos const *key);
typedef struct {
int *red;
int *green;
int *blue;
int length;
GnmColor **gnm_colors;
} ExcelPalette;
typedef struct {
unsigned index;
int height; /* in 1/20ths of a point */
int italic; /* boolean */
int struck_out; /* boolean : strikethrough */
int color_idx;
int boldness; /* 100->1000 dec, normal = 0x190, bold = 0x2bc */
GOFontScript script;
MsBiffFontUnderline underline;
char *fontname;
PangoAttrList *attrs;
GOFont const *go_font;
} ExcelFont;
typedef struct {
unsigned idx;
char *name;
} BiffFormatData;
typedef struct {
GOString *content;
GOFormat *markup;
} ExcelStringEntry;
struct _GnmXLImporter {
MSContainer container;
GOIOContext *context;
WorkbookView *wbv;
Workbook *wb;
MsBiffVersion ver;
GPtrArray *excel_sheets;
GHashTable *boundsheet_data_by_stream;
GPtrArray *boundsheet_sheet_by_index;
GPtrArray *names;
unsigned num_name_records; /* names->len has fwd decls */
GPtrArray *XF_cell_records;
GHashTable *font_data;
GHashTable *format_table; /* leave as a hash */
struct {
GnmSheetSlicer *slicer;
GODataSlicerField *slicer_field;
GPtrArray *cache_by_id;
unsigned int field_count, record_count;
unsigned int ivd_index; /* 0 = row, 1 = col, > 1 == err */
} pivot;
struct {
GArray *supbook;
GArray *externsheet;
} v8; /* biff8 does this in the workbook */
ExcelPalette *palette;
unsigned sst_len;
ExcelStringEntry *sst;
GnmExprSharer *expr_sharer;
GIConv str_iconv;
};
GnmValue *xls_value_new_err (GnmEvalPos const *pos, guint8 const err);
void xls_read_range32 (GnmRange *r, guint8 const *data);
void xls_read_range16 (GnmRange *r, guint8 const *data);
void xls_read_range8 (GnmRange *r, guint8 const *data);
Sheet *excel_externsheet_v7 (MSContainer const *container, gint16 i);
ExcelExternSheetV8 const *excel_externsheet_v8 (GnmXLImporter const *wb, guint16 i);
void excel_read_EXTERNSHEET_v7 (BiffQuery const *q, MSContainer *container);
MsBiffBofData *ms_biff_bof_data_new (BiffQuery * q);
void ms_biff_bof_data_destroy (MsBiffBofData * data);
char *excel_get_chars (GnmXLImporter const *imp,
guint8 const *ptr, size_t length,
gboolean use_utf16);
char * excel_get_text (GnmXLImporter const *imp,
guint8 const *pos, guint32 length,
guint32 *byte_length, guint32 maxlen);
char *excel_biff_text_1 (GnmXLImporter const *imp, BiffQuery const *q, guint32 ofs);
char *excel_biff_text_2 (GnmXLImporter const *imp, BiffQuery const *q, guint32 ofs);
GnmColor *excel_palette_get (GnmXLImporter *imp, gint idx);
ExcelFont const *excel_font_get (GnmXLImporter const *imp, unsigned idx);
GOFont const *excel_font_get_gofont (ExcelFont const *font);
GdkPixbuf *excel_read_IMDATA (BiffQuery *q, gboolean keep_image);
void excel_read_SCL (BiffQuery *q, Sheet *esheet);
/* A utility routine to handle unexpected BIFF records */
void excel_unexpected_biff (BiffQuery *q, char const *state, int debug_level);
void xls_read_SXStreamID (GnmXLImporter *imp, BiffQuery *q,
GsfInfile *parent);
void xls_read_SXVIEW (BiffQuery *q, ExcelReadSheet *esheet);
void xls_read_SXVD (BiffQuery *q, ExcelReadSheet *esheet);
void xls_read_SXIVD (BiffQuery *q, ExcelReadSheet *esheet);
void excel_read_cleanup (void);
void excel_read_init (void);
#endif /* GNM_MS_EXCEL_READ_H */
|
