excelize-rs 0.1.1

Rust language library for reading and writing Microsoft Excel (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
Documentation 
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
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301

//! Slicer and timeline parts.
//!
//! Ported from Go `xmlSlicers.go`.

use serde::{Deserialize, Serialize};

use super::common::{XlsxExtLst, XlsxInnerXml};

/// Directly maps the `slicers` element that specifies a slicer view on the
/// worksheet.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "slicers", rename_all = "camelCase")]
pub struct XlsxSlicers {
    #[serde(rename = "@xmlns:mc", default)]
    pub xmlns_mc: Option<String>,
    #[serde(rename = "@xmlns:x", default)]
    pub xmlns_x: Option<String>,
    #[serde(rename = "@xmlns:xr10", default)]
    pub xmlns_xr10: Option<String>,
    #[serde(default)]
    pub slicer: Vec<XlsxSlicer>,
}

/// A complex type that specifies a slicer view.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct XlsxSlicer {
    #[serde(rename = "@name", default)]
    pub name: String,
    #[serde(rename = "@xr10:uid", default)]
    pub xr10_uid: Option<String>,
    #[serde(rename = "@cache", default)]
    pub cache: String,
    #[serde(rename = "@caption", default)]
    pub caption: Option<String>,
    #[serde(rename = "@startItem", default)]
    pub start_item: Option<i64>,
    #[serde(rename = "@columnCount", default)]
    pub column_count: Option<i64>,
    #[serde(rename = "@showCaption", default)]
    pub show_caption: Option<bool>,
    #[serde(rename = "@level", default)]
    pub level: Option<i64>,
    #[serde(rename = "@style", default)]
    pub style: Option<String>,
    #[serde(rename = "@lockedPosition", default)]
    pub locked_position: Option<bool>,
    #[serde(rename = "@rowHeight", default)]
    pub row_height: i64,
}

/// Directly maps the `slicerCacheDefinition` element that specifies a slicer
/// cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "slicerCacheDefinition", rename_all = "camelCase")]
pub struct XlsxSlicerCacheDefinition {
    #[serde(rename = "@xmlns:mc", default)]
    pub xmlns_mc: Option<String>,
    #[serde(rename = "@xmlns:x", default)]
    pub xmlns_x: Option<String>,
    #[serde(rename = "@xmlns:x15", default)]
    pub xmlns_x15: Option<String>,
    #[serde(rename = "@xmlns:xr10", default)]
    pub xmlns_xr10: Option<String>,
    #[serde(rename = "@name", default)]
    pub name: String,
    #[serde(rename = "@xr10:uid", default)]
    pub xr10_uid: Option<String>,
    #[serde(rename = "@sourceName", default)]
    pub source_name: String,
    #[serde(default)]
    pub pivot_tables: Option<XlsxSlicerCachePivotTables>,
    #[serde(default)]
    pub data: Option<XlsxSlicerCacheData>,
    #[serde(default)]
    pub ext_lst: Option<XlsxExtLst>,
}

/// A complex type that specifies a group of pivotTable elements that specify
/// the PivotTable views that are filtered by the slicer cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "pivotTables", rename_all = "camelCase")]
pub struct XlsxSlicerCachePivotTables {
    #[serde(default)]
    pub pivot_table: Vec<XlsxSlicerCachePivotTable>,
}

/// A complex type that specifies a PivotTable view filtered by a slicer cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct XlsxSlicerCachePivotTable {
    #[serde(rename = "@tabId", default)]
    pub tab_id: i64,
    #[serde(rename = "@name", default)]
    pub name: String,
}

/// A complex type that specifies a data source for the slicer cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct XlsxSlicerCacheData {
    #[serde(default)]
    pub olap: Option<XlsxInnerXml>,
    #[serde(default)]
    pub tabular: Option<XlsxTabularSlicerCache>,
}

/// A complex type that specifies non-OLAP slicer items that are cached within
/// this slicer cache and properties of the slicer cache specific to non-OLAP
/// slicer items.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct XlsxTabularSlicerCache {
    #[serde(rename = "@pivotCacheId", default)]
    pub pivot_cache_id: i64,
    #[serde(rename = "@sortOrder", default)]
    pub sort_order: Option<String>,
    #[serde(rename = "@customListSort", default)]
    pub custom_list_sort: Option<bool>,
    #[serde(rename = "@showMissing", default)]
    pub show_missing: Option<bool>,
    #[serde(rename = "@crossFilter", default)]
    pub cross_filter: Option<String>,
    #[serde(default)]
    pub items: Option<XlsxTabularSlicerCacheItems>,
    #[serde(default)]
    pub ext_lst: Option<XlsxExtLst>,
}

/// A complex type that specifies non-OLAP slicer items that are cached within
/// this slicer cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "items", rename_all = "camelCase")]
pub struct XlsxTabularSlicerCacheItems {
    #[serde(rename = "@count", default)]
    pub count: Option<i64>,
    #[serde(default)]
    pub i: Vec<XlsxTabularSlicerCacheItem>,
}

