函數
>
讀取與寫入檔案
>
範例：讀取及寫入 CSV 檔案
範例：讀取及寫入 CSV 檔案
如需使用此範例的相關資訊，請參閱＜
從說明複製數學範例
＞。
1.
使用
READCSV
讀取 CSV 檔案。
<region id="ID0E5FY4" top="96" left="24" xml:lang="zh_TW" height="21.2" width="152.376666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW" label="None">M1</id> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">READCSV</id> <str xml:space="preserve" xml:lang="zh_TW">csv.txt</str> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
2.
顯示所讀檔案之內容。
<region id="ID0ETHY4" top="192" left="24" xml:lang="zh_TW" height="53.012" width="90.0683333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW">M1</id> <result xml:lang="zh_TW"> <matrix rows="3" cols="3" xml:lang="zh_TW"> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">4</real> <real xml:lang="zh_TW">7</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">5</real> <real xml:lang="zh_TW">8</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">6</real> <real xml:lang="zh_TW">9</real> </matrix> </result> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
3.
擷取矩陣
M1
的三個欄。
<region id="ID0ENJY4" top="312" left="24" xml:lang="zh_TW" height="29.414" width="57.8483333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW" label="Variable">A</id> <apply xml:lang="zh_TW"> <matcol xml:lang="zh_TW" /> <id xml:lang="zh_TW">M1</id> <real xml:lang="zh_TW">2</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0E6JY4" top="360" left="24" xml:lang="zh_TW" height="29.414" width="58.2316666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW" label="Variable">B</id> <apply xml:lang="zh_TW"> <matcol xml:lang="zh_TW" /> <id xml:lang="zh_TW">M1</id> <real xml:lang="zh_TW">1</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0ERKY4" top="408" left="24" xml:lang="zh_TW" height="29.414" width="58.265" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW" label="Variable">C</id> <apply xml:lang="zh_TW"> <matcol xml:lang="zh_TW" /> <id xml:lang="zh_TW">M1</id> <real xml:lang="zh_TW">0</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
4.
使用
augment
函數建立新矩陣
N
，並顯示其內容。
<region id="ID0EBNY4" top="504" left="24" xml:lang="zh_TW" height="21.2" width="127.523333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW" label="Variable">N</id> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">augment</id> <sequence xml:lang="zh_TW"> <id xml:lang="zh_TW">A</id> <id xml:lang="zh_TW">B</id> <id xml:lang="zh_TW">C</id> </sequence> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0ETNY4" top="552" left="24" xml:lang="zh_TW" height="53.012" width="82.215" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW">N</id> <result xml:lang="zh_TW"> <matrix rows="3" cols="3" xml:lang="zh_TW"> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">6</real> <real xml:lang="zh_TW">9</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">5</real> <real xml:lang="zh_TW">8</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">4</real> <real xml:lang="zh_TW">7</real> </matrix> </result> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
5.
使用
WRITECSV
將新的矩陣寫入檔案。
<region id="ID0E2PY4" top="672" left="24" xml:lang="zh_TW" height="21.2" width="186.143333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW" label="Function">T</id> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW" label="Function">WRITECSV</id> <sequence xml:lang="zh_TW"> <str xml:space="preserve" xml:lang="zh_TW">csv_wr.txt</str> <id xml:lang="zh_TW">N</id> </sequence> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
6.
讀取新寫入的 CSV 檔案，並顯示其內容。
<region id="ID0EQRY4" top="768" left="24" xml:lang="zh_TW" height="21.2" width="171.636666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW" label="Variable">M2</id> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">READCSV</id> <str xml:space="preserve" xml:lang="zh_TW">csv_wr.txt</str> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0ECSY4" top="816" left="24" xml:lang="zh_TW" height="53.012" width="90.0683333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id xml:lang="zh_TW">M2</id> <result xml:lang="zh_TW"> <matrix rows="3" cols="3" xml:lang="zh_TW"> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">6</real> <real xml:lang="zh_TW">9</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">5</real> <real xml:lang="zh_TW">8</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">4</real> <real xml:lang="zh_TW">7</real> </matrix> </result> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
複製運算式
