📄 excelfileparser.html
字号:
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void find_stream(
mixed
$dir, mixed
$item_name, [mixed
$item_num = 0])</code>
</td></tr></table>
</td></tr></table><br />
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetByteString"></a>
<h3>method getByteString <span class="smalllinenumber">[line 251]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void getByteString(
mixed
$str, mixed
$ofs)</code>
</td></tr></table>
</td></tr></table><br />
Returns string from stream<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>deprecated:</b> </td><td></td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetDateArray"></a>
<h3>method getDateArray <span class="smalllinenumber">[line 204]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void getDateArray(
mixed
$date)</code>
</td></tr></table>
</td></tr></table><br />
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetUnicodeString"></a>
<h3>method getUnicodeString <span class="smalllinenumber">[line 230]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void getUnicodeString(
mixed
$str, mixed
$ofs)</code>
</td></tr></table>
</td></tr></table><br />
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodget_blocks_chain"></a>
<h3>method get_blocks_chain <span class="smalllinenumber">[line 272]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>mixed get_blocks_chain(
int
$start, [bool
$small_fat = false])</code>
</td></tr></table>
</td></tr></table><br />
Get blocks chain<br /><br /><br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$start</b> </td>
<td></td>
</tr>
<tr>
<td class="type">bool </td>
<td><b>$small_fat</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodInitParser"></a>
<h3>method InitParser <span class="smalllinenumber">[line 1340]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>mixed InitParser(
)</code>
</td></tr></table>
</td></tr></table><br />
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodisDateFormat"></a>
<h3>method isDateFormat <span class="smalllinenumber">[line 212]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>bool isDateFormat(
array
$val)</code>
</td></tr></table>
</td></tr></table><br />
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">array </td>
<td><b>$val</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodParseFromFile"></a>
<h3>method ParseFromFile <span class="smalllinenumber">[line 1329]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void ParseFromFile(
string
$filename)</code>
</td></tr></table>
</td></tr></table><br />
Parse Excel file<br /><br /><p>This function is optimized for memory usage, but the script takes more times to be completely executed and to parse the selected data. Use with large files.</p><br /><br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$filename</b> </td>
<td>file name</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodParseFromString"></a>
<h3>method ParseFromString <span class="smalllinenumber">[line 1315]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>int ParseFromString(
string
$contents)</code>
</td></tr></table>
</td></tr></table><br />
ParseFromString<br /><br /><p>This function is not optimized for memory usage, but the script takes less times to be completely executed and to parse the selected data. Use when parsing speed is critical (PHP memory limit can be exceed for huge files and script will terminate!).</p><p>IN: string contents - File contents string filename - File name of an existing Excel file.</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>0 - success <ol><li>- can't open file</li><li>- file too small to be an Excel file</li><li>- error reading header</li><li>- error reading file</li><li>- This is not an Excel file or file stored in < Excel 5.0</li><li>- file corrupted</li><li>- data not found</li><li>- Unsupported file version</li></ol></td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$contents</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodparse_workbook"></a>
<h3>method parse_workbook <span class="smalllinenumber">[line 844]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void parse_workbook(
mixed
$f_header, mixed
$dp)</code>
</td></tr></table>
</td></tr></table><br />
Parse workbook<br /><br /><br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodparse_worksheet"></a>
<h3>method parse_worksheet <span class="smalllinenumber">[line 430]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void parse_worksheet(
string
$ws, [int
$_format_needed = 1])</code>
</td></tr></table>
</td></tr></table><br />
Parse worksheet<br /><br /><br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$ws</b> </td>
<td></td>
</tr>
<tr>
<td class="type">int </td>
<td><b>$_format_needed</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodpopulateFormat"></a>
<h3>method populateFormat <span class="smalllinenumber">[line 125]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>array populateFormat(
)</code>
</td></tr></table>
</td></tr></table><br />
<br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>list of formats</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodrk_decode"></a>
<h3>method rk_decode <span class="smalllinenumber">[line 377]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>array rk_decode(
int
$rk)</code>
</td></tr></table>
</td></tr></table><br />
An RK value is an encoded integer or floating-point value. RK values have a size of 4 bytes and are used to decrease filesize for floating-point values.<br /><br /><p>Bit Mask Contents <ol><li>00000001H 0 = Value not changed 1 = Value is multiplied by 100</li><li>00000002H 0 = Floating-point value 1 = Signed integer value</li></ol> 31-2 FFFFFFFCH Encoded value If bit 1 is cleared, the encoded value represents the 30 most significant bits of an IEEE 754 floating-point value (64-bit double precision). The 34 least significant bits must be set to zero. If bit 1 is set, the encoded value represents a signed 30-bit integer value. To get the correct integer, the encoded value has to be shifted right arithmetically by 2 bits. If bit is set, the decoded value (both integer and floating-point) must be divided by 100 to get the final result.</p><p>Examples: RK value Type Div 100 Encoded value Decoded value Result 3FF00000H float no 3FF00000H 3FF0000000000000H = 1.0 1.0 3FF00001H float yes 3FF00000H 3FF0000000000000H = 1.0 0.01 004B5646H integer no 004B5644H 0012D591H = 1234321 1234321 004B5647H integer yes 004B5644H 0012D591H = 1234321 12343.21</p><br /><br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$rk</b> </td>
<td>32-bit value</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodxls2tstamp"></a>
<h3>method xls2tstamp <span class="smalllinenumber">[line 195]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>int xls2tstamp(
mixed
$date)</code>
</td></tr></table>
</td></tr></table><br />
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
</div><br />
<div class="credit">
<hr />
Documentation generated on Wed, 9 Feb 2005 17:19:52 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.3.0RC3</a>
</div>
</td></tr></table>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -