VB.Net创建的office类

这个VB.Net类库提供了创建、打开、保存、关闭Excel和Word文档的功能。包括创建工作簿、打开现有工作簿、保存工作簿、获取工作簿的行数和列数、释放应用程序资源等操作。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Public Class Coffice
    Public xls As Excel.Application
    Public xlsworkbook As Excel.Workbook
    Public xlsworksheet As Excel.Worksheet

    Public doc As Word.Application
    Public document As Word.Document
    '************************************************************************************************************
    '创建工作簿,获得第一个工作表,为需要的操作做准备

    Public Function CreateXls(ByVal bool As Boolean) As Boolean
        Try
            xls = New Excel.Application
            xls.Visible = bool
            xls = CreateObject("excel.application")
            xlsworkbook = xls.Application.Workbooks.Add()
            xlsworksheet = xlsworkbook.Sheets(1)
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '打开现有的工作簿,获得第一个工作表,为需要的操作做准备
    Public Function OpenXls(ByVal path As String, ByVal name As String, ByVal bool As Boolean) As Boolean
        Try
            xls = New Excel.Application
            xls.Visible = bool
            xls = CreateObject("excel.application")
            xlsworkbook = xls.Application.Workbooks.Open(path & name)
            xlsworksheet = xlsworkbook.Sheets(1)
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '保存原有的工作簿
    Public Function SaveWorkbook() As Boolean
        Try
            'xlsworksheet.Save()
            xlsworkbook.Save()
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '保存新创建的工作簿
    Public Function SaveWorkbook(ByVal path As String, ByVal name As String) As Boolean
        Try
            xlsworkbook.SaveAs(path & name)
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '关闭工作簿
    Public Function CloseWorkbook() As Boolean
        Try
            xlsworkbook.Close()
            xls.Quit()
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '获得工作簿行数,不能有空行
    Public Function GetRows(ByVal column As Integer, ByVal sheet As Excel.Worksheet) As Integer
        Dim row As Integer
        Try
            For row = 1 To 65536
                If sheet.Cells(row, column).value <> "" Then
                    GetRows = row
                Else
                    Exit For
                End If
            Next
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '获得工作簿的列数,不能有空列
    Public Function GetColumns(ByVal row As Integer, ByVal sheet As Excel.Worksheet) As Integer
        Dim Column As Integer
        Try
            For Column = 1 To 255
                If sheet.Cells(row, Column).value <> "" Then
                    GetColumns = Column
                Else
                    Exit For
                End If
            Next
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '释放excel资源
    Public Function DisposExcel() As Boolean
        Try
            xlsworksheet = Nothing
            xlsworkbook = Nothing
            xls = Nothing
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '************************************************************************************************************
    '创建一个word文档

    Public Function CreateDoc(ByVal bool As Boolean) As Boolean
        Try
            doc = New Word.Application
            doc.Visible = bool
            doc = CreateObject("word.application")
            document = doc.Documents.Add()
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '打开一个word文档
    Public Function OpenDoc(ByVal path As String, ByVal name As String, ByVal bool As Boolean) As Boolean
        Try
            doc = New Word.Application
            doc.Visible = bool
            doc = CreateObject("word.application")
            document = doc.Documents.Open(path & name)
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '保存打开的文档
    Public Function SaveDocument() As Boolean
        Try
            document.Save()
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '保存新创建的文档
    Public Function SaveDocument(ByVal path As String, ByVal name As String) As Boolean
        Try
            document.SaveAs(path & name)
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '关闭文档
    Public Function CloseDocument() As Boolean
        Try
            document.Close()
            doc.Quit()
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
    '释放word资源
    Public Function DisposWord() As Boolean
        Try
            doc = Nothing
            document = Nothing
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try
    End Function
End Class

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值