准备工作
首先需要进行MySql数据库的链接,和数据库引擎的选择,建议连上数据库以后先进行一次逆向工程。
逆向程操作方式请参考:《PowerDesigner逆向工程导入MYSQL数据库总结》
之后在Tools-->Execute Commands-->Edit/Run Script执行脚本即可
导出脚本
Option Explicit Dim rowsNum rowsNum = 0 Dim Model Set Model = ActiveModel If (Model Is Nothing) Or (Not Model.IsKindOf(PdPDM.cls_Model)) Then MsgBox "The current model is not an PDM model." Else ' Get the tables collection '创建EXCEL APP dim beginrow DIM EXCEL, SHEET set EXCEL = CREATEOBJECT("Excel.Application") EXCEL.workbooks.add(-4167)'添加工作表 EXCEL.workbooks(1).sheets(1).name ="Table" set sheet = EXCEL.workbooks(1).sheets("Table") ShowProperties Model, SHEET EXCEL.visible = true '设置列宽和自动换行 sheet.Columns(1).ColumnWidth = 2.5 sheet.Columns(2).ColumnWidth = 15 sheet.Columns(3).ColumnWidth = 15 sheet.Columns(4).ColumnWidth = 5 sheet.Columns(5).ColumnWidth = 5 sheet.Columns(6).ColumnWidth = 5 sheet.Columns(7).ColumnWidth = 40 sheet.Columns(7).WrapText =true End If '----------------------------------------------------------------------------- Sub ShowProperties(mdl, sheet) ' Show tables of the current model/package rowsNum=1 beginrow = rowsNum+1 ' For each table output "begin" Dim tab For Each tab In mdl.tables ShowTable tab,sheet Next ' if mdl.tables.count > 0 then ' sheet.Range("A" & beginrow + 1 & ":A" & rowsNum).Rows.Group ' end if output "end" End Sub '----------------------------------------------------------------------------- Sub ShowTable(tab, sheet) If IsObject(tab) Then Dim rangFlag rowsNum = rowsNum + 1 ' Show properties Out