README.md

Moca.NET Office

Overview

Wrapper library of Excel. without the memory release of the Excel object.
References of excel library is not required.
we do not have wrapping all of the functions.

Support for multiple frameworks

Microsoft .NET Framework

• 2.0
• 3.5
• 4.0
• 4.5
• 4.5.2
• 4.6
• 4.6.2
• 4.7
• 4.7.2
• 4.8

How to get

URL:https://www.nuget.org/packages/Moca.NETOffice/

PM> Install-Package Moca.NETOffice

Programming

Using xlsx As ExcelWrapper = New ExcelWrapper()
    Dim book As BookWrapper
    book = xlsx.Workbooks.Open(Path.Combine(My.Application.Info.DirectoryPath, "Book1.xlsx"))

    book.ActiveSheet.Range("9:9").Copy()
    book.ActiveSheet.Range("10:10").Insert()

    book.ActiveSheet.Cells(10, 2).Value = 5
    book.ActiveSheet.Cells(10, 3).Value = 14
    book.ActiveSheet.Cells(10, 4).Value = 24
    book.ActiveSheet.Cells(10, 5).Value = 34
    book.ActiveSheet.Cells(10, 6).Value = 44

    book.ExportAsFixedFormat(FixedFormatType.XPS, "C:\Temp\Test.xps")
    book.ExportAsFixedFormat(FixedFormatType.PDF, "C:\Temp\Test.pdf", , , , , , True)

    book.Saved = True
    xlsx.DisplayAlerts = False
End Using

Other Libraries

Moca.NET Organization

Visual Studio Extensions

• Moca.NET Template Extension
• Moca.NET Snippets Extension

Sample

• Web Form Application

  • http://miyabis.github.io/Moca.NET-WebAppDemo/
  • https://code.msdn.microsoft.com/vstudio/MocaNET-Framework-Web-0e8d6dd7

• Windows Form Application

  • http://miyabis.github.io/Moca.NET-WinAppDemo/
  • https://code.msdn.microsoft.com/vstudio/MocaNET-Framework-Windows-7174d250

For Development

• Visual Studio 2019

License

Microsoft Public License (MS-PL)

http://opensource.org/licenses/MS-PL