• 宏代码批量处理表格数据


    Sub 在所有表格右侧添加一列()
    For Each aTable In ActiveDocument.Tables
    If aTable.Columns.Count = 5 Then
    aTable.Columns(aTable.Columns.Count).Select
    Selection.InsertColumnsRight
    End If
    Next aTable
    End Sub

    Sub 所有表格左对齐()
    For i = 1 To ActiveDocument.Tables.Count

    ActiveDocument.Tables(i).AutoFitBehavior (wdAutoFitContent) '根据内容自动调整表格

    ActiveDocument.Tables(i).AutoFitBehavior (wdAutoFitWindow) '根据窗口自动调整表格

    ActiveDocument.Tables(i).Range.ParagraphFormat.Alignment = wdAlignParagraphLeft

    ActiveDocument.Tables(i).Range.ParagraphFormat.Alignment = wdCellAlignVerticalLeft

    Next i
    End Sub

    Sub 设置表格宽度()
    For Each aTable In ActiveDocument.Tables
    If aTable.Columns.Count = 6 Then
    aTable.Columns(1).Width = 30
    aTable.Columns(6).Width = 50
    End If
    Next aTable
    End Sub

    Sub 第一行第六列属性列赋值()
    For Each aTable In ActiveDocument.Tables
    If aTable.Columns.Count = 6 Then
    aTable.Cell(1, 6).Range.InsertAfter "类型"
    End If
    Next aTable
    End Sub


    Sub 每行第六列赋值String()
    For Each aTable In ActiveDocument.Tables
    If aTable.Columns.Count = 6 Then

    For i = 2 To aTable.Rows.Count

    aTable.Cell(i, 6).Range.InsertAfter "String"

    Next i

    End If
    Next aTable
    End Sub

  • 相关阅读:
    GoogleCpp风格指南 8)格式 _part1
    软考缉捕令
    nfc开发
    MFC 小知识总结二
    B
    UVA 10090 Marbles(扩展欧几里得)
    Android指令处理流程源代码追踪
    c语言基础学习04_条件判断语句
    教你如何解决Sublime Text 3使用中出现的中文乱码问题
    SecureCRT连接虚拟机中的Linux系统(Ubuntu)_Linux教程
  • 原文地址:https://www.cnblogs.com/pjh7/p/14334783.html
Copyright © 2020-2023  润新知