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

Information required about XLSIO

Thread ID:

Created:

Updated:

Platform:

Replies:

74352 Jun 10,2008 02:55 AM UTC Jun 10,2008 09:56 AM UTC Windows Forms 3
loading
Tags: XlsIO
Adrian Robson
Asked On June 10, 2008 02:55 AM UTC

Hi,

I'm looking at using the XLSIO component and had a few questions:

1) Does the XLSIO component have its own engine? How does it read Excel files without Excel being present?

2) Does the XLSIO component support Excel spreadsheets that have VBA code in them?

Thanks


Yavanaarasi G [Syncfusion]
Replied On June 10, 2008 06:13 AM UTC

Hi Adrian,

Thank you for your interest in Syncfusion products.

1) Does the XLSIO component have its own engine?

Yes. XlSIO component have its own engine for writing and reading Excel files.

How does it read Excel files without Excel being present?

Essential XlsIO is a .NET library that can read and write Microsoft Excel files It features a full-fledged object model similar to the Microsoft Office COM libraries. It does not use COM interop and is built from scratch in C#.Hence it can be used without MsExcel installed. However, to view the output file, you will need some viewer.

2)Does the XLSIO component support Excel spreadsheets that have VBA code in them?

VBA functions cannot be created using XlsIO but they can be used in templates. This means that you would have to define the functions in VBA using MS Excel and cannot do it during runtime using XlsIO. For example, you can have a spreadsheet that can have macros in it and then use XlsIO to open these spreadsheets as a template and make modifications to the spreadsheet. When this modified spreadsheet is resaved using XlsIO the macro is retained. However, there are no plans to allow manipulating/running Macros through XlsIO API.

Here is a sample that demonstrates macro usage in XlsIO

http://www.syncfusion.com/Support/user/uploads/VBA_b814797b.zip

Please let me know if you have any other questions.


Regards,
G.Yavana


test
Replied On June 10, 2008 09:01 AM UTC

Thanks for the reply. So there's no way to *run* the VBA macros using XlsIO?

What we had planned on doing was having a few VBA functions that perform calculations that the built-in Excel functions aren't suitable for. But if there's no way to run them using XlsIO, I guess we'll just have to resort to using Excel directly.

Which is really to be expected. For you to re-implement all of VBA would be a monumental amount of work! Oh well, thanks anyway.


Yavanaarasi G [Syncfusion]
Replied On June 10, 2008 09:56 AM UTC

Hi Adrian,

Thank you for your update.

Please let me know if you have any other concerns.

Regards,
G.Yavana


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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

;