-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathOPY_CLASS_Datasheet-SetCell.html
More file actions
43 lines (41 loc) · 3.44 KB
/
OPY_CLASS_Datasheet-SetCell.html
File metadata and controls
43 lines (41 loc) · 3.44 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
<h1 class="firstHeading">8.1.7.8 Datasheet::SetCell</h1><table class="noborder"><tr>
<td style="vertical-align:top" width="60"><img src="../images/OPY_CLASS_Datasheet-SetCell/Tip_icon.png?v=21427" width="57" border="0" /></td><td><h3><a name="It_is_recommended_that_you_switch_to_the_originpro_package._PyOrigin_is_primarily_for_users_who_need_to_work_with_Origin_version_prior_to_2021."></a><span class="mw-headline"><span style="color: red">It is recommended that you switch to the <a href="../../Python/Python/RunPython_(Python).html" title="Python:RunPython (Python)">originpro</a> package. PyOrigin is primarily for users who need to work with Origin version prior to 2021.</span></span></h3>
</td></tr></table>
<p><br />
</p>
<div id="toc" class="toc"><div id="toctitle"><h2>Contents</h2></div>
<ul>
<li class="toclevel-1 tocsection-1"><a href="#Description"><span class="tocnumber">1</span> <span class="toctext">Description</span></a></li>
<li class="toclevel-1 tocsection-2"><a href="#Syntax"><span class="tocnumber">2</span> <span class="toctext">Syntax</span></a></li>
<li class="toclevel-1 tocsection-3"><a href="#Parameters"><span class="tocnumber">3</span> <span class="toctext">Parameters</span></a></li>
<li class="toclevel-1 tocsection-4"><a href="#Return"><span class="tocnumber">4</span> <span class="toctext">Return</span></a></li>
<li class="toclevel-1 tocsection-5"><a href="#Examples"><span class="tocnumber">5</span> <span class="toctext">Examples</span></a></li>
<li class="toclevel-1 tocsection-6"><a href="#See_Also"><span class="tocnumber">6</span> <span class="toctext">See Also</span></a></li>
</ul>
</div>
<h2><a name="Description"></a><span class="mw-headline">Description</span></h2>
<p>Set the numeric value of a cell in the DataSheet
</p>
<h2><a name="Syntax"></a><span class="mw-headline">Syntax</span></h2>
<pre class="python" style="font-family:monospace;">SetCell<span style="color: #000;">(</span>Row<span style="color: #000;">,</span> Col<span style="color: #000;">,</span> Val<span style="color: #000;">)</span></pre>
<h2><a name="Parameters"></a><span class="mw-headline">Parameters</span></h2>
<dl><dt>Row</dt>
<dd>row number</dd>
<dt>Col</dt>
<dd>column number</dd>
<dt>Val</dt>
<dd>value</dd></dl>
<h2><a name="Return"></a><span class="mw-headline">Return</span></h2>
<p>True if succeed, otherwise False
</p>
<h2><a name="Examples"></a><span class="mw-headline">Examples</span></h2>
<p><b>EX1</b>
</p>
<pre class="python" style="font-family:monospace;"><span style="color: #d00; font-style: italic;">#Create Book1 with one sheet with 3column and 5row, set some numbers in sheet</span>
<span style="color: #ff7700;font-weight:bold;">import</span> PyOrigin
wks<span style="color: #000;">=</span>PyOrigin.<span style="color: #000;">FindWorksheet</span><span style="color: #000;">(</span><span style="color: #0a0;">'Book1'</span><span style="color: #000;">)</span>
<span style="color: #d00; font-style: italic;">#Set the number in col(3)[2]=0.5</span>
wks.<span style="color: #000;">SetCell</span><span style="color: #000;">(</span><span style="color: #000;">1</span><span style="color: #000;">,</span><span style="color: #000;">2</span><span style="color: #000;">,</span><span style="color: #000;">0.5</span><span style="color: #000;">)</span></pre>
<h2><a name="See_Also"></a><span class="mw-headline">See Also</span></h2>
<p><a href="../../Python/Python/OPY_CLASS_Datasheet-Cell.html" title="Python:OPY CLASS Datasheet-Cell">Datasheet::Cell</a>
</p>