forked from jmcnamara/XlsxWriter
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathexample_hide_sheet.html
More file actions
148 lines (132 loc) · 7.63 KB
/
example_hide_sheet.html
File metadata and controls
148 lines (132 loc) · 7.63 KB
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
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Example: Hiding Worksheets — XlsxWriter Documentation</title>
<link rel="stylesheet" href="_static/default.css" type="text/css" />
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: '',
VERSION: '0.3.1',
COLLAPSE_INDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true
};
</script>
<script type="text/javascript" src="_static/jquery.js"></script>
<script type="text/javascript" src="_static/underscore.js"></script>
<script type="text/javascript" src="_static/doctools.js"></script>
<link rel="top" title="XlsxWriter Documentation" href="index.html" />
<link rel="up" title="Examples" href="examples.html" />
<link rel="next" title="Example: Hiding Rows and Columns" href="example_hide_row_col.html" />
<link rel="prev" title="Example: Enabling Cell protection in Worksheets" href="example_protection.html" />
</head>
<body>
<div class="related">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
accesskey="I">index</a></li>
<li class="right" >
<a href="example_hide_row_col.html" title="Example: Hiding Rows and Columns"
accesskey="N">next</a> |</li>
<li class="right" >
<a href="example_protection.html" title="Example: Enabling Cell protection in Worksheets"
accesskey="P">previous</a> |</li>
<li><a href="index.html">XlsxWriter Documentation</a> »</li>
<li><a href="examples.html" accesskey="U">Examples</a> »</li>
</ul>
</div>
<div class="document">
<div class="documentwrapper">
<div class="bodywrapper">
<div class="body">
<div class="section" id="example-hiding-worksheets">
<span id="ex-hide-sheet"></span><h1>Example: Hiding Worksheets</h1>
<p>This program is an example of how to hide a worksheet using the
<a class="reference internal" href="worksheet.html#hide" title="hide"><tt class="xref py py-func docutils literal"><span class="pre">hide()</span></tt></a> method.</p>
<img alt="_images/hide_sheet.png" src="_images/hide_sheet.png" />
<div class="highlight-python"><div class="highlight"><pre><span class="c">#######################################################################</span>
<span class="c">#</span>
<span class="c"># Example of how to hide a worksheet with XlsxWriter.</span>
<span class="c">#</span>
<span class="c"># Copyright 2013, John McNamara, jmcnamara@cpan.org</span>
<span class="c">#</span>
<span class="kn">from</span> <span class="nn">xlsxwriter.workbook</span> <span class="kn">import</span> <span class="n">Workbook</span>
<span class="n">workbook</span> <span class="o">=</span> <span class="n">Workbook</span><span class="p">(</span><span class="s">'hide_sheet.xlsx'</span><span class="p">)</span>
<span class="n">worksheet1</span> <span class="o">=</span> <span class="n">workbook</span><span class="o">.</span><span class="n">add_worksheet</span><span class="p">()</span>
<span class="n">worksheet2</span> <span class="o">=</span> <span class="n">workbook</span><span class="o">.</span><span class="n">add_worksheet</span><span class="p">()</span>
<span class="n">worksheet3</span> <span class="o">=</span> <span class="n">workbook</span><span class="o">.</span><span class="n">add_worksheet</span><span class="p">()</span>
<span class="n">worksheet1</span><span class="o">.</span><span class="n">set_column</span><span class="p">(</span><span class="s">'A:A'</span><span class="p">,</span> <span class="mi">30</span><span class="p">)</span>
<span class="n">worksheet2</span><span class="o">.</span><span class="n">set_column</span><span class="p">(</span><span class="s">'A:A'</span><span class="p">,</span> <span class="mi">30</span><span class="p">)</span>
<span class="n">worksheet3</span><span class="o">.</span><span class="n">set_column</span><span class="p">(</span><span class="s">'A:A'</span><span class="p">,</span> <span class="mi">30</span><span class="p">)</span>
<span class="c"># Hide Sheet2. It won't be visible until it is unhidden in Excel.</span>
<span class="n">worksheet2</span><span class="o">.</span><span class="n">hide</span><span class="p">()</span>
<span class="n">worksheet1</span><span class="o">.</span><span class="n">write</span><span class="p">(</span><span class="s">'A1'</span><span class="p">,</span> <span class="s">'Sheet2 is hidden'</span><span class="p">)</span>
<span class="n">worksheet2</span><span class="o">.</span><span class="n">write</span><span class="p">(</span><span class="s">'A1'</span><span class="p">,</span> <span class="s">"Now it's my turn to find you!"</span><span class="p">)</span>
<span class="n">worksheet3</span><span class="o">.</span><span class="n">write</span><span class="p">(</span><span class="s">'A1'</span><span class="p">,</span> <span class="s">'Sheet2 is hidden'</span><span class="p">)</span>
<span class="n">workbook</span><span class="o">.</span><span class="n">close</span><span class="p">()</span>
</pre></div>
</div>
</div>
</div>
</div>
</div>
<div class="sphinxsidebar">
<div class="sphinxsidebarwrapper">
<p class="logo"><a href="index.html">
<img class="logo" src="_static/logo.png" alt="Logo"/>
</a></p>
<h4>Previous topic</h4>
<p class="topless"><a href="example_protection.html"
title="previous chapter">Example: Enabling Cell protection in Worksheets</a></p>
<h4>Next topic</h4>
<p class="topless"><a href="example_hide_row_col.html"
title="next chapter">Example: Hiding Rows and Columns</a></p>
<h3>This Page</h3>
<ul class="this-page-menu">
<li><a href="_sources/example_hide_sheet.txt"
rel="nofollow">Show Source</a></li>
</ul>
<div id="searchbox" style="display: none">
<h3>Quick search</h3>
<form class="search" action="search.html" method="get">
<input type="text" name="q" />
<input type="submit" value="Go" />
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
<p class="searchtip" style="font-size: 90%">
Enter search terms or a module, class or function name.
</p>
</div>
<script type="text/javascript">$('#searchbox').show(0);</script>
</div>
</div>
<div class="clearer"></div>
</div>
<div class="related">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
>index</a></li>
<li class="right" >
<a href="example_hide_row_col.html" title="Example: Hiding Rows and Columns"
>next</a> |</li>
<li class="right" >
<a href="example_protection.html" title="Example: Enabling Cell protection in Worksheets"
>previous</a> |</li>
<li><a href="index.html">XlsxWriter Documentation</a> »</li>
<li><a href="examples.html" >Examples</a> »</li>
</ul>
</div>
<div class="footer">
© Copyright 2013, John McNamara.
Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 1.1.3.
</div>
</body>
</html>