How can we generate reports with .NET Component of Essential XlsIO from VB 6.0?

We can generate reports with the .NET library from VB 6.0 in two ways. Either by registering XlsIO.Base for COM and using it in VB, or by creating the respective classes in .NET that would help you work with the XlsIO library and make it visible to COM. You need to create COM Interop assemblies, register them, and then bind them from VB 6.0.

Steps to generate a report for Case 1:

Register the XlsIO.Base assembly as mention in below url.

• Register the XlsIO.Base assembly as mention in below url.

     http://support.microsoft.com/kb/817248

• Add the .tlb file as reference in VB 6.0 application.
• Write your code to access the classes and methods in XlsIO.Base library.

Steps to generate a report for Case 2:

• Create a .NET library to generate report using XlsIO.
• On the ‘Application’ tab click the ‘Assembly Information’.Make assembly COM-visible as true.
• On the ‘Build’ tab check the ‘Register for COM interop’ checkbox (towards the bottom: you

may need to scroll down). Also strong name the assembly by signing it.

• Build the application to generate the signed and interop assemblies.
• Add the .tlb file as reference in VB 6.0 application.
• Write your code to access the classes and methods in your sample library.

Here is the sample for your reference:

https://www.syncfusion.com/Development/uploads/XlsIOComInterop_a3251405.zip

​