-
Nov 26th, 2020, 03:29 AM
#1
Thread Starter
PowerPoster
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
-
Nov 26th, 2020, 10:58 AM
#2
Re: how to read Excel workbooks without office excelapplication,without drives
Originally Posted by xiaoyao
No COM+, no interop.[/url]
Only .Net inside :-))
-
Nov 26th, 2020, 11:02 AM
#3
Hyperactive Member
Re: how to read Excel workbooks without office excelapplication,without drives
-
Nov 27th, 2020, 06:44 AM
#4
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
-
Nov 27th, 2020, 07:23 PM
#5
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.
-
Nov 28th, 2020, 03:52 AM
#6
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>
-
Nov 28th, 2020, 01:40 PM
#7
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?
-
Nov 29th, 2020, 03:51 AM
#8
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.
-
Nov 30th, 2020, 03:45 AM
#9
Hyperactive Member
Re: how to read Excel workbooks without office excelapplication,without drives
Last edited by Argus19; Nov 30th, 2020 at 03:58 AM.
-
Nov 30th, 2020, 12:10 PM
#10
Thread Starter
PowerPoster
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
-
Dec 1st, 2020, 11:06 AM
#11
Hyperactive Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|