/// A complex type that specifies a non-OLAP slicer item that is cached within
/// this slicer cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "i", rename_all = "camelCase")]
pub struct XlsxTabularSlicerCacheItem {
    #[serde(rename = "@x", default)]
    pub x: i64,
    #[serde(rename = "@s", default)]
    pub s: Option<bool>,
    #[serde(rename = "@nd", default)]
    pub nd: Option<bool>,
}

/// Specifies a table data source for the slicer cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "x15:tableSlicerCache", rename_all = "camelCase")]
pub struct XlsxTableSlicerCache {
    #[serde(rename = "@tableId", default)]
    pub table_id: i64,
    #[serde(rename = "@column", default)]
    pub column: i64,
    #[serde(rename = "@sortOrder", default)]
    pub sort_order: Option<String>,
    #[serde(rename = "@customListSort", default)]
    pub custom_list_sort: Option<bool>,
    #[serde(rename = "@crossFilter", default)]
    pub cross_filter: Option<String>,
    #[serde(default)]
    pub ext_lst: Option<XlsxExtLst>,
}

/// Specifies a list of slicer.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "x14:slicerList", rename_all = "camelCase")]
pub struct XlsxX14SlicerList {
    #[serde(default)]
    pub slicer: Vec<XlsxX14Slicer>,
}

/// Specifies a slicer view.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "x14:slicer")]
pub struct XlsxX14Slicer {
    #[serde(rename = "@r:id", default)]
    pub rid: String,
}

/// Directly maps the `x14:slicerCaches` element.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "x14:slicerCaches")]
pub struct XlsxX14SlicerCaches {
    #[serde(rename = "@xmlns:x14", default)]
    pub xmlns: String,
    #[serde(rename = "$value", default)]
    pub content: String,
}

/// Directly maps the `x14:slicerCache` element.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "x14:slicerCache")]
pub struct XlsxX14SlicerCache {
    #[serde(rename = "@r:id", default)]
    pub rid: String,
}

/// Directly maps the `x15:slicerCaches` element.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "x15:slicerCaches")]
pub struct XlsxX15SlicerCaches {
    #[serde(rename = "@xmlns:x14", default)]
    pub xmlns: String,
    #[serde(rename = "$value", default)]
    pub content: String,
}

/// Defines the structure used to parse the `x15:tableSlicerCache` element of
/// the table slicer cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "tableSlicerCache", rename_all = "camelCase")]
pub struct DecodeTableSlicerCache {
    #[serde(rename = "@tableId", default)]
    pub table_id: i64,
    #[serde(rename = "@column", default)]
    pub column: i64,
    #[serde(rename = "@sortOrder", default)]
    pub sort_order: String,
}

/// Defines the structure used to parse the `x14:slicerList` element of a list
/// of slicer.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "slicerList", rename_all = "camelCase")]
pub struct DecodeSlicerList {
    #[serde(default)]
    pub slicer: Vec<DecodeSlicer>,
}

/// Defines the structure used to parse the `x14:slicer` element of a slicer.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "slicer")]
pub struct DecodeSlicer {
    #[serde(rename = "@id", default)]
    pub rid: String,
}

/// Defines the structure used to parse the `x14:slicerCaches` and
/// `x15:slicerCaches` element of a slicer cache.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "slicerCaches")]
pub struct DecodeSlicerCaches {
    #[serde(rename = "$value", default)]
    pub content: String,
}

/// A mechanism for filtering data in pivot table views, cube functions and
/// charts based on non-worksheet pivot tables. In the case of using OLAP
/// Timeline source data, a Timeline is based on a key attribute of an OLAP
/// hierarchy. In the case of using native Timeline source data, a Timeline is
/// based on a data table column.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename = "timelines", rename_all = "camelCase")]
pub struct XlsxTimelines {
    #[serde(rename = "@xmlns:mc", default)]
    pub xmlns_mc: Option<String>,
    #[serde(rename = "@xmlns:x", default)]
    pub xmlns_x: Option<String>,
    #[serde(rename = "@xmlns:xr10", default)]
    pub xmlns_xr10: Option<String>,
    #[serde(default)]
    pub timeline: Vec<XlsxTimeline>,
}

/// Timeline view specifies the display of a timeline on a worksheet.
#[derive(Debug, Default, Clone, PartialEq, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct XlsxTimeline {
    #[serde(rename = "@name", default)]
    pub name: String,
    #[serde(rename = "@xr10:uid", default)]
    pub xr10_uid: Option<String>,
    #[serde(rename = "@cache", default)]
    pub cache: String,
    #[serde(rename = "@caption", default)]
    pub caption: Option<String>,
    #[serde(rename = "@showHeader", default)]
    pub show_header: Option<bool>,
    #[serde(rename = "@showSelectionLabel", default)]
    pub show_selection_label: Option<bool>,
    #[serde(rename = "@showTimeLevel", default)]
    pub show_time_level: Option<bool>,
    #[serde(rename = "@showHorizontalScrollbar", default)]
    pub show_horizontal_scrollbar: Option<bool>,
    #[serde(rename = "@level", default)]
    pub level: i64,
    #[serde(rename = "@selectionLevel", default)]
    pub selection_level: i64,
    #[serde(rename = "@scrollPosition", default)]
    pub scroll_position: Option<String>,
    #[serde(rename = "@style", default)]
    pub style: Option<String>,
}