Thursday, September 12, 2013

Create new workbook (新規にExcelファイルを作成する)

Imports NPOI.HSSF
Imports NPOI.HSSF.UserModel
Imports NPOI.SS.UserModel
Imports NPOI.HPSF


    Private Sub CreateNewWorkBook()
        Dim wb As New HSSFWorkbook()
 
        'Create an entry of DocumentSummaryInformation  
        Dim dsi As DocumentSummaryInformation = PropertySetFactory.CreateDocumentSummaryInformation()
        dsi.Company = "Company Name"
        wb.DocumentSummaryInformation = dsi
 
        'Create an entry of SummaryInformation  
        Dim si As SummaryInformation = PropertySetFactory.CreateSummaryInformation()
        si.Subject = "Subject"
        wb.SummaryInformation = si
    End Sub

No comments:

Post a Comment