1. Discussion Forums
    2. .NET
    3. .NET
You must Sign In to post a response.
  • Category: .NET
    Points:5

    Free nuget for generating excel reports

    I am using VS 2015 for developing excel reports. I have used Microsoft.Office.Interop.Excel for developing excel reports. Its version is 15.0.0.0. But it is giving error as,
    23/01/2022:Error Exporting to Excel : :Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.;

    23/01/2022:Funnel Dump : :Cannot create ActiveX component.;

    I tried searching and found this,
    https://nugetmusthaves.com/Tag/excel

    All are paid versions and I want free version. Only Microsoft.Office.Interop.Excel is free and it is giving error. I want to try another dll which is free. Is it possible or should I purchase dll ?
  • #770244

    Points:2
    Alternatively, you could use Free Spire.XLS for .NET (available on NuGet) to create or manipulate Excel files in C# or VB.NET.

    https://www.nuget.org/packages/FreeSpire.XLS/

  • #770247

    Points:1
    Dear Chris,

    Thanks for providing the solution. I have checked the dll. It can export data up to 200 rows. We have unlimited data and I can not export this data. After 200th row , every thing is blank.
    Regards,
    Programmer

    http://www.dotnetutorial.com/interview-questions.aspx?catid=1


    • Sign In to post your comments
    Submit New Thread
    Return to Return to Discussion Forum

    Top Contributors

    Today
      Last 7 Days

        more...

        About dotnetspider.com

        We believe in providing quality content to our readers. If you have any questions or concerns regarding any content published here, feel free to contact us using the Contact link below.

        Quick Links
        General
        Services

        Digital Marketing by SpiderWorks Technologies, Kochi - India. ©