Results 1 to 11 of 11

Thread: how to read Excel workbooks without office excelapplication,without drives

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Jan 2020
    Posts
    3,746

    how to read Excel workbooks without office excelapplication,without drives

    who can make a .net dll for vb6?
    for read excel TABLE,Write excel sheet

    https://archive.codeplex.com/?p=npoi
    GitHub - nissl-lab/npoi: a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
    https://github.com/nissl-lab/npoi

  2. #2
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Location
    Sofia, Bulgaria
    Posts
    5,120

    Re: how to read Excel workbooks without office excelapplication,without drives

    Quote Originally Posted by xiaoyao View Post
    No COM+, no interop.[/url]
    Only .Net inside :-))

  3. #3
    Hyperactive Member
    Join Date
    Jul 2020
    Posts
    370

    Re: how to read Excel workbooks without office excelapplication,without drives


  4. #4
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: how to read Excel workbooks without office excelapplication,without drives

    why not just use ADO, no office or .net required
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  5. #5
    Frenzied Member
    Join Date
    May 2014
    Location
    Kallithea Attikis, Greece
    Posts
    1,289

    Re: how to read Excel workbooks without office excelapplication,without drives

    I have code to open excel files xlsx, but I made for specific files from Inventor2, with images, so the code isn't universal.
    The xlsx files are zip files with xml files inside (and maybe jpg files for images). wqweto has a nice ZipArchive which I use to open xlsx files, and to reading the xlsx isn't difficult.

    You can use ADO to open these files, but there is a problem with the types of cells, if a column has mixed types.

  6. #6
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Location
    Sofia, Bulgaria
    Posts
    5,120

    Re: how to read Excel workbooks without office excelapplication,without drives

    @georgekar: The original purpose of ZipArchive was to be able to read/write .xlsb files -- the native binary BIFF12 worksheet format, not the diluted .xlsx XML based worksheet format made for compatibility with OpenOffice.

    The BIFF12 effort is here: https://github.com/wqweto/Biff12Writer

    For instance Excel clipboard format uses its binary BIFF12 representation, not the XML travesty.

    cheers,
    </wqw>

  7. #7
    Frenzied Member
    Join Date
    May 2014
    Location
    Kallithea Attikis, Greece
    Posts
    1,289

    Re: how to read Excel workbooks without office excelapplication,without drives

    You did so much good work and I appreciate that.
    I have a question about BIFF12, you can export images from that?


  8. #8
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Location
    Sofia, Bulgaria
    Posts
    5,120

    Re: how to read Excel workbooks without office excelapplication,without drives

    Images are stored as PNGs inside a folder much like xlsx format.

    It’s only XML parts that are stored as more compact BIN parts.

  9. #9
    Hyperactive Member
    Join Date
    Jul 2020
    Posts
    370
    Last edited by Argus19; Nov 30th, 2020 at 03:58 AM.

  10. #10

    Thread Starter
    PowerPoster
    Join Date
    Jan 2020
    Posts
    3,746

    Re: how to read Excel workbooks without office excelapplication,without drives

    libxl.dll is best for you, But it's not Free.
    stdcall,cdecl, 64bit

  11. #11
    Hyperactive Member
    Join Date
    Jul 2020
    Posts
    370

    Re: how to read Excel workbooks without office excelapplication,without drives

    If you create such a library on a computer with .Net and Ms Office libraries installed, will the library work on a computer that does not have it installed?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width