如何訪問raow值,然後在連續的行中重複它我從excel數據透視表導入數據。我需要讀取一個行值,然後對13個連續的行重複它。
讀取值A12並在接下來的13行中重複該操作,然後讀取A22並在接下來的13行中重複操作。是否有捷徑可尋?
| 列A | 列B | 列C | 列D | 列E | 列F | 列G |
| VarA | 值 | 數學 | 數學 | 能源部1 | AA12 | 一種 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一種 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一種 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一種 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一種 |
| | | | | | | 乙 |
| | | | | | AA總計 | |
| | | | | DOE1總計 | | |
| | | | | DOE1-W55 | AA22 | 一種 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一種 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一種 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一種 |
| | | | | | | 乙 |
| | | | | | | C |
| | | | | | | 一種 |
| | | | | | | 乙 |
| | | | | | 總計AA22 | |
| | | | | DOE1總計 | | |