<!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/xhtml;charset=UTF-8"/>
<title>FreeXL: FreeXL_CellValue_str Struct Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body onload='searchBox.OnSelectItem(0);'>
<!-- Generated by Doxygen 1.7.4 -->
<script type="text/javascript"><!--
var searchBox = new SearchBox("searchBox", "search",false,'Search');
--></script>
<div id="top">
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td style="padding-left: 0.5em;">
<div id="projectname">FreeXL <span id="projectnumber">1.0.0a</span></div>
</td>
</tr>
</tbody>
</table>
</div>
<div id="navrow1" class="tabs">
<ul class="tablist">
<li><a href="index.html"><span>Main Page</span></a></li>
<li><a href="pages.html"><span>Related Pages</span></a></li>
<li class="current"><a href="annotated.html"><span>Data Structures</span></a></li>
<li><a href="files.html"><span>Files</span></a></li>
<li><a href="examples.html"><span>Examples</span></a></li>
<li id="searchli">
<div id="MSearchBox" class="MSearchBoxInactive">
<span class="left">
<img id="MSearchSelect" src="search/mag_sel.png"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
alt=""/>
<input type="text" id="MSearchField" value="Search" accesskey="S"
onfocus="searchBox.OnSearchFieldFocus(true)"
onblur="searchBox.OnSearchFieldFocus(false)"
onkeyup="searchBox.OnSearchFieldChange(event)"/>
</span><span class="right">
<a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
</span>
</div>
</li>
</ul>
</div>
<div id="navrow2" class="tabs2">
<ul class="tablist">
<li><a href="annotated.html"><span>Data Structures</span></a></li>
<li><a href="classes.html"><span>Data Structure Index</span></a></li>
<li><a href="functions.html"><span>Data Fields</span></a></li>
</ul>
</div>
</div>
<div class="header">
<div class="summary">
<a href="#pub-attribs">Data Fields</a> </div>
<div class="headertitle">
<div class="title">FreeXL_CellValue_str Struct Reference</div> </div>
</div>
<div class="contents">
<!-- doxytag: class="FreeXL_CellValue_str" -->
<p>Container for a cell value.
<a href="structFreeXL__CellValue__str.html#details">More...</a></p>
<p><code>#include <<a class="el" href="freexl_8h_source.html">freexl.h</a>></code></p>
<table class="memberdecls">
<tr><td colspan="2"><h2><a name="pub-attribs"></a>
Data Fields</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">unsigned char </td><td class="memItemRight" valign="bottom"><a class="el" href="structFreeXL__CellValue__str.html#af2b1f157e4dc4508b1c4e303429c01d5">type</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">The type of data stored in this cell. <a href="#af2b1f157e4dc4508b1c4e303429c01d5"></a><br/></td></tr>
<tr><td class="memItemLeft" >union {</td></tr>
<tr><td class="memItemLeft" >   int   <a class="el" href="structFreeXL__CellValue__str.html#a7dcd352478ee217f4a24e7fcff6170bb">int_value</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">if type is FREEXL_CELL_INT, then the corresponding value will be returned as int_value <br/></td></tr>
<tr><td class="memItemLeft" >   double   <a class="el" href="structFreeXL__CellValue__str.html#ad125ce4ac1a2dde3bdcfa2750dd0815d">double_value</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">if type is FREEXL_CELL_DOUBLE, then the corresponding value will be returned as double_value <br/></td></tr>
<tr><td class="memItemLeft" >   const char *   <a class="el" href="structFreeXL__CellValue__str.html#a2f0f6b8e3bb3503487107037a769e56e">text_value</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">if type is FREEXL_CELL_TEXT, FREEXL_CELL_SST_TEXT, FREEXL_CELL_DATE, FREEXL_CELL_DATETIME or FREEXL_CELL_TIME the corresponding value will be returned as text_value <br/></td></tr>
<tr><td class="memItemLeft" valign="top">} </td><td class="memItemRight" valign="bottom"><a class="el" href="structFreeXL__CellValue__str.html#acaf7ae03285c299b05f0e345eff3c6a1">value</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">The value of the data stored in the cell. <a href="#acaf7ae03285c299b05f0e345eff3c6a1"></a><br/></td></tr>
</table>
<hr/><a name="details" id="details"></a><h2>Detailed Description</h2>
<div class="textblock"><p>Container for a cell value. </p>
<p><a class="el" href="freexl_8h.html#aef8dc850a668e82b9aa2efde78cc427a" title="Retrieve individual cell values from the currently active worksheet.">freexl_get_cell_value()</a> takes a pointer to this structure, and fills in the appropriate values.</p>
<div class="fragment"><pre class="fragment"> <a class="code" href="structFreeXL__CellValue__str.html" title="Container for a cell value.">FreeXL_CellValue</a> val;
<a class="code" href="freexl_8h.html#aef8dc850a668e82b9aa2efde78cc427a" title="Retrieve individual cell values from the currently active worksheet.">freexl_get_cell_value</a>(..., &val);
<span class="keywordflow">switch</span> (val.<a class="code" href="structFreeXL__CellValue__str.html#af2b1f157e4dc4508b1c4e303429c01d5" title="The type of data stored in this cell.">type</a>)
{
<span class="keywordflow">case</span> <a class="code" href="freexl_8h.html#a1a2260897b305108f008c924a7e56778" title="Cell contains an integer value.">FREEXL_CELL_INT</a>:
printf(<span class="stringliteral">"Int=%d\n"</span>, val.<a class="code" href="structFreeXL__CellValue__str.html#acaf7ae03285c299b05f0e345eff3c6a1" title="The value of the data stored in the cell.">value</a>.<a class="code" href="structFreeXL__CellValue__str.html#a7dcd352478ee217f4a24e7fcff6170bb" title="if type is FREEXL_CELL_INT, then the corresponding value will be returned as int_value">int_value</a>;
<span class="keywordflow">break</span>;
<span class="keywordflow">case</span> <a class="code" href="freexl_8h.html#a7f2f46b7b391b8b1ff19cef17dd5f4ef" title="Cell contains a floating point number.">FREEXL_CELL_DOUBLE</a>:
printf(<span class="stringliteral">"Double=%1.2f\n"</span>, val.<a class="code" href="structFreeXL__CellValue__str.html#acaf7ae03285c299b05f0e345eff3c6a1" title="The value of the data stored in the cell.">value</a>.<a class="code" href="structFreeXL__CellValue__str.html#ad125ce4ac1a2dde3bdcfa2750dd0815d" title="if type is FREEXL_CELL_DOUBLE, then the corresponding value will be returned as double_value">double_value</a>;
<span class="keywordflow">break</span>;
<span class="keywordflow">case</span> <a class="code" href="freexl_8h.html#ab928649db9c51b12efbbf71b248ef1fe" title="Cell contains a text value.">FREEXL_CELL_TEXT</a>:
<span class="keywordflow">case</span> <a class="code" href="freexl_8h.html#a357ed1fac1a7e38ac7bf712f178d1ec3" title="Cell contains a reference to a Single String Table entry (BIFF8)">FREEXL_CELL_SST_TEXT</a>:
printf(<span class="stringliteral">"Text='%s'\n"</span>, val.<a class="code" href="structFreeXL__CellValue__str.html#acaf7ae03285c299b05f0e345eff3c6a1" title="The value of the data stored in the cell.">value</a>.<a class="code" href="structFreeXL__CellValue__str.html#a2f0f6b8e3bb3503487107037a769e56e" title="if type is FREEXL_CELL_TEXT, FREEXL_CELL_SST_TEXT, FREEXL_CELL_DATE, FREEXL_CELL_DATETIME or FREEXL_C...">text_value</a>;
<span class="keywordflow">break</span>;
<span class="keywordflow">case</span> <a class="code" href="freexl_8h.html#aacf5c5f5606df0b5ee875ec9702819c9" title="Cell contains a number intended to represent a date.">FREEXL_CELL_DATE</a>:
<span class="keywordflow">case</span> <a class="code" href="freexl_8h.html#ae51f78f0944809077b4e706044d2f7a7" title="Cell contains a number intended to represent a date and time.">FREEXL_CELL_DATETIME</a>:
<span class="keywordflow">case</span> <a class="code" href="freexl_8h.html#abb41208799b5a3ffb42713f58b387577" title="Cell contains a number intended to represent a time.">FREEXL_CELL_TIME</a>:
printf(<span class="stringliteral">"DateOrTime='%s'\n"</span>, val.<a class="code" href="structFreeXL__CellValue__str.html#acaf7ae03285c299b05f0e345eff3c6a1" title="The value of the data stored in the cell.">value</a>.<a class="code" href="structFreeXL__CellValue__str.html#a2f0f6b8e3bb3503487107037a769e56e" title="if type is FREEXL_CELL_TEXT, FREEXL_CELL_SST_TEXT, FREEXL_CELL_DATE, FREEXL_CELL_DATETIME or FREEXL_C...">text_value</a>;
<span class="keywordflow">break</span>;
<span class="keywordflow">case</span> <a class="code" href="freexl_8h.html#ad085ed9c20bfc0ed4006c45588e13fc0" title="Cell has no value (empty cell)">FREEXL_CELL_NULL</a>:
printf(<span class="stringliteral">"NULL\n"</span>);
<span class="keywordflow">break</span>;
<span class="keywordflow">default</span>:
printf(<span class="stringliteral">"Invalid data-type\n"</span>);
<span class="keywordflow">break</span>;
}
</pre></div> <dl><dt><b>Examples: </b></dt><dd>
<p><a class="el" href="xl2sql_8c-example.html#_a10">xl2sql.c</a>.</p>
</dd>
</dl></div><hr/><h2>Field Documentation</h2>
<a class="anchor" id="af2b1f157e4dc4508b1c4e303429c01d5"></a><!-- doxytag: member="FreeXL_CellValue_str::type" ref="af2b1f157e4dc4508b1c4e303429c01d5" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">unsigned char <a class="el" href="structFreeXL__CellValue__str.html#af2b1f157e4dc4508b1c4e303429c01d5">FreeXL_CellValue_str::type</a></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>The type of data stored in this cell. </p>
<p>Can be one of the following:</p>
<ul>
<li>FREEXL_CELL_NULL the cell contains a NULL value.</li>
<li>FREEXL_CELL_INT the cell contains an INTEGER value.</li>
<li>FREEXL_CELL_DOUBLE the cell contains a DOUBLE value.</li>
<li>FREEXL_CELL_TEXT or FREEXL_CELL_SST_TEXT the cell contains a text string (always UTF-8 encoded)</li>
<li>FREEXL_CELL_DATE the cell contains a date, encoded as a 'YYYY-MM-DD' string value</li>
<li>FREEXL_CELL_DATETIME the cell contains a date and time, encoded as a 'YYYY-MM-DD HH:MM:SS' string value</li>
<li>FREEXL_CELL_TIME the cell contains a time, encoded as a 'HH:MM:SS' string value </li>
</ul>
<dl><dt><b>Examples: </b></dt><dd><a class="el" href="xl2sql_8c-example.html#a12">xl2sql.c</a>.</dd>
</dl>
</div>
</div>
<a class="anchor" id="acaf7ae03285c299b05f0e345eff3c6a1"></a><!-- doxytag: member="FreeXL_CellValue_str::value" ref="acaf7ae03285c299b05f0e345eff3c6a1" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">union { ... } <a class="el" href="structFreeXL__CellValue__str.html#acaf7ae03285c299b05f0e345eff3c6a1">FreeXL_CellValue_str::value</a></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>The value of the data stored in the cell. </p>
<p>Which part of the union is valid is determined by the type value. </p>
<dl><dt><b>Examples: </b></dt><dd><a class="el" href="xl2sql_8c-example.html#a14">xl2sql.c</a>.</dd>
</dl>
</div>
</div>
<hr/>The documentation for this struct was generated from the following file:<ul>
<li>headers/<a class="el" href="freexl_8h_source.html">freexl.h</a></li>
</ul>
</div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Data Structures</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Defines</a></div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<hr class="footer"/><address class="footer"><small>Generated on Fri Jan 13 2012 for FreeXL by 
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.4 </small></address>
</body>
</html>
