函數
>
向量與矩陣
>
建立與細分陣列
>
範例：插入與萃取子陣列
範例：插入與萃取子陣列
插入子陣列
在較大陣列的指定位置插入陣列，取代原始元素。
1.
定義較大的陣列：
<region id="ID0ET12LB" top="144" left="24" xml:lang="zh_TW" height="21.2" width="88.4433333333333" 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">A</id> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">identity</id> <real xml:lang="zh_TW">6</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
2.
定義較小的陣列：
<region id="ID0EI32LB" top="240" left="24" xml:lang="zh_TW" height="53.012" width="76.4566666666667" 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">B</id> <matrix rows="3" cols="3" xml:lang="zh_TW"> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> </matrix> </define> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
3.
輸入較小陣列左上方元素放置所在的列及欄編號：
<region id="ID0E442LB" top="336" left="24" xml:lang="zh_TW" height="21.2" width="32.92" 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">r</id> <real xml:lang="zh_TW">2</real> </define> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EP52LB" top="360" left="24" xml:lang="zh_TW" height="21.2" width="32.8533333333333" 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">c</id> <real xml:lang="zh_TW">1</real> </define> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
4.
將矩陣
B
插入位置
(r, c)
(位在矩陣
A
內)：
<region id="ID0ETA3LB" top="432" left="24" xml:lang="zh_TW" height="21.2" width="105.296666666667" 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">i</id> <range xml:lang="zh_TW"> <real xml:lang="zh_TW">0</real> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">rows</id> <id xml:lang="zh_TW">B</id> </apply> <real xml:lang="zh_TW">1</real> </apply> </range> </define> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EFB3LB" top="456" left="24" xml:lang="zh_TW" height="21.2" width="101.02" 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">j</id> <range xml:lang="zh_TW"> <real xml:lang="zh_TW">0</real> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">cols</id> <id xml:lang="zh_TW">B</id> </apply> <real xml:lang="zh_TW">1</real> </apply> </range> </define> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EXB3LB" top="480" left="24" xml:lang="zh_TW" height="31.1" width="104.333333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id xml:lang="zh_TW" label="None">A</id> <sequence xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <plus xml:lang="zh_TW" /> <id xml:lang="zh_TW" label="None">r</id> <id xml:lang="zh_TW" label="None">i</id> </apply> <apply xml:lang="zh_TW"> <plus xml:lang="zh_TW" /> <id xml:lang="zh_TW" label="None">c</id> <id xml:lang="zh_TW" label="None">j</id> </apply> </sequence> </apply> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id xml:lang="zh_TW">B</id> <sequence xml:lang="zh_TW"> <id xml:lang="zh_TW">i</id> <id xml:lang="zh_TW">j</id> </sequence> </apply> </define> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EJC3LB" top="576" left="24" xml:lang="zh_TW" height="98.288" width="123.065" 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">A</id> <result xml:lang="zh_TW"> <matrix rows="6" cols="6" xml:lang="zh_TW"> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> </matrix> </result> </eval> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
萃取子陣列
1.
定義輸入矩陣：
<region id="ID0ENE3LB" top="792" left="24" xml:lang="zh_TW" height="86.969" width="131.2" 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">M</id> <matrix rows="5" cols="5" xml:lang="zh_TW"> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">-5</real> <real xml:lang="zh_TW">-6</real> <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">-8</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">1</real> <real xml:lang="zh_TW">-2</real> <real xml:lang="zh_TW">-3</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">5</real> <real xml:lang="zh_TW">4</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">4</real> <real xml:lang="zh_TW">6</real> <real xml:lang="zh_TW">4</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">8</real> </matrix> </define> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
2.
萃取所有列 1 與 2 以及欄 0、1 及 2 共有的元素：
<region id="ID0ECG3LB" top="936" left="24" xml:lang="zh_TW" height="41.693" width="225.408333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">submatrix</id> <sequence xml:lang="zh_TW"> <id xml:lang="zh_TW">M</id> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">2</real> </sequence> </apply> <result xml:lang="zh_TW"> <matrix rows="2" cols="3" xml:lang="zh_TW"> <real xml:lang="zh_TW">-5</real> <real xml:lang="zh_TW">-6</real> <real xml:lang="zh_TW">-8</real> <real xml:lang="zh_TW">-9</real> <real xml:lang="zh_TW">-2</real> <real xml:lang="zh_TW">-3</real> </matrix> </result> </eval> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
3.
若要反轉欄的順序，請交換最後兩個純量引數：
<region id="ID0EXH3LB" top="1032" left="24" xml:lang="zh_TW" height="41.693" width="225.408333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">submatrix</id> <sequence xml:lang="zh_TW"> <id xml:lang="zh_TW">M</id> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">0</real> </sequence> </apply> <result xml:lang="zh_TW"> <matrix rows="2" cols="3" xml:lang="zh_TW"> <real xml:lang="zh_TW">-2</real> <real xml:lang="zh_TW">-3</real> <real xml:lang="zh_TW">-8</real> <real xml:lang="zh_TW">-9</real> <real xml:lang="zh_TW">-5</real> <real xml:lang="zh_TW">-6</real> </matrix> </result> </eval> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
4.
若要反轉列的順序，請交換前兩個純量引數：
<region id="ID0EMJ3LB" top="1128" left="24" xml:lang="zh_TW" height="41.693" width="225.408333333333" xmlns="http://schemas.mathsoft.com/worksheet50"> <math xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <id xml:lang="zh_TW">submatrix</id> <sequence xml:lang="zh_TW"> <id xml:lang="zh_TW">M</id> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">2</real> <real xml:lang="zh_TW">0</real> </sequence> </apply> <result xml:lang="zh_TW"> <matrix rows="2" cols="3" xml:lang="zh_TW"> <real xml:lang="zh_TW">-3</real> <real xml:lang="zh_TW">-2</real> <real xml:lang="zh_TW">-9</real> <real xml:lang="zh_TW">-8</real> <real xml:lang="zh_TW">-6</real> <real xml:lang="zh_TW">-5</real> </matrix> </result> </eval> <resultFormat xml:lang="zh_TW"> <decimal precision="round-trip-decimal-places" show-trailing-zeros="false" radix="dec" imaginary-value="i" xml:lang="zh_TW" /> <matrix size="12,12" offset="0,0" xml:lang="zh_TW" /> </resultFormat> </math> </region>
複製運算式
