Articles in this section
Category / Section

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

1 min read

We can generate reports with .NET library from VB 6.0 in two ways. Either by registering XlsIO.Base for COM and use 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 it and then bind it 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:

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

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied