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
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
|
<?xml version="1.0" encoding="ascii"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Camelot.camelot.view.export.excel</title>
<link rel="stylesheet" href="epydoc.css" type="text/css" />
<script type="text/javascript" src="epydoc.js"></script>
</head>
<body bgcolor="white" text="black" link="blue" vlink="#204080"
alink="#204080">
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
bgcolor="#a0c0ff" cellspacing="0">
<tr valign="middle">
<!-- Home link -->
<th> <a
href="Camelot.camelot-module.html">Home</a> </th>
<!-- Tree link -->
<th> <a
href="module-tree.html">Trees</a> </th>
<!-- Index link -->
<th> <a
href="identifier-index.html">Indices</a> </th>
<!-- Help link -->
<th> <a
href="help.html">Help</a> </th>
<!-- Project homepage -->
<th class="navbar" align="right" width="100%">
<table border="0" cellpadding="0" cellspacing="0">
<tr><th class="navbar" align="center"
><a class="navbar" target="_top" href="http://www.python-camelot.com">Camelot</a></th>
</tr></table></th>
</tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0">
<tr valign="top">
<td width="100%">
<span class="breadcrumbs">
Package Camelot ::
<a href="Camelot.camelot-module.html">Package camelot</a> ::
<a href="Camelot.camelot.view-module.html">Package view</a> ::
<a href="Camelot.camelot.view.export-module.html">Package export</a> ::
Module excel
</span>
</td>
<td>
<table cellpadding="0" cellspacing="0">
<!-- hide/show private -->
<tr><td align="right"><span class="options"
>[<a href="frames.html" target="_top">frames</a
>] | <a href="Camelot.camelot.view.export.excel-pysrc.html"
target="_top">no frames</a>]</span></td></tr>
</table>
</td>
</tr>
</table>
<h1 class="epydoc">Source Code for <a href="Camelot.camelot.view.export.excel-module.html">Module Camelot.camelot.view.export.excel</a></h1>
<pre class="py-src">
<a name="L1"></a><tt class="py-lineno"> 1</tt> <tt class="py-line"><tt class="py-comment"># ==================================================================================</tt> </tt>
<a name="L2"></a><tt class="py-lineno"> 2</tt> <tt class="py-line"><tt class="py-comment">#</tt> </tt>
<a name="L3"></a><tt class="py-lineno"> 3</tt> <tt class="py-line"><tt class="py-comment"># Copyright (C) 2007-2008 Conceptive Engineering bvba. All rights reserved.</tt> </tt>
<a name="L4"></a><tt class="py-lineno"> 4</tt> <tt class="py-line"><tt class="py-comment"># www.conceptive.be / project-camelot@conceptive.be</tt> </tt>
<a name="L5"></a><tt class="py-lineno"> 5</tt> <tt class="py-line"><tt class="py-comment">#</tt> </tt>
<a name="L6"></a><tt class="py-lineno"> 6</tt> <tt class="py-line"><tt class="py-comment"># This file is part of the Camelot Library.</tt> </tt>
<a name="L7"></a><tt class="py-lineno"> 7</tt> <tt class="py-line"><tt class="py-comment">#</tt> </tt>
<a name="L8"></a><tt class="py-lineno"> 8</tt> <tt class="py-line"><tt class="py-comment"># This file may be used under the terms of the GNU General Public</tt> </tt>
<a name="L9"></a><tt class="py-lineno"> 9</tt> <tt class="py-line"><tt class="py-comment"># License version 2.0 as published by the Free Software Foundation</tt> </tt>
<a name="L10"></a><tt class="py-lineno"> 10</tt> <tt class="py-line"><tt class="py-comment"># and appearing in the file LICENSE.GPL included in the packaging of</tt> </tt>
<a name="L11"></a><tt class="py-lineno"> 11</tt> <tt class="py-line"><tt class="py-comment"># this file. Please review the following information to ensure GNU</tt> </tt>
<a name="L12"></a><tt class="py-lineno"> 12</tt> <tt class="py-line"><tt class="py-comment"># General Public Licensing requirements will be met:</tt> </tt>
<a name="L13"></a><tt class="py-lineno"> 13</tt> <tt class="py-line"><tt class="py-comment"># http://www.trolltech.com/products/qt/opensource.html</tt> </tt>
<a name="L14"></a><tt class="py-lineno"> 14</tt> <tt class="py-line"><tt class="py-comment">#</tt> </tt>
<a name="L15"></a><tt class="py-lineno"> 15</tt> <tt class="py-line"><tt class="py-comment"># If you are unsure which license is appropriate for your use, please</tt> </tt>
<a name="L16"></a><tt class="py-lineno"> 16</tt> <tt class="py-line"><tt class="py-comment"># review the following information:</tt> </tt>
<a name="L17"></a><tt class="py-lineno"> 17</tt> <tt class="py-line"><tt class="py-comment"># http://www.trolltech.com/products/qt/licensing.html or contact</tt> </tt>
<a name="L18"></a><tt class="py-lineno"> 18</tt> <tt class="py-line"><tt class="py-comment"># project-camelot@conceptive.be.</tt> </tt>
<a name="L19"></a><tt class="py-lineno"> 19</tt> <tt class="py-line"><tt class="py-comment">#</tt> </tt>
<a name="L20"></a><tt class="py-lineno"> 20</tt> <tt class="py-line"><tt class="py-comment"># This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE</tt> </tt>
<a name="L21"></a><tt class="py-lineno"> 21</tt> <tt class="py-line"><tt class="py-comment"># WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.</tt> </tt>
<a name="L22"></a><tt class="py-lineno"> 22</tt> <tt class="py-line"><tt class="py-comment">#</tt> </tt>
<a name="L23"></a><tt class="py-lineno"> 23</tt> <tt class="py-line"><tt class="py-comment"># For use of this library in commercial applications, please contact</tt> </tt>
<a name="L24"></a><tt class="py-lineno"> 24</tt> <tt class="py-line"><tt class="py-comment"># project-camelot@conceptive.be</tt> </tt>
<a name="L25"></a><tt class="py-lineno"> 25</tt> <tt class="py-line"><tt class="py-comment">#</tt> </tt>
<a name="L26"></a><tt class="py-lineno"> 26</tt> <tt class="py-line"><tt class="py-comment"># ==================================================================================</tt> </tt>
<a name="L27"></a><tt class="py-lineno"> 27</tt> <tt class="py-line"> </tt>
<a name="L28"></a><tt class="py-lineno"> 28</tt> <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">logging</tt> </tt>
<a name="L29"></a><tt class="py-lineno"> 29</tt> <tt class="py-line"><tt id="link-0" class="py-name" targets="Variable Camelot.camelot.action.refresh.logger=Camelot.camelot.action.refresh-module.html#logger,Variable Camelot.camelot.admin.list_action.logger=Camelot.camelot.admin.list_action-module.html#logger,Variable Camelot.camelot.admin.object_admin.logger=Camelot.camelot.admin.object_admin-module.html#logger,Variable Camelot.camelot.admin.validator.entity_validator.logger=Camelot.camelot.admin.validator.entity_validator-module.html#logger,Variable Camelot.camelot.admin.validator.object_validator.logger=Camelot.camelot.admin.validator.object_validator-module.html#logger,Variable Camelot.camelot.core.files.storage.logger=Camelot.camelot.core.files.storage-module.html#logger,Variable Camelot.camelot.core.resources.logger=Camelot.camelot.core.resources-module.html#logger,Variable Camelot.camelot.empty_project.main.logger=Camelot.camelot.empty_project.main-module.html#logger,Variable Camelot.camelot.empty_project.model.logger=Camelot.camelot.empty_project.model-module.html#logger,Variable Camelot.camelot.model.i18n.logger=Camelot.camelot.model.i18n-module.html#logger,Variable Camelot.camelot.types.logger=Camelot.camelot.types-module.html#logger,Variable Camelot.camelot.view.art.logger=Camelot.camelot.view.art-module.html#logger,Variable Camelot.camelot.view.controls.actionsbox.logger=Camelot.camelot.view.controls.actionsbox-module.html#logger,Variable Camelot.camelot.view.controls.delegates.comboboxdelegate.logger=Camelot.camelot.view.controls.delegates.comboboxdelegate-module.html#logger,Variable Camelot.camelot.view.controls.delegates.delegatemanager.logger=Camelot.camelot.view.controls.delegates.delegatemanager-module.html#logger,Variable Camelot.camelot.view.controls.delegates.many2onedelegate.logger=Camelot.camelot.view.controls.delegates.many2onedelegate-module.html#logger,Variable Camelot.camelot.view.controls.delegates.one2manydelegate.logger=Camelot.camelot.view.controls.delegates.one2manydelegate-module.html#logger,Variable Camelot.camelot.view.controls.editors.embeddedmany2oneeditor.logger=Camelot.camelot.view.controls.editors.embeddedmany2oneeditor-module.html#logger,Variable Camelot.camelot.view.controls.editors.one2manyeditor.logger=Camelot.camelot.view.controls.editors.one2manyeditor-module.html#logger,Variable Camelot.camelot.view.controls.filterlist.logger=Camelot.camelot.view.controls.filterlist-module.html#logger,Variable Camelot.camelot.view.controls.formview.logger=Camelot.camelot.view.controls.formview-module.html#logger,Variable Camelot.camelot.view.controls.inheritance.logger=Camelot.camelot.view.controls.inheritance-module.html#logger,Variable Camelot.camelot.view.controls.modeltree.logger=Camelot.camelot.view.controls.modeltree-module.html#logger,Variable Camelot.camelot.view.controls.navpane.logger=Camelot.camelot.view.controls.navpane-module.html#logger,Variable Camelot.camelot.view.controls.printer.logger=Camelot.camelot.view.controls.printer-module.html#logger,Variable Camelot.camelot.view.controls.statusbar.logger=Camelot.camelot.view.controls.statusbar-module.html#logger,Variable Camelot.camelot.view.controls.tableview.logger=Camelot.camelot.view.controls.tableview-module.html#logger,Variable Camelot.camelot.view.elixir_admin.logger=Camelot.camelot.view.elixir_admin-module.html#logger,Variable Camelot.camelot.view.export.desktop_service.logger=Camelot.camelot.view.export.desktop_service-module.html#logger,Variable Camelot.camelot.view.export.excel.logger=Camelot.camelot.view.export.excel-module.html#logger,Variable Camelot.camelot.view.export.outlook.logger=Camelot.camelot.view.export.outlook-module.html#logger,Variable Camelot.camelot.view.export.printer.logger=Camelot.camelot.view.export.printer-module.html#logger,Variable Camelot.camelot.view.export.word.logger=Camelot.camelot.view.export.word-module.html#logger,Variable Camelot.camelot.view.forms.logger=Camelot.camelot.view.forms-module.html#logger,Variable Camelot.camelot.view.mainwindow.logger=Camelot.camelot.view.mainwindow-module.html#logger,Variable Camelot.camelot.view.model_thread.logger=Camelot.camelot.view.model_thread-module.html#logger,Variable Camelot.camelot.view.model_thread.no_thread_model_thread.logger=Camelot.camelot.view.model_thread.no_thread_model_thread-module.html#logger,Variable Camelot.camelot.view.model_thread.signal_slot_model_thread.logger=Camelot.camelot.view.model_thread.signal_slot_model_thread-module.html#logger,Variable Camelot.camelot.view.proxy.collection_proxy.logger=Camelot.camelot.view.proxy.collection_proxy-module.html#logger,Variable Camelot.camelot.view.proxy.queryproxy.logger=Camelot.camelot.view.proxy.queryproxy-module.html#logger,Variable Camelot.camelot.view.remote_signals.logger=Camelot.camelot.view.remote_signals-module.html#logger,Variable Camelot.camelot.view.response_handler.logger=Camelot.camelot.view.response_handler-module.html#logger,Variable Camelot.camelot.view.search.logger=Camelot.camelot.view.search-module.html#logger,Variable Camelot.camelot.view.utils.logger=Camelot.camelot.view.utils-module.html#logger,Variable Camelot.camelot.view.wizard.importwizard.logger=Camelot.camelot.view.wizard.importwizard-module.html#logger,Variable Camelot.camelot.view.workspace.logger=Camelot.camelot.view.workspace-module.html#logger"><a title="Camelot.camelot.action.refresh.logger
Camelot.camelot.admin.list_action.logger
Camelot.camelot.admin.object_admin.logger
Camelot.camelot.admin.validator.entity_validator.logger
Camelot.camelot.admin.validator.object_validator.logger
Camelot.camelot.core.files.storage.logger
Camelot.camelot.core.resources.logger
Camelot.camelot.empty_project.main.logger
Camelot.camelot.empty_project.model.logger
Camelot.camelot.model.i18n.logger
Camelot.camelot.types.logger
Camelot.camelot.view.art.logger
Camelot.camelot.view.controls.actionsbox.logger
Camelot.camelot.view.controls.delegates.comboboxdelegate.logger
Camelot.camelot.view.controls.delegates.delegatemanager.logger
Camelot.camelot.view.controls.delegates.many2onedelegate.logger
Camelot.camelot.view.controls.delegates.one2manydelegate.logger
Camelot.camelot.view.controls.editors.embeddedmany2oneeditor.logger
Camelot.camelot.view.controls.editors.one2manyeditor.logger
Camelot.camelot.view.controls.filterlist.logger
Camelot.camelot.view.controls.formview.logger
Camelot.camelot.view.controls.inheritance.logger
Camelot.camelot.view.controls.modeltree.logger
Camelot.camelot.view.controls.navpane.logger
Camelot.camelot.view.controls.printer.logger
Camelot.camelot.view.controls.statusbar.logger
Camelot.camelot.view.controls.tableview.logger
Camelot.camelot.view.elixir_admin.logger
Camelot.camelot.view.export.desktop_service.logger
Camelot.camelot.view.export.excel.logger
Camelot.camelot.view.export.outlook.logger
Camelot.camelot.view.export.printer.logger
Camelot.camelot.view.export.word.logger
Camelot.camelot.view.forms.logger
Camelot.camelot.view.mainwindow.logger
Camelot.camelot.view.model_thread.logger
Camelot.camelot.view.model_thread.no_thread_model_thread.logger
Camelot.camelot.view.model_thread.signal_slot_model_thread.logger
Camelot.camelot.view.proxy.collection_proxy.logger
Camelot.camelot.view.proxy.queryproxy.logger
Camelot.camelot.view.remote_signals.logger
Camelot.camelot.view.response_handler.logger
Camelot.camelot.view.search.logger
Camelot.camelot.view.utils.logger
Camelot.camelot.view.wizard.importwizard.logger
Camelot.camelot.view.workspace.logger" class="py-name" href="#" onclick="return doclink('link-0', 'logger', 'link-0');">logger</a></tt> <tt class="py-op">=</tt> <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">getLogger</tt><tt class="py-op">(</tt><tt class="py-string">'camelot.view.export.excel'</tt><tt class="py-op">)</tt> </tt>
<a name="L30"></a><tt class="py-lineno"> 30</tt> <tt class="py-line"> </tt>
<a name="L31"></a><tt class="py-lineno"> 31</tt> <tt class="py-line"><tt class="py-keyword">from</tt> <tt class="py-name">pyExcelerator</tt> <tt class="py-keyword">import</tt> <tt class="py-op">*</tt> </tt>
<a name="L32"></a><tt class="py-lineno"> 32</tt> <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">datetime</tt> </tt>
<a name="L33"></a><tt class="py-lineno"> 33</tt> <tt class="py-line"> </tt>
<a name="L34"></a><tt class="py-lineno"> 34</tt> <tt class="py-line"><tt id="link-1" class="py-name" targets="Variable Camelot.camelot.view.export.excel.titleFont=Camelot.camelot.view.export.excel-module.html#titleFont"><a title="Camelot.camelot.view.export.excel.titleFont" class="py-name" href="#" onclick="return doclink('link-1', 'titleFont', 'link-1');">titleFont</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Font</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> <tt class="py-comment"># initializing titleFont Object</tt> </tt>
<a name="L35"></a><tt class="py-lineno"> 35</tt> <tt class="py-line"><tt id="link-2" class="py-name" targets="Variable Camelot.camelot.view.export.excel.headerFont=Camelot.camelot.view.export.excel-module.html#headerFont"><a title="Camelot.camelot.view.export.excel.headerFont" class="py-name" href="#" onclick="return doclink('link-2', 'headerFont', 'link-2');">headerFont</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Font</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> <tt class="py-comment"># initializing headerFont Object</tt> </tt>
<a name="L36"></a><tt class="py-lineno"> 36</tt> <tt class="py-line"><tt id="link-3" class="py-name" targets="Variable Camelot.camelot.view.export.excel.cellFont=Camelot.camelot.view.export.excel-module.html#cellFont"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-3', 'cellFont', 'link-3');">cellFont</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Font</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> <tt class="py-comment"># initializing cellFont Object</tt> </tt>
<a name="L37"></a><tt class="py-lineno"> 37</tt> <tt class="py-line"> </tt>
<a name="L38"></a><tt class="py-lineno"> 38</tt> <tt class="py-line"><tt id="link-4" class="py-name"><a title="Camelot.camelot.view.export.excel.titleFont" class="py-name" href="#" onclick="return doclink('link-4', 'titleFont', 'link-1');">titleFont</a></tt><tt class="py-op">.</tt><tt id="link-5" class="py-name" targets="Variable Camelot.camelot.admin.object_admin.ObjectAdmin.name=Camelot.camelot.admin.object_admin.ObjectAdmin-class.html#name,Variable Camelot.camelot.model.authentication.GeographicBoundary.name=Camelot.camelot.model.authentication.GeographicBoundary-class.html#name,Variable Camelot.camelot.model.authentication.Party.name=Camelot.camelot.model.authentication.Party-class.html#name,Variable Camelot.camelot.model.authentication.Person.name=Camelot.camelot.model.authentication.Person-class.html#name,Variable Camelot.camelot.model.batch_job.BatchJobType.name=Camelot.camelot.model.batch_job.BatchJobType-class.html#name,Variable Camelot.camelot.view.application_admin.ApplicationAdmin.name=Camelot.camelot.view.application_admin.ApplicationAdmin-class.html#name,Method Camelot.camelot.view.plugins.CamelotEditorPlugin.name()=Camelot.camelot.view.plugins.CamelotEditorPlugin-class.html#name"><a title="Camelot.camelot.admin.object_admin.ObjectAdmin.name
Camelot.camelot.model.authentication.GeographicBoundary.name
Camelot.camelot.model.authentication.Party.name
Camelot.camelot.model.authentication.Person.name
Camelot.camelot.model.batch_job.BatchJobType.name
Camelot.camelot.view.application_admin.ApplicationAdmin.name
Camelot.camelot.view.plugins.CamelotEditorPlugin.name" class="py-name" href="#" onclick="return doclink('link-5', 'name', 'link-5');">name</a></tt> <tt class="py-op">=</tt> <tt class="py-string">'Arial'</tt> <tt class="py-comment"># Setting Fonts Name</tt> </tt>
<a name="L39"></a><tt class="py-lineno"> 39</tt> <tt class="py-line"><tt id="link-6" class="py-name"><a title="Camelot.camelot.view.export.excel.headerFont" class="py-name" href="#" onclick="return doclink('link-6', 'headerFont', 'link-2');">headerFont</a></tt><tt class="py-op">.</tt><tt id="link-7" class="py-name"><a title="Camelot.camelot.admin.object_admin.ObjectAdmin.name
Camelot.camelot.model.authentication.GeographicBoundary.name
Camelot.camelot.model.authentication.Party.name
Camelot.camelot.model.authentication.Person.name
Camelot.camelot.model.batch_job.BatchJobType.name
Camelot.camelot.view.application_admin.ApplicationAdmin.name
Camelot.camelot.view.plugins.CamelotEditorPlugin.name" class="py-name" href="#" onclick="return doclink('link-7', 'name', 'link-5');">name</a></tt> <tt class="py-op">=</tt> <tt class="py-string">'Arial'</tt> </tt>
<a name="L40"></a><tt class="py-lineno"> 40</tt> <tt class="py-line"><tt id="link-8" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-8', 'cellFont', 'link-3');">cellFont</a></tt><tt class="py-op">.</tt><tt id="link-9" class="py-name"><a title="Camelot.camelot.admin.object_admin.ObjectAdmin.name
Camelot.camelot.model.authentication.GeographicBoundary.name
Camelot.camelot.model.authentication.Party.name
Camelot.camelot.model.authentication.Person.name
Camelot.camelot.model.batch_job.BatchJobType.name
Camelot.camelot.view.application_admin.ApplicationAdmin.name
Camelot.camelot.view.plugins.CamelotEditorPlugin.name" class="py-name" href="#" onclick="return doclink('link-9', 'name', 'link-5');">name</a></tt> <tt class="py-op">=</tt> <tt class="py-string">'Arial'</tt> </tt>
<a name="L41"></a><tt class="py-lineno"> 41</tt> <tt class="py-line"> </tt>
<a name="L42"></a><tt class="py-lineno"> 42</tt> <tt class="py-line"><tt id="link-10" class="py-name"><a title="Camelot.camelot.view.export.excel.titleFont" class="py-name" href="#" onclick="return doclink('link-10', 'titleFont', 'link-1');">titleFont</a></tt><tt class="py-op">.</tt><tt class="py-name">bold</tt> <tt class="py-op">=</tt> <tt class="py-name">True</tt> <tt class="py-comment"># Setting title font to bold</tt> </tt>
<a name="L43"></a><tt class="py-lineno"> 43</tt> <tt class="py-line"><tt id="link-11" class="py-name"><a title="Camelot.camelot.view.export.excel.headerFont" class="py-name" href="#" onclick="return doclink('link-11', 'headerFont', 'link-2');">headerFont</a></tt><tt class="py-op">.</tt><tt class="py-name">bold</tt> <tt class="py-op">=</tt> <tt class="py-name">True</tt> <tt class="py-comment"># Setting column header font to bold</tt> </tt>
<a name="L44"></a><tt class="py-lineno"> 44</tt> <tt class="py-line"><tt id="link-12" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-12', 'cellFont', 'link-3');">cellFont</a></tt><tt class="py-op">.</tt><tt class="py-name">bold</tt> <tt class="py-op">=</tt> <tt class="py-name">False</tt> <tt class="py-comment"># Setting cell font to bold</tt> </tt>
<a name="L45"></a><tt class="py-lineno"> 45</tt> <tt class="py-line"> </tt>
<a name="L46"></a><tt class="py-lineno"> 46</tt> <tt class="py-line"><tt id="link-13" class="py-name"><a title="Camelot.camelot.view.export.excel.titleFont" class="py-name" href="#" onclick="return doclink('link-13', 'titleFont', 'link-1');">titleFont</a></tt><tt class="py-op">.</tt><tt class="py-name">height</tt> <tt class="py-op">=</tt> <tt class="py-number">240</tt> <tt class="py-comment"># 12*20 = 240 Font Size</tt> </tt>
<a name="L47"></a><tt class="py-lineno"> 47</tt> <tt class="py-line"><tt id="link-14" class="py-name"><a title="Camelot.camelot.view.export.excel.headerFont" class="py-name" href="#" onclick="return doclink('link-14', 'headerFont', 'link-2');">headerFont</a></tt><tt class="py-op">.</tt><tt class="py-name">height</tt> <tt class="py-op">=</tt> <tt class="py-number">220</tt> <tt class="py-comment"># 10*20 = 240 Font Size</tt> </tt>
<a name="L48"></a><tt class="py-lineno"> 48</tt> <tt class="py-line"><tt id="link-15" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-15', 'cellFont', 'link-3');">cellFont</a></tt><tt class="py-op">.</tt><tt class="py-name">height</tt> <tt class="py-op">=</tt> <tt class="py-number">220</tt> <tt class="py-comment"># 10*20 = 240 Font Size</tt> </tt>
<a name="L49"></a><tt class="py-lineno"> 49</tt> <tt class="py-line"> </tt>
<a name="L50"></a><tt class="py-lineno"> 50</tt> <tt class="py-line"><tt id="link-16" class="py-name" targets="Variable Camelot.camelot.view.export.excel.brdLeft=Camelot.camelot.view.export.excel-module.html#brdLeft"><a title="Camelot.camelot.view.export.excel.brdLeft" class="py-name" href="#" onclick="return doclink('link-16', 'brdLeft', 'link-16');">brdLeft</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Borders</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> <tt class="py-comment"># Defining border which is around header</tt> </tt>
<a name="L51"></a><tt class="py-lineno"> 51</tt> <tt class="py-line"><tt id="link-17" class="py-name"><a title="Camelot.camelot.view.export.excel.brdLeft" class="py-name" href="#" onclick="return doclink('link-17', 'brdLeft', 'link-16');">brdLeft</a></tt><tt class="py-op">.</tt><tt class="py-name">left</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L52"></a><tt class="py-lineno"> 52</tt> <tt class="py-line"> </tt>
<a name="L53"></a><tt class="py-lineno"> 53</tt> <tt class="py-line"><tt id="link-18" class="py-name" targets="Variable Camelot.camelot.view.export.excel.brdRight=Camelot.camelot.view.export.excel-module.html#brdRight"><a title="Camelot.camelot.view.export.excel.brdRight" class="py-name" href="#" onclick="return doclink('link-18', 'brdRight', 'link-18');">brdRight</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Borders</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> <tt class="py-comment"># Defining border which is around header</tt> </tt>
<a name="L54"></a><tt class="py-lineno"> 54</tt> <tt class="py-line"><tt id="link-19" class="py-name"><a title="Camelot.camelot.view.export.excel.brdRight" class="py-name" href="#" onclick="return doclink('link-19', 'brdRight', 'link-18');">brdRight</a></tt><tt class="py-op">.</tt><tt class="py-name">right</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L55"></a><tt class="py-lineno"> 55</tt> <tt class="py-line"> </tt>
<a name="L56"></a><tt class="py-lineno"> 56</tt> <tt class="py-line"><tt id="link-20" class="py-name" targets="Variable Camelot.camelot.view.export.excel.brdTop=Camelot.camelot.view.export.excel-module.html#brdTop"><a title="Camelot.camelot.view.export.excel.brdTop" class="py-name" href="#" onclick="return doclink('link-20', 'brdTop', 'link-20');">brdTop</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Borders</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> <tt class="py-comment"># Defining border which is around header</tt> </tt>
<a name="L57"></a><tt class="py-lineno"> 57</tt> <tt class="py-line"><tt id="link-21" class="py-name"><a title="Camelot.camelot.view.export.excel.brdTop" class="py-name" href="#" onclick="return doclink('link-21', 'brdTop', 'link-20');">brdTop</a></tt><tt class="py-op">.</tt><tt class="py-name">top</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L58"></a><tt class="py-lineno"> 58</tt> <tt class="py-line"> </tt>
<a name="L59"></a><tt class="py-lineno"> 59</tt> <tt class="py-line"><tt id="link-22" class="py-name" targets="Variable Camelot.camelot.view.export.excel.brdBottom=Camelot.camelot.view.export.excel-module.html#brdBottom"><a title="Camelot.camelot.view.export.excel.brdBottom" class="py-name" href="#" onclick="return doclink('link-22', 'brdBottom', 'link-22');">brdBottom</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Borders</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> <tt class="py-comment"># Defining border which is around header</tt> </tt>
<a name="L60"></a><tt class="py-lineno"> 60</tt> <tt class="py-line"><tt id="link-23" class="py-name"><a title="Camelot.camelot.view.export.excel.brdBottom" class="py-name" href="#" onclick="return doclink('link-23', 'brdBottom', 'link-22');">brdBottom</a></tt><tt class="py-op">.</tt><tt class="py-name">bottom</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L61"></a><tt class="py-lineno"> 61</tt> <tt class="py-line"> </tt>
<a name="L62"></a><tt class="py-lineno"> 62</tt> <tt class="py-line"><tt id="link-24" class="py-name" targets="Variable Camelot.camelot.view.export.excel.brdTopLeft=Camelot.camelot.view.export.excel-module.html#brdTopLeft"><a title="Camelot.camelot.view.export.excel.brdTopLeft" class="py-name" href="#" onclick="return doclink('link-24', 'brdTopLeft', 'link-24');">brdTopLeft</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Borders</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L63"></a><tt class="py-lineno"> 63</tt> <tt class="py-line"><tt id="link-25" class="py-name"><a title="Camelot.camelot.view.export.excel.brdTopLeft" class="py-name" href="#" onclick="return doclink('link-25', 'brdTopLeft', 'link-24');">brdTopLeft</a></tt><tt class="py-op">.</tt><tt class="py-name">top</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L64"></a><tt class="py-lineno"> 64</tt> <tt class="py-line"><tt id="link-26" class="py-name"><a title="Camelot.camelot.view.export.excel.brdTopLeft" class="py-name" href="#" onclick="return doclink('link-26', 'brdTopLeft', 'link-24');">brdTopLeft</a></tt><tt class="py-op">.</tt><tt class="py-name">left</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L65"></a><tt class="py-lineno"> 65</tt> <tt class="py-line"> </tt>
<a name="L66"></a><tt class="py-lineno"> 66</tt> <tt class="py-line"><tt id="link-27" class="py-name" targets="Variable Camelot.camelot.view.export.excel.brdBottomLeft=Camelot.camelot.view.export.excel-module.html#brdBottomLeft"><a title="Camelot.camelot.view.export.excel.brdBottomLeft" class="py-name" href="#" onclick="return doclink('link-27', 'brdBottomLeft', 'link-27');">brdBottomLeft</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Borders</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L67"></a><tt class="py-lineno"> 67</tt> <tt class="py-line"><tt id="link-28" class="py-name"><a title="Camelot.camelot.view.export.excel.brdBottomLeft" class="py-name" href="#" onclick="return doclink('link-28', 'brdBottomLeft', 'link-27');">brdBottomLeft</a></tt><tt class="py-op">.</tt><tt class="py-name">bottom</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L68"></a><tt class="py-lineno"> 68</tt> <tt class="py-line"><tt id="link-29" class="py-name"><a title="Camelot.camelot.view.export.excel.brdBottomLeft" class="py-name" href="#" onclick="return doclink('link-29', 'brdBottomLeft', 'link-27');">brdBottomLeft</a></tt><tt class="py-op">.</tt><tt class="py-name">left</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L69"></a><tt class="py-lineno"> 69</tt> <tt class="py-line"> </tt>
<a name="L70"></a><tt class="py-lineno"> 70</tt> <tt class="py-line"><tt id="link-30" class="py-name" targets="Variable Camelot.camelot.view.export.excel.brdBottomRight=Camelot.camelot.view.export.excel-module.html#brdBottomRight"><a title="Camelot.camelot.view.export.excel.brdBottomRight" class="py-name" href="#" onclick="return doclink('link-30', 'brdBottomRight', 'link-30');">brdBottomRight</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Borders</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L71"></a><tt class="py-lineno"> 71</tt> <tt class="py-line"><tt id="link-31" class="py-name"><a title="Camelot.camelot.view.export.excel.brdBottomRight" class="py-name" href="#" onclick="return doclink('link-31', 'brdBottomRight', 'link-30');">brdBottomRight</a></tt><tt class="py-op">.</tt><tt class="py-name">bottom</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L72"></a><tt class="py-lineno"> 72</tt> <tt class="py-line"><tt id="link-32" class="py-name"><a title="Camelot.camelot.view.export.excel.brdBottomRight" class="py-name" href="#" onclick="return doclink('link-32', 'brdBottomRight', 'link-30');">brdBottomRight</a></tt><tt class="py-op">.</tt><tt class="py-name">right</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L73"></a><tt class="py-lineno"> 73</tt> <tt class="py-line"> </tt>
<a name="L74"></a><tt class="py-lineno"> 74</tt> <tt class="py-line"><tt id="link-33" class="py-name" targets="Variable Camelot.camelot.view.export.excel.brdTopRight=Camelot.camelot.view.export.excel-module.html#brdTopRight"><a title="Camelot.camelot.view.export.excel.brdTopRight" class="py-name" href="#" onclick="return doclink('link-33', 'brdTopRight', 'link-33');">brdTopRight</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Borders</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L75"></a><tt class="py-lineno"> 75</tt> <tt class="py-line"><tt id="link-34" class="py-name"><a title="Camelot.camelot.view.export.excel.brdTopRight" class="py-name" href="#" onclick="return doclink('link-34', 'brdTopRight', 'link-33');">brdTopRight</a></tt><tt class="py-op">.</tt><tt class="py-name">top</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L76"></a><tt class="py-lineno"> 76</tt> <tt class="py-line"><tt id="link-35" class="py-name"><a title="Camelot.camelot.view.export.excel.brdTopRight" class="py-name" href="#" onclick="return doclink('link-35', 'brdTopRight', 'link-33');">brdTopRight</a></tt><tt class="py-op">.</tt><tt class="py-name">right</tt> <tt class="py-op">=</tt> <tt class="py-number">0x01</tt> </tt>
<a name="L77"></a><tt class="py-lineno"> 77</tt> <tt class="py-line"> </tt>
<a name="L78"></a><tt class="py-lineno"> 78</tt> <tt class="py-line"><tt id="link-36" class="py-name" targets="Variable Camelot.camelot.view.export.excel.dateStyle=Camelot.camelot.view.export.excel-module.html#dateStyle"><a title="Camelot.camelot.view.export.excel.dateStyle" class="py-name" href="#" onclick="return doclink('link-36', 'dateStyle', 'link-36');">dateStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L79"></a><tt class="py-lineno"> 79</tt> <tt class="py-line"> </tt>
<a name="L80"></a><tt class="py-lineno"> 80</tt> <tt class="py-line"> </tt>
<a name="L81"></a><tt class="py-lineno"> 81</tt> <tt class="py-line"><tt id="link-37" class="py-name" targets="Variable Camelot.camelot.view.export.excel.titleStyle=Camelot.camelot.view.export.excel-module.html#titleStyle"><a title="Camelot.camelot.view.export.excel.titleStyle" class="py-name" href="#" onclick="return doclink('link-37', 'titleStyle', 'link-37');">titleStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L82"></a><tt class="py-lineno"> 82</tt> <tt class="py-line"><tt id="link-38" class="py-name" targets="Variable Camelot.camelot.view.export.excel.headerStyle=Camelot.camelot.view.export.excel-module.html#headerStyle"><a title="Camelot.camelot.view.export.excel.headerStyle" class="py-name" href="#" onclick="return doclink('link-38', 'headerStyle', 'link-38');">headerStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L83"></a><tt class="py-lineno"> 83</tt> <tt class="py-line"><tt id="link-39" class="py-name" targets="Variable Camelot.camelot.view.export.excel.cellStyle=Camelot.camelot.view.export.excel-module.html#cellStyle"><a title="Camelot.camelot.view.export.excel.cellStyle" class="py-name" href="#" onclick="return doclink('link-39', 'cellStyle', 'link-39');">cellStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L84"></a><tt class="py-lineno"> 84</tt> <tt class="py-line"><tt id="link-40" class="py-name"><a title="Camelot.camelot.view.export.excel.dateStyle" class="py-name" href="#" onclick="return doclink('link-40', 'dateStyle', 'link-36');">dateStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L85"></a><tt class="py-lineno"> 85</tt> <tt class="py-line"> </tt>
<a name="L86"></a><tt class="py-lineno"> 86</tt> <tt class="py-line"><tt id="link-41" class="py-name" targets="Variable Camelot.camelot.view.export.excel.leftCellStyle=Camelot.camelot.view.export.excel-module.html#leftCellStyle"><a title="Camelot.camelot.view.export.excel.leftCellStyle" class="py-name" href="#" onclick="return doclink('link-41', 'leftCellStyle', 'link-41');">leftCellStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L87"></a><tt class="py-lineno"> 87</tt> <tt class="py-line"><tt id="link-42" class="py-name" targets="Variable Camelot.camelot.view.export.excel.rightCellStyle=Camelot.camelot.view.export.excel-module.html#rightCellStyle"><a title="Camelot.camelot.view.export.excel.rightCellStyle" class="py-name" href="#" onclick="return doclink('link-42', 'rightCellStyle', 'link-42');">rightCellStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L88"></a><tt class="py-lineno"> 88</tt> <tt class="py-line"><tt id="link-43" class="py-name" targets="Variable Camelot.camelot.view.export.excel.bottomCellStyle=Camelot.camelot.view.export.excel-module.html#bottomCellStyle"><a title="Camelot.camelot.view.export.excel.bottomCellStyle" class="py-name" href="#" onclick="return doclink('link-43', 'bottomCellStyle', 'link-43');">bottomCellStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L89"></a><tt class="py-lineno"> 89</tt> <tt class="py-line"><tt id="link-44" class="py-name" targets="Variable Camelot.camelot.view.export.excel.topleftCellStyle=Camelot.camelot.view.export.excel-module.html#topleftCellStyle"><a title="Camelot.camelot.view.export.excel.topleftCellStyle" class="py-name" href="#" onclick="return doclink('link-44', 'topleftCellStyle', 'link-44');">topleftCellStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L90"></a><tt class="py-lineno"> 90</tt> <tt class="py-line"><tt id="link-45" class="py-name" targets="Variable Camelot.camelot.view.export.excel.bottomleftCellStyle=Camelot.camelot.view.export.excel-module.html#bottomleftCellStyle"><a title="Camelot.camelot.view.export.excel.bottomleftCellStyle" class="py-name" href="#" onclick="return doclink('link-45', 'bottomleftCellStyle', 'link-45');">bottomleftCellStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L91"></a><tt class="py-lineno"> 91</tt> <tt class="py-line"><tt id="link-46" class="py-name" targets="Variable Camelot.camelot.view.export.excel.bottomrightCellStyle=Camelot.camelot.view.export.excel-module.html#bottomrightCellStyle"><a title="Camelot.camelot.view.export.excel.bottomrightCellStyle" class="py-name" href="#" onclick="return doclink('link-46', 'bottomrightCellStyle', 'link-46');">bottomrightCellStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L92"></a><tt class="py-lineno"> 92</tt> <tt class="py-line"><tt id="link-47" class="py-name" targets="Variable Camelot.camelot.view.export.excel.toprightCellStyle=Camelot.camelot.view.export.excel-module.html#toprightCellStyle"><a title="Camelot.camelot.view.export.excel.toprightCellStyle" class="py-name" href="#" onclick="return doclink('link-47', 'toprightCellStyle', 'link-47');">toprightCellStyle</a></tt> <tt class="py-op">=</tt> <tt class="py-name">XFStyle</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L93"></a><tt class="py-lineno"> 93</tt> <tt class="py-line"> </tt>
<a name="L94"></a><tt class="py-lineno"> 94</tt> <tt class="py-line"><tt id="link-48" class="py-name"><a title="Camelot.camelot.view.export.excel.titleStyle" class="py-name" href="#" onclick="return doclink('link-48', 'titleStyle', 'link-37');">titleStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-49" class="py-name"><a title="Camelot.camelot.view.export.excel.titleFont" class="py-name" href="#" onclick="return doclink('link-49', 'titleFont', 'link-1');">titleFont</a></tt> </tt>
<a name="L95"></a><tt class="py-lineno"> 95</tt> <tt class="py-line"><tt id="link-50" class="py-name"><a title="Camelot.camelot.view.export.excel.headerStyle" class="py-name" href="#" onclick="return doclink('link-50', 'headerStyle', 'link-38');">headerStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-51" class="py-name"><a title="Camelot.camelot.view.export.excel.headerFont" class="py-name" href="#" onclick="return doclink('link-51', 'headerFont', 'link-2');">headerFont</a></tt> </tt>
<a name="L96"></a><tt class="py-lineno"> 96</tt> <tt class="py-line"><tt id="link-52" class="py-name"><a title="Camelot.camelot.view.export.excel.headerStyle" class="py-name" href="#" onclick="return doclink('link-52', 'headerStyle', 'link-38');">headerStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">borders</tt> <tt class="py-op">=</tt> <tt id="link-53" class="py-name"><a title="Camelot.camelot.view.export.excel.brdTop" class="py-name" href="#" onclick="return doclink('link-53', 'brdTop', 'link-20');">brdTop</a></tt> </tt>
<a name="L97"></a><tt class="py-lineno"> 97</tt> <tt class="py-line"><tt id="link-54" class="py-name"><a title="Camelot.camelot.view.export.excel.cellStyle" class="py-name" href="#" onclick="return doclink('link-54', 'cellStyle', 'link-39');">cellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-55" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-55', 'cellFont', 'link-3');">cellFont</a></tt> </tt>
<a name="L98"></a><tt class="py-lineno"> 98</tt> <tt class="py-line"> </tt>
<a name="L99"></a><tt class="py-lineno"> 99</tt> <tt class="py-line"><tt id="link-56" class="py-name"><a title="Camelot.camelot.view.export.excel.topleftCellStyle" class="py-name" href="#" onclick="return doclink('link-56', 'topleftCellStyle', 'link-44');">topleftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-57" class="py-name"><a title="Camelot.camelot.view.export.excel.headerFont" class="py-name" href="#" onclick="return doclink('link-57', 'headerFont', 'link-2');">headerFont</a></tt> </tt>
<a name="L100"></a><tt class="py-lineno">100</tt> <tt class="py-line"><tt id="link-58" class="py-name"><a title="Camelot.camelot.view.export.excel.topleftCellStyle" class="py-name" href="#" onclick="return doclink('link-58', 'topleftCellStyle', 'link-44');">topleftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">borders</tt> <tt class="py-op">=</tt> <tt id="link-59" class="py-name"><a title="Camelot.camelot.view.export.excel.brdTopLeft" class="py-name" href="#" onclick="return doclink('link-59', 'brdTopLeft', 'link-24');">brdTopLeft</a></tt> </tt>
<a name="L101"></a><tt class="py-lineno">101</tt> <tt class="py-line"> </tt>
<a name="L102"></a><tt class="py-lineno">102</tt> <tt class="py-line"><tt id="link-60" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomleftCellStyle" class="py-name" href="#" onclick="return doclink('link-60', 'bottomleftCellStyle', 'link-45');">bottomleftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-61" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-61', 'cellFont', 'link-3');">cellFont</a></tt> </tt>
<a name="L103"></a><tt class="py-lineno">103</tt> <tt class="py-line"><tt id="link-62" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomleftCellStyle" class="py-name" href="#" onclick="return doclink('link-62', 'bottomleftCellStyle', 'link-45');">bottomleftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">borders</tt> <tt class="py-op">=</tt> <tt id="link-63" class="py-name"><a title="Camelot.camelot.view.export.excel.brdBottomLeft" class="py-name" href="#" onclick="return doclink('link-63', 'brdBottomLeft', 'link-27');">brdBottomLeft</a></tt> </tt>
<a name="L104"></a><tt class="py-lineno">104</tt> <tt class="py-line"> </tt>
<a name="L105"></a><tt class="py-lineno">105</tt> <tt class="py-line"><tt id="link-64" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomrightCellStyle" class="py-name" href="#" onclick="return doclink('link-64', 'bottomrightCellStyle', 'link-46');">bottomrightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-65" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-65', 'cellFont', 'link-3');">cellFont</a></tt> </tt>
<a name="L106"></a><tt class="py-lineno">106</tt> <tt class="py-line"><tt id="link-66" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomrightCellStyle" class="py-name" href="#" onclick="return doclink('link-66', 'bottomrightCellStyle', 'link-46');">bottomrightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">borders</tt> <tt class="py-op">=</tt> <tt id="link-67" class="py-name"><a title="Camelot.camelot.view.export.excel.brdBottomRight" class="py-name" href="#" onclick="return doclink('link-67', 'brdBottomRight', 'link-30');">brdBottomRight</a></tt> </tt>
<a name="L107"></a><tt class="py-lineno">107</tt> <tt class="py-line"> </tt>
<a name="L108"></a><tt class="py-lineno">108</tt> <tt class="py-line"><tt id="link-68" class="py-name"><a title="Camelot.camelot.view.export.excel.toprightCellStyle" class="py-name" href="#" onclick="return doclink('link-68', 'toprightCellStyle', 'link-47');">toprightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-69" class="py-name"><a title="Camelot.camelot.view.export.excel.headerFont" class="py-name" href="#" onclick="return doclink('link-69', 'headerFont', 'link-2');">headerFont</a></tt> </tt>
<a name="L109"></a><tt class="py-lineno">109</tt> <tt class="py-line"><tt id="link-70" class="py-name"><a title="Camelot.camelot.view.export.excel.toprightCellStyle" class="py-name" href="#" onclick="return doclink('link-70', 'toprightCellStyle', 'link-47');">toprightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">borders</tt> <tt class="py-op">=</tt> <tt id="link-71" class="py-name"><a title="Camelot.camelot.view.export.excel.brdTopRight" class="py-name" href="#" onclick="return doclink('link-71', 'brdTopRight', 'link-33');">brdTopRight</a></tt> </tt>
<a name="L110"></a><tt class="py-lineno">110</tt> <tt class="py-line"> </tt>
<a name="L111"></a><tt class="py-lineno">111</tt> <tt class="py-line"><tt id="link-72" class="py-name"><a title="Camelot.camelot.view.export.excel.leftCellStyle" class="py-name" href="#" onclick="return doclink('link-72', 'leftCellStyle', 'link-41');">leftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">borders</tt> <tt class="py-op">=</tt> <tt id="link-73" class="py-name"><a title="Camelot.camelot.view.export.excel.brdLeft" class="py-name" href="#" onclick="return doclink('link-73', 'brdLeft', 'link-16');">brdLeft</a></tt> </tt>
<a name="L112"></a><tt class="py-lineno">112</tt> <tt class="py-line"><tt id="link-74" class="py-name"><a title="Camelot.camelot.view.export.excel.leftCellStyle" class="py-name" href="#" onclick="return doclink('link-74', 'leftCellStyle', 'link-41');">leftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-75" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-75', 'cellFont', 'link-3');">cellFont</a></tt> </tt>
<a name="L113"></a><tt class="py-lineno">113</tt> <tt class="py-line"> </tt>
<a name="L114"></a><tt class="py-lineno">114</tt> <tt class="py-line"><tt id="link-76" class="py-name"><a title="Camelot.camelot.view.export.excel.rightCellStyle" class="py-name" href="#" onclick="return doclink('link-76', 'rightCellStyle', 'link-42');">rightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">borders</tt> <tt class="py-op">=</tt> <tt id="link-77" class="py-name"><a title="Camelot.camelot.view.export.excel.brdRight" class="py-name" href="#" onclick="return doclink('link-77', 'brdRight', 'link-18');">brdRight</a></tt> </tt>
<a name="L115"></a><tt class="py-lineno">115</tt> <tt class="py-line"><tt id="link-78" class="py-name"><a title="Camelot.camelot.view.export.excel.rightCellStyle" class="py-name" href="#" onclick="return doclink('link-78', 'rightCellStyle', 'link-42');">rightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-79" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-79', 'cellFont', 'link-3');">cellFont</a></tt> </tt>
<a name="L116"></a><tt class="py-lineno">116</tt> <tt class="py-line"> </tt>
<a name="L117"></a><tt class="py-lineno">117</tt> <tt class="py-line"><tt id="link-80" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomCellStyle" class="py-name" href="#" onclick="return doclink('link-80', 'bottomCellStyle', 'link-43');">bottomCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">borders</tt> <tt class="py-op">=</tt> <tt id="link-81" class="py-name"><a title="Camelot.camelot.view.export.excel.brdBottom" class="py-name" href="#" onclick="return doclink('link-81', 'brdBottom', 'link-22');">brdBottom</a></tt> </tt>
<a name="L118"></a><tt class="py-lineno">118</tt> <tt class="py-line"><tt id="link-82" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomCellStyle" class="py-name" href="#" onclick="return doclink('link-82', 'bottomCellStyle', 'link-43');">bottomCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">font</tt> <tt class="py-op">=</tt> <tt id="link-83" class="py-name"><a title="Camelot.camelot.view.export.excel.cellFont" class="py-name" href="#" onclick="return doclink('link-83', 'cellFont', 'link-3');">cellFont</a></tt> </tt>
<a name="L119"></a><tt class="py-lineno">119</tt> <tt class="py-line"> </tt>
<a name="L120"></a><tt class="py-lineno">120</tt> <tt class="py-line"><tt id="link-84" class="py-name" targets="Variable Camelot.camelot.view.export.excel.pat1=Camelot.camelot.view.export.excel-module.html#pat1"><a title="Camelot.camelot.view.export.excel.pat1" class="py-name" href="#" onclick="return doclink('link-84', 'pat1', 'link-84');">pat1</a></tt> <tt class="py-op">=</tt> <tt class="py-name">Pattern</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L121"></a><tt class="py-lineno">121</tt> <tt class="py-line"><tt id="link-85" class="py-name"><a title="Camelot.camelot.view.export.excel.pat1" class="py-name" href="#" onclick="return doclink('link-85', 'pat1', 'link-84');">pat1</a></tt><tt class="py-op">.</tt><tt class="py-name">pattern</tt> <tt class="py-op">=</tt> <tt class="py-name">Pattern</tt><tt class="py-op">.</tt><tt class="py-name">SOLID_PATTERN</tt> </tt>
<a name="L122"></a><tt class="py-lineno">122</tt> <tt class="py-line"><tt id="link-86" class="py-name"><a title="Camelot.camelot.view.export.excel.pat1" class="py-name" href="#" onclick="return doclink('link-86', 'pat1', 'link-84');">pat1</a></tt><tt class="py-op">.</tt><tt class="py-name">pattern_fore_colour</tt> <tt class="py-op">=</tt> <tt class="py-number">0x16</tt> </tt>
<a name="L123"></a><tt class="py-lineno">123</tt> <tt class="py-line"><tt id="link-87" class="py-name"><a title="Camelot.camelot.view.export.excel.headerStyle" class="py-name" href="#" onclick="return doclink('link-87', 'headerStyle', 'link-38');">headerStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">pattern</tt> <tt class="py-op">=</tt> <tt id="link-88" class="py-name"><a title="Camelot.camelot.view.export.excel.pat1" class="py-name" href="#" onclick="return doclink('link-88', 'pat1', 'link-84');">pat1</a></tt> </tt>
<a name="L124"></a><tt class="py-lineno">124</tt> <tt class="py-line"><tt id="link-89" class="py-name"><a title="Camelot.camelot.view.export.excel.topleftCellStyle" class="py-name" href="#" onclick="return doclink('link-89', 'topleftCellStyle', 'link-44');">topleftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">pattern</tt> <tt class="py-op">=</tt> <tt id="link-90" class="py-name"><a title="Camelot.camelot.view.export.excel.pat1" class="py-name" href="#" onclick="return doclink('link-90', 'pat1', 'link-84');">pat1</a></tt> </tt>
<a name="L125"></a><tt class="py-lineno">125</tt> <tt class="py-line"><tt id="link-91" class="py-name"><a title="Camelot.camelot.view.export.excel.toprightCellStyle" class="py-name" href="#" onclick="return doclink('link-91', 'toprightCellStyle', 'link-47');">toprightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">pattern</tt> <tt class="py-op">=</tt> <tt id="link-92" class="py-name"><a title="Camelot.camelot.view.export.excel.pat1" class="py-name" href="#" onclick="return doclink('link-92', 'pat1', 'link-84');">pat1</a></tt> </tt>
<a name="L126"></a><tt class="py-lineno">126</tt> <tt class="py-line"> </tt>
<a name="open_data_with_excel"></a><div id="open_data_with_excel-def"><a name="L127"></a><tt class="py-lineno">127</tt> <a class="py-toggle" href="#" id="open_data_with_excel-toggle" onclick="return toggle('open_data_with_excel');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="Camelot.camelot.view.export.excel-module.html#open_data_with_excel">open_data_with_excel</a><tt class="py-op">(</tt><tt class="py-param">title</tt><tt class="py-op">,</tt> <tt class="py-param">headerList</tt><tt class="py-op">,</tt> <tt class="py-param">dataList</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="open_data_with_excel-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="open_data_with_excel-expanded"><a name="L128"></a><tt class="py-lineno">128</tt> <tt class="py-line"> <tt class="py-keyword">import</tt> <tt class="py-name">sys</tt> </tt>
<a name="L129"></a><tt class="py-lineno">129</tt> <tt class="py-line"> <tt class="py-keyword">import</tt> <tt class="py-name">tempfile</tt> </tt>
<a name="L130"></a><tt class="py-lineno">130</tt> <tt class="py-line"> <tt class="py-name">_xls_fd</tt><tt class="py-op">,</tt> <tt class="py-name">xls_fn</tt> <tt class="py-op">=</tt> <tt class="py-name">tempfile</tt><tt class="py-op">.</tt><tt class="py-name">mkstemp</tt><tt class="py-op">(</tt><tt id="link-93" class="py-name" targets="Variable Camelot.camelot.admin.list_action.OpenFileListAction.suffix=Camelot.camelot.admin.list_action.OpenFileListAction-class.html#suffix"><a title="Camelot.camelot.admin.list_action.OpenFileListAction.suffix" class="py-name" href="#" onclick="return doclink('link-93', 'suffix', 'link-93');">suffix</a></tt><tt class="py-op">=</tt><tt class="py-string">'.xls'</tt><tt class="py-op">)</tt> </tt>
<a name="L131"></a><tt class="py-lineno">131</tt> <tt class="py-line"> <tt id="link-94" class="py-name" targets="Function Camelot.camelot.view.export.excel.write_data_to_excel()=Camelot.camelot.view.export.excel-module.html#write_data_to_excel"><a title="Camelot.camelot.view.export.excel.write_data_to_excel" class="py-name" href="#" onclick="return doclink('link-94', 'write_data_to_excel', 'link-94');">write_data_to_excel</a></tt><tt class="py-op">(</tt><tt class="py-name">xls_fn</tt><tt class="py-op">,</tt> <tt id="link-95" class="py-name" targets="Variable Camelot.camelot.model.authentication.DirectedDirector.title=Camelot.camelot.model.authentication.DirectedDirector-class.html#title,Variable Camelot.camelot.view.wizard.backup.BackupPage.title=Camelot.camelot.view.wizard.backup.BackupPage-class.html#title,Variable Camelot.camelot.view.wizard.backup.RestorePage.title=Camelot.camelot.view.wizard.backup.RestorePage-class.html#title,Variable Camelot.camelot.view.wizard.backup.SelectBackupFile.title=Camelot.camelot.view.wizard.backup.SelectBackupFile-class.html#title,Variable Camelot.camelot.view.wizard.backup.SelectRestoreFile.title=Camelot.camelot.view.wizard.backup.SelectRestoreFile-class.html#title,Variable Camelot.camelot.view.wizard.pages.form_page.FormPage.title=Camelot.camelot.view.wizard.pages.form_page.FormPage-class.html#title,Variable Camelot.camelot.view.wizard.pages.progress_page.ProgressPage.title=Camelot.camelot.view.wizard.pages.progress_page.ProgressPage-class.html#title,Variable Camelot.camelot.view.wizard.pages.select.SelectFilePage.title=Camelot.camelot.view.wizard.pages.select.SelectFilePage-class.html#title,Variable Camelot.camelot.view.wizard.update_value.ReplaceContentsPage.title=Camelot.camelot.view.wizard.update_value.ReplaceContentsPage-class.html#title,Variable Camelot.camelot.view.wizard.update_value.SelectValuePage.title=Camelot.camelot.view.wizard.update_value.SelectValuePage-class.html#title,Variable camelot.view.wizard.pages.select.SelectFilePage.title=camelot.view.wizard.pages.select.SelectFilePage-class.html#title"><a title="Camelot.camelot.model.authentication.DirectedDirector.title
Camelot.camelot.view.wizard.backup.BackupPage.title
Camelot.camelot.view.wizard.backup.RestorePage.title
Camelot.camelot.view.wizard.backup.SelectBackupFile.title
Camelot.camelot.view.wizard.backup.SelectRestoreFile.title
Camelot.camelot.view.wizard.pages.form_page.FormPage.title
Camelot.camelot.view.wizard.pages.progress_page.ProgressPage.title
Camelot.camelot.view.wizard.pages.select.SelectFilePage.title
Camelot.camelot.view.wizard.update_value.ReplaceContentsPage.title
Camelot.camelot.view.wizard.update_value.SelectValuePage.title
camelot.view.wizard.pages.select.SelectFilePage.title" class="py-name" href="#" onclick="return doclink('link-95', 'title', 'link-95');">title</a></tt><tt class="py-op">,</tt> <tt class="py-name">headerList</tt><tt class="py-op">,</tt> <tt class="py-name">dataList</tt><tt class="py-op">)</tt> </tt>
<a name="L132"></a><tt class="py-lineno">132</tt> <tt class="py-line"> <tt class="py-keyword">from</tt> <tt class="py-name">PyQt4</tt> <tt class="py-keyword">import</tt> <tt class="py-name">QtGui</tt><tt class="py-op">,</tt> <tt class="py-name">QtCore</tt> </tt>
<a name="L133"></a><tt class="py-lineno">133</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-string">'win'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">sys</tt><tt class="py-op">.</tt><tt class="py-name">platform</tt><tt class="py-op">:</tt> </tt>
<a name="L134"></a><tt class="py-lineno">134</tt> <tt class="py-line"> <tt class="py-name">QtGui</tt><tt class="py-op">.</tt><tt class="py-name">QDesktopServices</tt><tt class="py-op">.</tt><tt class="py-name">openUrl</tt><tt class="py-op">(</tt><tt class="py-name">QtCore</tt><tt class="py-op">.</tt><tt class="py-name">QUrl</tt><tt class="py-op">(</tt><tt class="py-string">'file://%s'</tt> <tt class="py-op">%</tt> <tt class="py-name">xls_fn</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L135"></a><tt class="py-lineno">135</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L136"></a><tt class="py-lineno">136</tt> <tt class="py-line"> <tt class="py-keyword">import</tt> <tt class="py-name">pythoncom</tt> </tt>
<a name="L137"></a><tt class="py-lineno">137</tt> <tt class="py-line"> <tt class="py-keyword">import</tt> <tt class="py-name">win32com</tt><tt class="py-op">.</tt><tt class="py-name">client</tt> </tt>
<a name="L138"></a><tt class="py-lineno">138</tt> <tt class="py-line"> <tt class="py-name">pythoncom</tt><tt class="py-op">.</tt><tt class="py-name">CoInitialize</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L139"></a><tt class="py-lineno">139</tt> <tt class="py-line"> <tt class="py-name">excel_app</tt> <tt class="py-op">=</tt> <tt class="py-name">win32com</tt><tt class="py-op">.</tt><tt class="py-name">client</tt><tt class="py-op">.</tt><tt class="py-name">Dispatch</tt><tt class="py-op">(</tt><tt class="py-string">"Excel.Application"</tt><tt class="py-op">)</tt> </tt>
<a name="L140"></a><tt class="py-lineno">140</tt> <tt class="py-line"> <tt class="py-name">excel_app</tt><tt class="py-op">.</tt><tt class="py-name">Visible</tt> <tt class="py-op">=</tt> <tt class="py-name">True</tt> </tt>
<a name="L141"></a><tt class="py-lineno">141</tt> <tt class="py-line"> <tt class="py-name">excel_app</tt><tt class="py-op">.</tt><tt class="py-name">Workbooks</tt><tt class="py-op">.</tt><tt class="py-name">Open</tt><tt class="py-op">(</tt><tt class="py-name">xls_fn</tt><tt class="py-op">)</tt> </tt>
</div><a name="L142"></a><tt class="py-lineno">142</tt> <tt class="py-line"> </tt>
<a name="write_data_to_excel"></a><div id="write_data_to_excel-def"><a name="L143"></a><tt class="py-lineno">143</tt> <a class="py-toggle" href="#" id="write_data_to_excel-toggle" onclick="return toggle('write_data_to_excel');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="Camelot.camelot.view.export.excel-module.html#write_data_to_excel">write_data_to_excel</a><tt class="py-op">(</tt><tt class="py-param">filename</tt><tt class="py-op">,</tt> <tt class="py-param">title</tt><tt class="py-op">,</tt> <tt class="py-param">headerList</tt><tt class="py-op">,</tt> <tt class="py-param">dataList</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="write_data_to_excel-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="write_data_to_excel-expanded"><a name="L144"></a><tt class="py-lineno">144</tt> <tt class="py-line"> <tt class="py-docstring">"""</tt> </tt>
<a name="L145"></a><tt class="py-lineno">145</tt> <tt class="py-line"><tt class="py-docstring"> @param filename: the file to which to save the exported excel</tt> </tt>
<a name="L146"></a><tt class="py-lineno">146</tt> <tt class="py-line"><tt class="py-docstring"> @param title: title to put in the first row of the genarated excel file</tt> </tt>
<a name="L147"></a><tt class="py-lineno">147</tt> <tt class="py-line"><tt class="py-docstring"> @param headerList: list of header definitions</tt> </tt>
<a name="L148"></a><tt class="py-lineno">148</tt> <tt class="py-line"><tt class="py-docstring"> @param dataList: list or generator with the row data</tt> </tt>
<a name="L149"></a><tt class="py-lineno">149</tt> <tt class="py-line"><tt class="py-docstring"> """</tt> </tt>
<a name="L150"></a><tt class="py-lineno">150</tt> <tt class="py-line"> <tt class="py-name">w</tt> <tt class="py-op">=</tt> <tt class="py-name">Workbook</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L151"></a><tt class="py-lineno">151</tt> <tt class="py-line"> <tt class="py-name">ws</tt> <tt class="py-op">=</tt> <tt class="py-name">w</tt><tt class="py-op">.</tt><tt class="py-name">add_sheet</tt><tt class="py-op">(</tt><tt class="py-string">'Sheet1'</tt><tt class="py-op">)</tt> </tt>
<a name="L152"></a><tt class="py-lineno">152</tt> <tt class="py-line"> <tt class="py-comment">## Writing Title</tt> </tt>
<a name="L153"></a><tt class="py-lineno">153</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-96" class="py-name" targets="Method Camelot.camelot.bin.camelot_manage.FileCacher.write()=Camelot.camelot.bin.camelot_manage.FileCacher-class.html#write"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-96', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt class="py-number">0</tt><tt class="py-op">,</tt> <tt class="py-number">0</tt><tt class="py-op">,</tt> <tt id="link-97" class="py-name"><a title="Camelot.camelot.model.authentication.DirectedDirector.title
Camelot.camelot.view.wizard.backup.BackupPage.title
Camelot.camelot.view.wizard.backup.RestorePage.title
Camelot.camelot.view.wizard.backup.SelectBackupFile.title
Camelot.camelot.view.wizard.backup.SelectRestoreFile.title
Camelot.camelot.view.wizard.pages.form_page.FormPage.title
Camelot.camelot.view.wizard.pages.progress_page.ProgressPage.title
Camelot.camelot.view.wizard.pages.select.SelectFilePage.title
Camelot.camelot.view.wizard.update_value.ReplaceContentsPage.title
Camelot.camelot.view.wizard.update_value.SelectValuePage.title
camelot.view.wizard.pages.select.SelectFilePage.title" class="py-name" href="#" onclick="return doclink('link-97', 'title', 'link-95');">title</a></tt><tt class="py-op">,</tt> <tt id="link-98" class="py-name"><a title="Camelot.camelot.view.export.excel.titleStyle" class="py-name" href="#" onclick="return doclink('link-98', 'titleStyle', 'link-37');">titleStyle</a></tt><tt class="py-op">)</tt> <tt class="py-comment"># Writing Title</tt> </tt>
<a name="L154"></a><tt class="py-lineno">154</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt class="py-name">col</tt><tt class="py-op">(</tt><tt class="py-number">0</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">width</tt> <tt class="py-op">=</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt id="link-99" class="py-name"><a title="Camelot.camelot.model.authentication.DirectedDirector.title
Camelot.camelot.view.wizard.backup.BackupPage.title
Camelot.camelot.view.wizard.backup.RestorePage.title
Camelot.camelot.view.wizard.backup.SelectBackupFile.title
Camelot.camelot.view.wizard.backup.SelectRestoreFile.title
Camelot.camelot.view.wizard.pages.form_page.FormPage.title
Camelot.camelot.view.wizard.pages.progress_page.ProgressPage.title
Camelot.camelot.view.wizard.pages.select.SelectFilePage.title
Camelot.camelot.view.wizard.update_value.ReplaceContentsPage.title
Camelot.camelot.view.wizard.update_value.SelectValuePage.title
camelot.view.wizard.pages.select.SelectFilePage.title" class="py-name" href="#" onclick="return doclink('link-99', 'title', 'link-95');">title</a></tt><tt class="py-op">)</tt> <tt class="py-op">*</tt> <tt class="py-number">400</tt> <tt class="py-comment"># Setting cell width</tt> </tt>
<a name="L155"></a><tt class="py-lineno">155</tt> <tt class="py-line"> <tt class="py-comment">## Writing Header</tt> </tt>
<a name="L156"></a><tt class="py-lineno">156</tt> <tt class="py-line"> <tt class="py-name">myDataTypeDict</tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> <tt class="py-comment"># dictionary of datatype, {columnnumber, Datatype}</tt> </tt>
<a name="L157"></a><tt class="py-lineno">157</tt> <tt class="py-line"> <tt class="py-name">myPrecisionDict</tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> <tt class="py-comment"># dictionary of precision , {columnnumber, Precision}</tt> </tt>
<a name="L158"></a><tt class="py-lineno">158</tt> <tt class="py-line"> <tt class="py-name">myLengthDict</tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> <tt class="py-comment"># dictionary of length , {columnnumber, length}</tt> </tt>
<a name="L159"></a><tt class="py-lineno">159</tt> <tt class="py-line"> <tt class="py-name">myFormatDict</tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> <tt class="py-comment"># dictionary of dateformat , {columnnumber, format}</tt> </tt>
<a name="L160"></a><tt class="py-lineno">160</tt> <tt class="py-line"> <tt class="py-keyword">for</tt> <tt class="py-name">n</tt><tt class="py-op">,</tt><tt id="link-100" class="py-name" targets="Variable Camelot.camelot.bin.camelot_admin.desc=Camelot.camelot.bin.camelot_admin-module.html#desc,Variable Camelot.camelot.bin.camelot_manage.desc=Camelot.camelot.bin.camelot_manage-module.html#desc"><a title="Camelot.camelot.bin.camelot_admin.desc
Camelot.camelot.bin.camelot_manage.desc" class="py-name" href="#" onclick="return doclink('link-100', 'desc', 'link-100');">desc</a></tt> <tt class="py-keyword">in</tt> <tt class="py-name">enumerate</tt><tt class="py-op">(</tt><tt class="py-name">headerList</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L161"></a><tt class="py-lineno">161</tt> <tt class="py-line"> <tt class="py-name">lst</tt> <tt class="py-op">=</tt> <tt id="link-101" class="py-name"><a title="Camelot.camelot.bin.camelot_admin.desc
Camelot.camelot.bin.camelot_manage.desc" class="py-name" href="#" onclick="return doclink('link-101', 'desc', 'link-100');">desc</a></tt><tt class="py-op">[</tt><tt class="py-number">1</tt><tt class="py-op">]</tt> </tt>
<a name="L162"></a><tt class="py-lineno">162</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">n</tt><tt class="py-op">==</tt><tt class="py-number">0</tt><tt class="py-op">:</tt> </tt>
<a name="L163"></a><tt class="py-lineno">163</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-102" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-102', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt class="py-number">2</tt><tt class="py-op">,</tt> <tt class="py-name">n</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">(</tt><tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">'name'</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt id="link-103" class="py-name"><a title="Camelot.camelot.view.export.excel.topleftCellStyle" class="py-name" href="#" onclick="return doclink('link-103', 'topleftCellStyle', 'link-44');">topleftCellStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L164"></a><tt class="py-lineno">164</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">n</tt><tt class="py-op">==</tt><tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">headerList</tt><tt class="py-op">)</tt><tt class="py-op">-</tt><tt class="py-number">1</tt><tt class="py-op">:</tt> </tt>
<a name="L165"></a><tt class="py-lineno">165</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-104" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-104', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt class="py-number">2</tt><tt class="py-op">,</tt> <tt class="py-name">n</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">(</tt><tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">'name'</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt id="link-105" class="py-name"><a title="Camelot.camelot.view.export.excel.toprightCellStyle" class="py-name" href="#" onclick="return doclink('link-105', 'toprightCellStyle', 'link-47');">toprightCellStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L166"></a><tt class="py-lineno">166</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L167"></a><tt class="py-lineno">167</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-106" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-106', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt class="py-number">2</tt><tt class="py-op">,</tt> <tt class="py-name">n</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">(</tt><tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">'name'</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt id="link-107" class="py-name"><a title="Camelot.camelot.view.export.excel.headerStyle" class="py-name" href="#" onclick="return doclink('link-107', 'headerStyle', 'link-38');">headerStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L168"></a><tt class="py-lineno">168</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">unicode</tt><tt class="py-op">(</tt><tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">'name'</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> <tt class="py-op"><</tt> <tt class="py-number">8</tt><tt class="py-op">:</tt> </tt>
<a name="L169"></a><tt class="py-lineno">169</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt class="py-name">col</tt><tt class="py-op">(</tt><tt class="py-name">n</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">width</tt> <tt class="py-op">=</tt> <tt class="py-number">8</tt> <tt class="py-op">*</tt> <tt class="py-number">375</tt> </tt>
<a name="L170"></a><tt class="py-lineno">170</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L171"></a><tt class="py-lineno">171</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt class="py-name">col</tt><tt class="py-op">(</tt><tt class="py-name">n</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">width</tt> <tt class="py-op">=</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">unicode</tt><tt class="py-op">(</tt><tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">'name'</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> <tt class="py-op">*</tt> <tt class="py-number">375</tt> </tt>
<a name="L172"></a><tt class="py-lineno">172</tt> <tt class="py-line"> <tt class="py-name">myDataTypeDict</tt><tt class="py-op">[</tt> <tt class="py-name">n</tt> <tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"python_type"</tt><tt class="py-op">]</tt> </tt>
<a name="L173"></a><tt class="py-lineno">173</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"python_type"</tt><tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">float</tt><tt class="py-op">:</tt> </tt>
<a name="L174"></a><tt class="py-lineno">174</tt> <tt class="py-line"> <tt class="py-name">myPrecisionDict</tt> <tt class="py-op">[</tt> <tt class="py-name">n</tt> <tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"precision"</tt><tt class="py-op">]</tt> <tt class="py-comment">#Populating precision dictionary</tt> </tt>
<a name="L175"></a><tt class="py-lineno">175</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"python_type"</tt><tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">datetime</tt><tt class="py-op">.</tt><tt id="link-108" class="py-name" targets="Variable Camelot.camelot.model.batch_job.BatchJob.date=Camelot.camelot.model.batch_job.BatchJob-class.html#date,Method Camelot.camelot.view.controls.editors.datetimeeditor.DateTimeEditor.date()=Camelot.camelot.view.controls.editors.datetimeeditor.DateTimeEditor-class.html#date"><a title="Camelot.camelot.model.batch_job.BatchJob.date
Camelot.camelot.view.controls.editors.datetimeeditor.DateTimeEditor.date" class="py-name" href="#" onclick="return doclink('link-108', 'date', 'link-108');">date</a></tt><tt class="py-op">:</tt> </tt>
<a name="L176"></a><tt class="py-lineno">176</tt> <tt class="py-line"> <tt class="py-name">myFormatDict</tt> <tt class="py-op">[</tt> <tt class="py-name">n</tt> <tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"format"</tt><tt class="py-op">]</tt> <tt class="py-comment">#Populating date Format dictionary</tt> </tt>
<a name="L177"></a><tt class="py-lineno">177</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"python_type"</tt><tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">datetime</tt><tt class="py-op">.</tt><tt class="py-name">datetime</tt><tt class="py-op">:</tt> </tt>
<a name="L178"></a><tt class="py-lineno">178</tt> <tt class="py-line"> <tt class="py-name">myFormatDict</tt> <tt class="py-op">[</tt> <tt class="py-name">n</tt> <tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"format"</tt><tt class="py-op">]</tt> <tt class="py-comment">#Populating date Format dictionary</tt> </tt>
<a name="L179"></a><tt class="py-lineno">179</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"python_type"</tt><tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">str</tt><tt class="py-op">:</tt> </tt>
<a name="L180"></a><tt class="py-lineno">180</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-string">'length'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">lst</tt><tt class="py-op">:</tt> </tt>
<a name="L181"></a><tt class="py-lineno">181</tt> <tt class="py-line"> <tt class="py-name">myLengthDict</tt> <tt class="py-op">[</tt> <tt class="py-name">n</tt> <tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">lst</tt><tt class="py-op">[</tt><tt class="py-string">"length"</tt><tt class="py-op">]</tt> <tt class="py-comment">#Populating Column Length dictionary</tt> </tt>
<a name="L182"></a><tt class="py-lineno">182</tt> <tt class="py-line"> <tt class="py-comment">## Writing Data</tt> </tt>
<a name="L183"></a><tt class="py-lineno">183</tt> <tt class="py-line"> <tt id="link-109" class="py-name" targets="Variable Camelot.camelot.view.field_attributes.row=Camelot.camelot.view.field_attributes-module.html#row"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-109', 'row', 'link-109');">row</a></tt> <tt class="py-op">=</tt> <tt class="py-number">3</tt> </tt>
<a name="L184"></a><tt class="py-lineno">184</tt> <tt class="py-line"> <tt class="py-name">column</tt> <tt class="py-op">=</tt> <tt class="py-number">0</tt> </tt>
<a name="L185"></a><tt class="py-lineno">185</tt> <tt class="py-line"> <tt class="py-name">valueAddedInSize</tt> <tt class="py-op">=</tt> <tt class="py-number">0</tt> </tt>
<a name="L186"></a><tt class="py-lineno">186</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">=</tt> <tt class="py-string">'0'</tt> </tt>
<a name="L187"></a><tt class="py-lineno">187</tt> <tt class="py-line"> <tt class="py-keyword">for</tt> <tt class="py-name">dictCounter</tt> <tt class="py-keyword">in</tt> <tt class="py-name">dataList</tt><tt class="py-op">:</tt> <tt class="py-comment"># iterating the dataList, having dictionary</tt> </tt>
<a name="L188"></a><tt class="py-lineno">188</tt> <tt class="py-line"> <tt class="py-name">column</tt> <tt class="py-op">=</tt> <tt class="py-number">0</tt> </tt>
<a name="L189"></a><tt class="py-lineno">189</tt> <tt class="py-line"> <tt id="link-110" class="py-name"><a title="Camelot.camelot.view.export.excel.cellStyle" class="py-name" href="#" onclick="return doclink('link-110', 'cellStyle', 'link-39');">cellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">num_format_str</tt> <tt class="py-op">=</tt> <tt class="py-string">'0'</tt> </tt>
<a name="L190"></a><tt class="py-lineno">190</tt> <tt class="py-line"> <tt class="py-keyword">for</tt> <tt class="py-name">i</tt> <tt class="py-keyword">in</tt> <tt class="py-name">range</tt><tt class="py-op">(</tt> <tt class="py-number">0</tt> <tt class="py-op">,</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">dictCounter</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> <tt class="py-comment">#for i in dictCounter:</tt> </tt>
<a name="L191"></a><tt class="py-lineno">191</tt> <tt class="py-line"> <tt class="py-name">valueAddedInSize</tt> <tt class="py-op">=</tt> <tt class="py-number">0</tt> </tt>
<a name="L192"></a><tt class="py-lineno">192</tt> <tt class="py-line"> <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-name">dictCounter</tt><tt class="py-op">[</tt><tt class="py-name">i</tt><tt class="py-op">]</tt> </tt>
<a name="L193"></a><tt class="py-lineno">193</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">val</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L194"></a><tt class="py-lineno">194</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">,</tt><tt class="py-op">(</tt><tt class="py-name">str</tt><tt class="py-op">,</tt><tt class="py-name">unicode</tt><tt class="py-op">,</tt><tt class="py-name">int</tt><tt class="py-op">,</tt><tt class="py-name">float</tt><tt class="py-op">,</tt><tt class="py-name">datetime</tt><tt class="py-op">.</tt><tt class="py-name">datetime</tt><tt class="py-op">,</tt><tt class="py-name">datetime</tt><tt class="py-op">.</tt><tt id="link-111" class="py-name" targets="Method Camelot.camelot.view.controls.editors.datetimeeditor.DateTimeEditor.time()=Camelot.camelot.view.controls.editors.datetimeeditor.DateTimeEditor-class.html#time"><a title="Camelot.camelot.view.controls.editors.datetimeeditor.DateTimeEditor.time" class="py-name" href="#" onclick="return doclink('link-111', 'time', 'link-111');">time</a></tt><tt class="py-op">,</tt><tt class="py-name">datetime</tt><tt class="py-op">.</tt><tt id="link-112" class="py-name"><a title="Camelot.camelot.model.batch_job.BatchJob.date
Camelot.camelot.view.controls.editors.datetimeeditor.DateTimeEditor.date" class="py-name" href="#" onclick="return doclink('link-112', 'date', 'link-108');">date</a></tt><tt class="py-op">,</tt> </tt>
<a name="L195"></a><tt class="py-lineno">195</tt> <tt class="py-line"> <tt class="py-name">ExcelFormula</tt><tt class="py-op">.</tt><tt class="py-name">Formula</tt><tt class="py-op">)</tt> <tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L196"></a><tt class="py-lineno">196</tt> <tt class="py-line"> <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-name">unicode</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">)</tt> </tt>
<a name="L197"></a><tt class="py-lineno">197</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">myDataTypeDict</tt><tt class="py-op">.</tt><tt class="py-name">has_key</tt><tt class="py-op">(</tt><tt class="py-name">column</tt><tt class="py-op">)</tt> <tt class="py-op">==</tt> <tt class="py-name">True</tt><tt class="py-op">:</tt> </tt>
<a name="L198"></a><tt class="py-lineno">198</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">myLengthDict</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-name">column</tt><tt class="py-op">)</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L199"></a><tt class="py-lineno">199</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">)</tt> <tt class="py-op">></tt> <tt class="py-name">myLengthDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt><tt class="py-op">:</tt> </tt>
<a name="L200"></a><tt class="py-lineno">200</tt> <tt class="py-line"> <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-name">val</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">:</tt><tt class="py-name">myLengthDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt><tt class="py-op">]</tt> </tt>
<a name="L201"></a><tt class="py-lineno">201</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">myDataTypeDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">str</tt><tt class="py-op">:</tt> </tt>
<a name="L202"></a><tt class="py-lineno">202</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">=</tt> <tt class="py-string">'0'</tt> </tt>
<a name="L203"></a><tt class="py-lineno">203</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">myDataTypeDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">int</tt><tt class="py-op">:</tt> </tt>
<a name="L204"></a><tt class="py-lineno">204</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">=</tt> <tt class="py-string">'0'</tt> </tt>
<a name="L205"></a><tt class="py-lineno">205</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">myDataTypeDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">float</tt><tt class="py-op">:</tt> </tt>
<a name="L206"></a><tt class="py-lineno">206</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">=</tt> <tt class="py-string">'0.'</tt> </tt>
<a name="L207"></a><tt class="py-lineno">207</tt> <tt class="py-line"> <tt class="py-keyword">for</tt> <tt class="py-name">_j</tt> <tt class="py-keyword">in</tt> <tt class="py-name">range</tt><tt class="py-op">(</tt> <tt class="py-number">0</tt> <tt class="py-op">,</tt> <tt class="py-name">myPrecisionDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L208"></a><tt class="py-lineno">208</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">+=</tt> <tt class="py-string">'0'</tt> </tt>
<a name="L209"></a><tt class="py-lineno">209</tt> <tt class="py-line"> <tt class="py-name">valueAddedInSize</tt> <tt class="py-op">=</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">formatStr</tt><tt class="py-op">)</tt> <tt class="py-comment"># To fit the cell width + 1 (of dot(.))</tt> </tt>
<a name="L210"></a><tt class="py-lineno">210</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">myDataTypeDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">datetime</tt><tt class="py-op">.</tt><tt id="link-113" class="py-name"><a title="Camelot.camelot.model.batch_job.BatchJob.date
Camelot.camelot.view.controls.editors.datetimeeditor.DateTimeEditor.date" class="py-name" href="#" onclick="return doclink('link-113', 'date', 'link-108');">date</a></tt><tt class="py-op">:</tt> </tt>
<a name="L211"></a><tt class="py-lineno">211</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">=</tt> <tt class="py-name">myFormatDict</tt><tt class="py-op">[</tt><tt class="py-name">column</tt><tt class="py-op">]</tt> </tt>
<a name="L212"></a><tt class="py-lineno">212</tt> <tt class="py-line"> <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-name">datetime</tt><tt class="py-op">.</tt><tt class="py-name">datetime</tt><tt class="py-op">(</tt> <tt class="py-name">day</tt> <tt class="py-op">=</tt> <tt class="py-name">val</tt><tt class="py-op">.</tt><tt class="py-name">day</tt><tt class="py-op">,</tt> <tt class="py-name">year</tt> <tt class="py-op">=</tt> <tt class="py-name">val</tt><tt class="py-op">.</tt><tt class="py-name">year</tt><tt class="py-op">,</tt> <tt class="py-name">month</tt> <tt class="py-op">=</tt> <tt class="py-name">val</tt><tt class="py-op">.</tt><tt class="py-name">month</tt><tt class="py-op">)</tt> </tt>
<a name="L213"></a><tt class="py-lineno">213</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">myDataTypeDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">datetime</tt><tt class="py-op">.</tt><tt class="py-name">datetime</tt><tt class="py-op">:</tt> </tt>
<a name="L214"></a><tt class="py-lineno">214</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">=</tt> <tt class="py-name">myFormatDict</tt><tt class="py-op">[</tt><tt class="py-name">column</tt><tt class="py-op">]</tt> </tt>
<a name="L215"></a><tt class="py-lineno">215</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">myDataTypeDict</tt><tt class="py-op">[</tt> <tt class="py-name">column</tt> <tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-name">bool</tt><tt class="py-op">:</tt> </tt>
<a name="L216"></a><tt class="py-lineno">216</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">=</tt> <tt class="py-string">'0'</tt> </tt>
<a name="L217"></a><tt class="py-lineno">217</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L218"></a><tt class="py-lineno">218</tt> <tt class="py-line"> <tt class="py-name">formatStr</tt> <tt class="py-op">=</tt> <tt class="py-string">'0'</tt> </tt>
<a name="L219"></a><tt class="py-lineno">219</tt> <tt class="py-line"> <tt id="link-114" class="py-name"><a title="Camelot.camelot.view.export.excel.cellStyle" class="py-name" href="#" onclick="return doclink('link-114', 'cellStyle', 'link-39');">cellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">num_format_str</tt> <tt class="py-op">=</tt> <tt class="py-name">formatStr</tt> </tt>
<a name="L220"></a><tt class="py-lineno">220</tt> <tt class="py-line"> <tt id="link-115" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomCellStyle" class="py-name" href="#" onclick="return doclink('link-115', 'bottomCellStyle', 'link-43');">bottomCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">num_format_str</tt> <tt class="py-op">=</tt> <tt class="py-name">formatStr</tt> </tt>
<a name="L221"></a><tt class="py-lineno">221</tt> <tt class="py-line"> <tt id="link-116" class="py-name"><a title="Camelot.camelot.view.export.excel.rightCellStyle" class="py-name" href="#" onclick="return doclink('link-116', 'rightCellStyle', 'link-42');">rightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">num_format_str</tt> <tt class="py-op">=</tt> <tt class="py-name">formatStr</tt> </tt>
<a name="L222"></a><tt class="py-lineno">222</tt> <tt class="py-line"> <tt id="link-117" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomrightCellStyle" class="py-name" href="#" onclick="return doclink('link-117', 'bottomrightCellStyle', 'link-46');">bottomrightCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">num_format_str</tt> <tt class="py-op">=</tt> <tt class="py-name">formatStr</tt> </tt>
<a name="L223"></a><tt class="py-lineno">223</tt> <tt class="py-line"> <tt id="link-118" class="py-name"><a title="Camelot.camelot.view.export.excel.leftCellStyle" class="py-name" href="#" onclick="return doclink('link-118', 'leftCellStyle', 'link-41');">leftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">num_format_str</tt> <tt class="py-op">=</tt> <tt class="py-name">formatStr</tt> </tt>
<a name="L224"></a><tt class="py-lineno">224</tt> <tt class="py-line"> <tt id="link-119" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomleftCellStyle" class="py-name" href="#" onclick="return doclink('link-119', 'bottomleftCellStyle', 'link-45');">bottomleftCellStyle</a></tt><tt class="py-op">.</tt><tt class="py-name">num_format_str</tt> <tt class="py-op">=</tt> <tt class="py-name">formatStr</tt> </tt>
<a name="L225"></a><tt class="py-lineno">225</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">val</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L226"></a><tt class="py-lineno">226</tt> <tt class="py-line"> <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-string">' '</tt> </tt>
<a name="L227"></a><tt class="py-lineno">227</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt id="link-120" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-120', 'row', 'link-109');">row</a></tt> <tt class="py-op">-</tt> <tt class="py-number">2</tt> <tt class="py-op">==</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">dataList</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L228"></a><tt class="py-lineno">228</tt> <tt class="py-line"> <tt class="py-comment">#we re at the bottom row</tt> </tt>
<a name="L229"></a><tt class="py-lineno">229</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">i</tt><tt class="py-op">==</tt><tt class="py-number">0</tt><tt class="py-op">:</tt> </tt>
<a name="L230"></a><tt class="py-lineno">230</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-121" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-121', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt id="link-122" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-122', 'row', 'link-109');">row</a></tt> <tt class="py-op">,</tt> <tt class="py-name">column</tt><tt class="py-op">,</tt> <tt class="py-name">val</tt> <tt class="py-op">,</tt> <tt id="link-123" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomleftCellStyle" class="py-name" href="#" onclick="return doclink('link-123', 'bottomleftCellStyle', 'link-45');">bottomleftCellStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L231"></a><tt class="py-lineno">231</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">i</tt> <tt class="py-op">==</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">dictCounter</tt><tt class="py-op">)</tt><tt class="py-op">-</tt><tt class="py-number">1</tt><tt class="py-op">:</tt> </tt>
<a name="L232"></a><tt class="py-lineno">232</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-124" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-124', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt id="link-125" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-125', 'row', 'link-109');">row</a></tt> <tt class="py-op">,</tt> <tt class="py-name">column</tt><tt class="py-op">,</tt> <tt class="py-name">val</tt> <tt class="py-op">,</tt> <tt id="link-126" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomrightCellStyle" class="py-name" href="#" onclick="return doclink('link-126', 'bottomrightCellStyle', 'link-46');">bottomrightCellStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L233"></a><tt class="py-lineno">233</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L234"></a><tt class="py-lineno">234</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-127" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-127', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt id="link-128" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-128', 'row', 'link-109');">row</a></tt> <tt class="py-op">,</tt> <tt class="py-name">column</tt><tt class="py-op">,</tt> <tt class="py-name">val</tt> <tt class="py-op">,</tt> <tt id="link-129" class="py-name"><a title="Camelot.camelot.view.export.excel.bottomCellStyle" class="py-name" href="#" onclick="return doclink('link-129', 'bottomCellStyle', 'link-43');">bottomCellStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L235"></a><tt class="py-lineno">235</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L236"></a><tt class="py-lineno">236</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">i</tt><tt class="py-op">==</tt><tt class="py-number">0</tt><tt class="py-op">:</tt> </tt>
<a name="L237"></a><tt class="py-lineno">237</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-130" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-130', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt id="link-131" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-131', 'row', 'link-109');">row</a></tt> <tt class="py-op">,</tt> <tt class="py-name">column</tt><tt class="py-op">,</tt> <tt class="py-name">val</tt> <tt class="py-op">,</tt> <tt id="link-132" class="py-name"><a title="Camelot.camelot.view.export.excel.leftCellStyle" class="py-name" href="#" onclick="return doclink('link-132', 'leftCellStyle', 'link-41');">leftCellStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L238"></a><tt class="py-lineno">238</tt> <tt class="py-line"> <tt class="py-keyword">elif</tt> <tt class="py-name">i</tt> <tt class="py-op">==</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">dictCounter</tt><tt class="py-op">)</tt><tt class="py-op">-</tt><tt class="py-number">1</tt><tt class="py-op">:</tt> </tt>
<a name="L239"></a><tt class="py-lineno">239</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-133" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-133', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt id="link-134" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-134', 'row', 'link-109');">row</a></tt> <tt class="py-op">,</tt> <tt class="py-name">column</tt><tt class="py-op">,</tt> <tt class="py-name">val</tt> <tt class="py-op">,</tt> <tt id="link-135" class="py-name"><a title="Camelot.camelot.view.export.excel.rightCellStyle" class="py-name" href="#" onclick="return doclink('link-135', 'rightCellStyle', 'link-42');">rightCellStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L240"></a><tt class="py-lineno">240</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L241"></a><tt class="py-lineno">241</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt id="link-136" class="py-name"><a title="Camelot.camelot.bin.camelot_manage.FileCacher.write" class="py-name" href="#" onclick="return doclink('link-136', 'write', 'link-96');">write</a></tt><tt class="py-op">(</tt><tt id="link-137" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-137', 'row', 'link-109');">row</a></tt> <tt class="py-op">,</tt> <tt class="py-name">column</tt><tt class="py-op">,</tt> <tt class="py-name">val</tt> <tt class="py-op">,</tt> <tt id="link-138" class="py-name"><a title="Camelot.camelot.view.export.excel.cellStyle" class="py-name" href="#" onclick="return doclink('link-138', 'cellStyle', 'link-39');">cellStyle</a></tt><tt class="py-op">)</tt> </tt>
<a name="L242"></a><tt class="py-lineno">242</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt class="py-name">col</tt><tt class="py-op">(</tt><tt class="py-name">column</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">width</tt> <tt class="py-op"><</tt> <tt class="py-op">(</tt><tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">unicode</tt><tt class="py-op">(</tt> <tt class="py-name">val</tt> <tt class="py-op">)</tt><tt class="py-op">)</tt> <tt class="py-op">)</tt><tt class="py-op">*</tt> <tt class="py-number">300</tt><tt class="py-op">:</tt> </tt>
<a name="L243"></a><tt class="py-lineno">243</tt> <tt class="py-line"> <tt class="py-name">ws</tt><tt class="py-op">.</tt><tt class="py-name">col</tt><tt class="py-op">(</tt><tt class="py-name">column</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">width</tt> <tt class="py-op">=</tt> <tt class="py-op">(</tt><tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">unicode</tt><tt class="py-op">(</tt> <tt class="py-name">val</tt> <tt class="py-op">)</tt><tt class="py-op">)</tt> <tt class="py-op">+</tt> <tt class="py-name">valueAddedInSize</tt> <tt class="py-op">)</tt><tt class="py-op">*</tt> <tt class="py-number">300</tt> </tt>
<a name="L244"></a><tt class="py-lineno">244</tt> <tt class="py-line"> <tt class="py-name">column</tt> <tt class="py-op">=</tt> <tt class="py-name">column</tt> <tt class="py-op">+</tt> <tt class="py-number">1</tt> </tt>
<a name="L245"></a><tt class="py-lineno">245</tt> <tt class="py-line"> <tt id="link-139" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-139', 'row', 'link-109');">row</a></tt> <tt class="py-op">=</tt> <tt id="link-140" class="py-name"><a title="Camelot.camelot.view.field_attributes.row" class="py-name" href="#" onclick="return doclink('link-140', 'row', 'link-109');">row</a></tt> <tt class="py-op">+</tt> <tt class="py-number">1</tt> </tt>
<a name="L246"></a><tt class="py-lineno">246</tt> <tt class="py-line"> <tt class="py-name">w</tt><tt class="py-op">.</tt><tt id="link-141" class="py-name" targets="Variable Camelot.camelot.view.wizard.backup.SelectBackupFile.save=Camelot.camelot.view.wizard.backup.SelectBackupFile-class.html#save,Variable Camelot.camelot.view.wizard.backup.SelectRestoreFile.save=Camelot.camelot.view.wizard.backup.SelectRestoreFile-class.html#save,Variable Camelot.camelot.view.wizard.pages.select.SelectFilePage.save=Camelot.camelot.view.wizard.pages.select.SelectFilePage-class.html#save,Variable camelot.view.wizard.pages.select.SelectFilePage.save=camelot.view.wizard.pages.select.SelectFilePage-class.html#save"><a title="Camelot.camelot.view.wizard.backup.SelectBackupFile.save
Camelot.camelot.view.wizard.backup.SelectRestoreFile.save
Camelot.camelot.view.wizard.pages.select.SelectFilePage.save
camelot.view.wizard.pages.select.SelectFilePage.save" class="py-name" href="#" onclick="return doclink('link-141', 'save', 'link-141');">save</a></tt><tt class="py-op">(</tt><tt class="py-name">filename</tt><tt class="py-op">)</tt> </tt>
</div><a name="L247"></a><tt class="py-lineno">247</tt> <tt class="py-line"> </tt><script type="text/javascript">
<!--
expandto(location.href);
// -->
</script>
</pre>
<br />
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
bgcolor="#a0c0ff" cellspacing="0">
<tr valign="middle">
<!-- Home link -->
<th> <a
href="Camelot.camelot-module.html">Home</a> </th>
<!-- Tree link -->
<th> <a
href="module-tree.html">Trees</a> </th>
<!-- Index link -->
<th> <a
href="identifier-index.html">Indices</a> </th>
<!-- Help link -->
<th> <a
href="help.html">Help</a> </th>
<!-- Project homepage -->
<th class="navbar" align="right" width="100%">
<table border="0" cellpadding="0" cellspacing="0">
<tr><th class="navbar" align="center"
><a class="navbar" target="_top" href="http://www.python-camelot.com">Camelot</a></th>
</tr></table></th>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%%">
<tr>
<td align="left" class="footer">
Generated by Epydoc 3.0.1 on Sat Jun 12 15:42:13 2010
</td>
<td align="right" class="footer">
<a target="mainFrame" href="http://epydoc.sourceforge.net"
>http://epydoc.sourceforge.net</a>
</td>
</tr>
</table>
<script type="text/javascript">
<!--
// Private objects are initially displayed (because if
// javascript is turned off then we want them to be
// visible); but by default, we want to hide them. So hide
// them unless we have a cookie that says to show them.
checkCookie();
// -->
</script>
</body>
</html>
|
