|
矩阵表转线性表,完成之作
记得好久之前.............................在版上问了这样一个问题,原贴在这里,结果不知是不是问错版了,,,,,,,,,,,,,,,,,,,,,,,,,一直没有如意的回答..............
这两天,终于把它整完了,哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈
一个矩阵表,如何转成线性表 首先解释一下这两个概念:
矩阵表:必须通过横纵两个表头才能定义数据的一种表。比如:
+------+-------+------+------+------+------+------+------+------+------+
|系 列|编 号|红胡桃|沙比利|红樱桃|红檀木|红橡木|黑胡桃|斑马木|泰柚木|
+------+-------+------+------+------+------+------+------+------+------+
|只录家|zlj-052| 104 | 108 | 110 | 120 | 122 | 126 | 132 | 136 |
+------+-------+------+------+------+------+------+------+------+------+
|只录家|zlj-052| 104 | 108 | 110 | 120 | 122 | 126 | 132 | 136 |
+------+-------+------+------+------+------+------+------+------+------+
|只录家|zlj-053| 104 | 108 | 110 | 120 | 122 | 126 | 132 | 136 |
+------+-------+------+------+------+------+------+------+------+------+
|.....................
+---------------
|
+----
线性表:只须要一行或者一列即可定义一条数据的一种表。比如:
+------+-------+------+------+
|系 列|编 号|红胡桃|单 价|
+------+-------+------+------+
|只录家|zlj-052|红胡桃| 104 |
+------+-------+------+------+
|只录家|zlj-052|沙比利| 108 |
+------+-------+------+------+
|只录家|zlj-052|红樱桃| 110 |
+------+-------+------+------+
|只录家|zlj-052|红檀木| 120 |
+------+-------+------+------+
|只录家|zlj-052|红橡木| 122 |
+------+-------+------+------+
|只录家|zlj-052|黑胡桃| 126 |
+------+-------+------+------+
|只录家|zlj-052|斑马木| 132 |
+------+-------+------+------+
|只录家|zlj-052|泰柚木| 136 |
+------+-------+------+------+
|只录家|zlj-052|红胡桃| 104 |
+------+-------+------+------+
|只录家|zlj-053|沙比利| 108 |
+------+-------+------+------+
|.....................
+---------------
|
+----
最终效果如这个图一样:
项目文件在附件里: |
|