Results 1 to 11 of 11

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

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2020
    Posts
    546

    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

  3. #3
    Lively Member
    Join Date
    Jul 2020
    Posts
    123

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


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

    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
    Fanatic Member
    Join Date
    May 2014
    Location
    Kallithea Attikis, Greece
    Posts
    1,012

    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
    Posts
    2,599

    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
    Fanatic Member
    Join Date
    May 2014
    Location
    Kallithea Attikis, Greece
    Posts
    1,012

    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
    Posts
    2,599

    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
    Lively Member
    Join Date
    Jul 2020
    Posts
    123
    Last edited by Argus19; Nov 30th, 2020 at 03:58 AM.

  10. #10

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2020
    Posts
    546

    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
    Lively Member
    Join Date
    Jul 2020
    Posts
    123

    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