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.
Syncfusion Feedback

How do I create a simple spreadsheet using XlsIO?

How do I create a simple spreadsheet using XlsIO?

XlsIO has a very intuitive object model that is similar to the Excel object model. So the process of creating a new spreadsheet is similar to what you would do using MS Excel:

1. Open a new instance of XlsIO. This is the equivalent to launching MS Excel, but the difference is that MS Excel creates a new workbook by default but in XlsIO, we create a new workbook in the next step.

C#


VB

 

Just like MS Excel, now that we have created an instance of Excel we can create any number of new workbooks that we want.

2. The next step after launching an Excel application is to create a new workbook. This is done as follows:

C#


VB

 

3. As mentioned previously, once an instance of Excel is created, we can then create any number of new workbooks that we want.

C#


VB


4. At this point we have a workbook object that is similar to the blank workbook that we have in MS Excel. XlsIO has many APIs that allow you to manipulate the contents and formatting of the workbook just like you would do in MS Excel UI. Here is the complete code used in this sample:

C#


VB

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
1937 04/30/2011 07/10/2014 Windows Forms XlsIO
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon 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.Close Icon