前面有篇文章介绍了如何把Excel编写好的表结构导入到PowerDesigner(见链接:PowerDesigner从Excel导入表结构),在实际的工作中,这两者的互相转化,是经常的事情。
这里给出对应于那篇文章中约定好的Excel格式的导出脚本:
'******************************************************************************
'* File: pdm2excel.txt
'* Title: pdm export to excel
'* Purpose: To export the tables and columns to Excel
'* Model: Physical Data Model
'* Objects: Table, Column, View
'* Author: ziyan
'* Created: 2012-05-03
'* Version: 1.0
'******************************************************************************
Option Explicit
Dim rowsNum
rowsNum = 0
'-----------------------------------------------------------------------------
' Main function
'-----------------------------------------------------------------------------
' Get the