usmanazizgroupdocs
1/26/2017 - 2:10 PM

RenderExcelAsHtmlWithCountRowsPerPage.vb

' For complete examples and data files, please go to https://github.com/groupdocs-viewer/GroupDocs.Viewer-for-.NET
Dim config As ViewerConfig = Utilities.GetConfigurations()

' Create html handler
Dim htmlHandler As New ViewerHtmlHandler(config)
Dim guid As String = DocumentName

' Set html options to show grid lines
Dim options As New HtmlOptions()
options.CellsOptions.OnePagePerSheet = False

' Set count rows to render into one page. Default value is 50.
options.CellsOptions.CountRowsPerPage = 50

' Get pages
Dim pages As List(Of PageHtml) = htmlHandler.GetPages(guid, options)

For Each page As PageHtml In pages
    'Save each page at disk
    Utilities.SaveAsHtml(Convert.ToString(page.PageNumber + "_") & DocumentName, page.HtmlContent)
Next