Guide for VB.NET
Core Document Formats
Additional Features

VB.NET Excel - Use VB.NET Demo to Split Excel

VB.NET Excel Splitter Control to Disassemble .XLSX File to Smaller Sub-documents

VB.NET
Home > .NET Imaging SDK > VB.NET > Split Excel Document
To get started with DocImage SDK for .NET, you are supposed to read VB.NET Imaging: Get Started first!

VB.NET Excel splitting control add-on offers an effective .NET solution for developers to split & disassemble source .xlsx file into smaller Excel documents programmatically. From this VB.NET Excel disassembling tutorial page, you will find answers to following VB.NET Excel splitting related questions.
Related .net document control helps:
asp.net view powerpoint: ASP.NET PowerPoint Document Viewer Control (MVC & WebForms): view ppt, pptx files online in C# using ASP.NET
asp.net pdf editor component: EdgePDF: ASP.NET PDF Editor Web Control: Online view, annotate, redact, edit, process, convert PDF documents
asp.net edit pdf page control: ASP.NET PDF Pages Edit Control: add, remove, sort, replace PDF pages online using C#
asp.net dicom library: ASP.NET Dicom Document Viewer Control: view, annotate dicom imaging files online in ASP.NET
asp.net mvc pdf editor control: ASP.NET MVC PDF Viewer & Editor: view, annotate, redact, edit PDF document in C# ASP.NET MVC
asp.net document viewer example: EdgeDoc:ASP.NET Document Viewer C# Control: Open, view, annotate, redact, convert documents online in C#, VB.NET, AS...
c# asp.net mvc document viewer: ASP.NET MVC Document Viewer: view, annotate, redact files on ASP.NET MVC web projects
  • What VB.NET APIs can I use to split and separate Excel file?
  • Is there any VB.NET Excel splitting demo code that I can refer to?
  • What are the benefits of this VB.NET Excel splitting control SDK?
Excel Splitting APIs
This VB.NET Excel splitting control add-on offers four main APIs for developers to split source .xlsx file into sub-documents.
Private Sub SplitDocument(source As Stream, index As Integer, destns As List(Of [String])) Implements XLSXDocument.SplitDocument
End Sub
Private Sub SplitDocument(source As [String], index As Integer, destns As List(Of [String])) Implements XLSXDocument.SplitDocument
End Sub
Private Sub SplitDocument(source As Stream, index As Integer, destns As List(Of Stream)) Implements XLSXDocument.SplitDocument
End Sub
Private Sub SplitDocument(index As Integer, source As [String], destns As List(Of Stream)) Implements XLSXDocument.SplitDocument
End Sub
API Explanations: to help you better understand above mentioned VB.NET Excel splitting APIs, we here specifically address some key points that you may need to pay attention to.
  • XLSXDocument: Within the whole VB.NET Excel document reading and editing SDK, one Excel document file will be treated as an XLSXDocument object. That is to say, once an Excel file is decoded into VB.NET application using RasterEdge VB.NET Excel manipulating control add-on, an XLSXDocument instance will be created immediately. And there are some other ways for generating XLSXDocument object at this VB.NET Excel creating, loading and saving tutorial page.
  • XLSXPage: For a better displaying purpose, one Excel sheet is regarded as one page. Thus, XLSXPage is a programming class which is used to represent one Excel sheet and this class is derived from super class REPage.
  • SplitDocument: Using this VB.NET SplitDocument method, developers can easily separate source .xlsx file into two smaller Excel documents at specified page index.
  • Stream source and string source: As this VB.NET Excel splitting control add-on enables developers to load and decode .xlsx file from PC files or web stream, developers are allowed to interpret source Excel that is existed in the form of .xlsx file or memory stream.
  • List destns & List destns: This VB.NET Excel disassembling component can be also used to save split sub-documents to desired path as .xlsx file or stream.
VB.NET Demo Code
Although VB.NET Excel splitting APIs are listed above, we here expressly offer a detailed snippet of VB.NET demo code to help you have a greater control of this VB.NET Excel splitter library component. Using this VB.NET demo code, you can easily separate source Excel file that is stored in local file or web server into two smaller Excel documents by just defining a page index value.
For instance, there are 8 sheets in source Excel file and you want disassemble this .xlsx file into two documents, one of which contains the first 3 sheets and the other of which contains the later 5 sheets. Then, you can easily and accurately achieve this VB.NET Excel splitting task by defining the pageidx as 2.
''' Split an Excel document into two sub-documents.
''' </summary>
''' <param name="originalDocument"></param>
''' <param name="pageIdx"></param>
Public Sub splitXLSXDocument(sourceFilePath As [String], destnsPath As List(Of [String]), pageIdx As Integer)
XLSXDocument.SplitDocument(sourceFilePath, pageIdx, destnsPath)
End Sub
Excel Splitter Benefits
After telling you the detailed working principle of this VB.NET Excel splitter control add-on, we here illustrate other benefits that you can get by using RasterEdge VB.NET Excel splitting library component.

Professional and Advanced VB.NET Excel Splitting Control Add-on

Written in managed C# code, this VB.NET Excel splitting control add-on is compatible with .NET Framework 2.0 & later versions. Besides, it can be used to separate source Excel file in ASP.NET web application or Windows Forms project using Microsoft Visual Studio 2005 or greater.

Compatible with Several Versions of Microsoft Excel

As is said above, this VB.NET Excel splitter control add-on can process & split Excel file ends with .xlsx, therefore, Microsoft Excel 2007 & later versions are all supported.

Able to Perform Other Excel Processing Functions

Coupled with other Excel sheet processing features, this VB.NET Excel splitter control add-on can be also used to insert/delete Excel sheet, sort Excel order, extract Excel sheet(s), merge Excel files and add image to Excel sheet using VB.NET code.


Recommend this to Google+


RasterEdge.com is professional provider of ASP.NET MVC Document Viewer, ASP.NET PDF Viewer, MVC PDF Viewer document, content and imaging solutions, available for ASP.NET AJAX, Silverlight, Windows Forms as well as WPF. We are dedicated to provide powerful & profession imaging controls, PDF document, image to pdf files and components for capturing, viewing, processing, converting, compressing and stroing images, documents and more.

©2000-2017 Raster Edge.com