We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to split a range and save the contents into different worksheets or workbook using XlsIO

Data in a worksheet can be split into different worksheets or workbooks. To achieve this, the data in the source worksheet need to be accessed by UsedRange property to find the total rows and columns used, then need to split based on the requirement.

The below code shows the portion of saving different workbooks or worksheets by splitting a range.

C#

 

VB

 

The sample which illustrates the above behavior can be downloaded here.

 

Article ID: Published Date: Last Revised Date: Platform: Control:
7845 07/13/2017 07/13/2017 Windows Forms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.