Excel工作簿在文档自定义变量表中存取的实现

Implementation of Excel workbook to Access Document Custom Variables

三维数组和一维数组的相互转换在程序设计中有时是非常必要的.本文通过巧妙的算法设计,使用ExcelVBA将Excel工作簿中多张数据表存入了工作簿自定义变量中,并实现了其逆过程,从而给出了三维数组到一维数组相互转换的具体方法.

The array covariance of programming between three-dimensional and one-dimensional is very necessarysometimes. This article presents a clever algorithm design,which can save multiple data tables of excel workbook to workbookcustom variables by use of excel VBA and achieve its inverse process,and gives a specific methods of mutual array covariancebetween three-dimensional and one-dimensional array.