VB实现上下标

最新推荐文章于 2022-10-28 21:03:51 发布

tyl06

最新推荐文章于 2022-10-28 21:03:51 发布

阅读量1k

点赞数

本文链接：https://blog.csdn.net/tyl06/article/details/83705106

版权

该博客介绍如何使用VB在Excel中实现上下标的处理。通过创建一个VB模块，利用Microsoft Office Interop Excel库，遍历并修改Excel工作表中特定格式的单元格内容，将包含上下标信息的字符串转换为实际的上标和下标效果。

摘要由CSDN通过智能技术生成

Module Module1

Private suptable As Hashtable
Private subtable As Hashtable

    Sub Main(ByVal Args() As String)
        implementSubAndSup(Args(0))
    End Sub

    Private Sub implementSubAndSup(ByVal excelName As String)
        If (excelName.Length > 0) Then
            Dim excelApp As Microsoft.Office.Interop.Excel.Application
            Dim excelBook As Microsoft.Office.Interop.Excel.Workbook
            Dim excelsheet As Microsoft.Office.Interop.Excel.Worksheet '定义工作表类

            Try
                excelBook = New Microsoft.Office.Interop.Excel.Workbook()
            Catch ex As Exception

End Try

            excelApp = CreateObject("Excel.Application")
            excelApp.DisplayAlerts = False
            Try
                excelBook = excelApp.Workbooks.Open(excelName)
            Catch ex As Exception
                ' System.Console.WriteLine("excelBook......." + ex.Message)
            End Try
            excelApp.Visible = False

            Dim m As Integer
            Dim sheetCount As Integer
            Try
                sheetCount = excelBook.Worksheets.Count
            Catch ex As Exception

End Try

            If (sheetCount > 0) Then
                For m = 1 To sheetCount
                    Try
                        excelsheet = New Microsoft.Office.Interop.Excel.Worksheet()
                    Catch ex As Exception

End Try

                    Try
                        excelsheet = excelBook.Worksheets(m)
                        excelsheet.Select()
                    Catch ex As Exception
                        '    System.Console.WriteLi