PowerDesigner对MySql数据库的Excel导入导出

准备工作

首先需要进行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