Page 2 of 3
Re: read excel .xlsx file data ...
Posted: Wed Jun 28, 2023 5:19 pm
by al2791
It's OK
Thank you very much
Re: read excel .xlsx file data ...
Posted: Wed Jul 05, 2023 10:32 am
by morosh
In the example posted by al2791:
https://wetransfer.com/downloads/f09b04 ... e=sendgrid, line 5 is empty. It seems that it isn't taken into account, as requesting display of line 5, result in line 6. So line 5 is interpreted as the 5th non empty line.
Thanks anyway!
Re: read excel .xlsx file data ...
Posted: Wed Jul 05, 2023 1:50 pm
by HeX0R
You are right, should be fixed now.
Re: read excel .xlsx file data ...
Posted: Thu Aug 31, 2023 8:03 pm
by Kurzer
Hi HexOR,
thank you very much for your Excel module.
Good that I was looking for something like that after all, because I was just about to write something of my own to be able to read in Excel tables with PB.
Pew, then I don't need to reverse engineer the XLSX format further
Re: read excel .xlsx file data ...
Posted: Sat Sep 02, 2023 10:34 am
by HeX0R
Yeah, I'm pretty sure, whoever "developed" that format must have had some serious brain damage
Re: read excel .xlsx file data ...
Posted: Sat Sep 02, 2023 12:06 pm
by loulou2522
Kurzer wrote: Thu Aug 31, 2023 8:03 pm
Hi HexOR,
thank you very much for your Excel module.
Good that I was looking for something like that after all, because I was just about to write something of my own to be able to read in Excel tables with PB.
Pew, then I don't need to reverse engineer the XLSX format further
HI,
with comate plus you can do what you want with execle amd more simply. see examples on comateplus
Re: read excel .xlsx file data ...
Posted: Sat Sep 02, 2023 1:15 pm
by infratec
Yes, but ...
not in Linux and not in macOS.
Re: read excel .xlsx file data ...
Posted: Sat Sep 02, 2023 1:35 pm
by Little John
infratec wrote: Sat Sep 02, 2023 1:15 pm
Yes, but ...
not in Linux and not in macOS.
And even on Windows you can open/edit Excel files with COMatePLUS only if Excel is installed on the same computer, no?
Re: read excel .xlsx file data ...
Posted: Sun Sep 03, 2023 5:52 pm
by Kurzer
HeX0R wrote: Sat Sep 02, 2023 10:34 am
Yeah, I'm pretty sure, whoever "developed" that format must have had some serious brain damage
Yes, especially because of the "shared strings technology".
Little John wrote:And even on Windows you can open/edit Excel files with COMatePLUS only if Excel is installed on the same computer, no?
If Excel has to be installed, that would be an exclusion criterion for COMatePlus. I also just want to read a few rows from a spreadsheet. HexOR's include file probably has less overhead.
Re: read excel .xlsx file data ...
Posted: Mon Jan 22, 2024 11:09 pm
by doctorized
Tested HeX0R's code and work just fine. Is there a way to read xls files too?
Re: read excel .xlsx file data ...
Posted: Mon Jan 22, 2024 11:59 pm
by mk-soft
Is a different format.
Try with ODBC driver
Re: read excel .xlsx file data ...
Posted: Tue Jan 23, 2024 11:08 am
by doctorized
mk-soft wrote: Mon Jan 22, 2024 11:59 pm
Is a different format.
Try with ODBC driver
Is there any example?
Re: read excel .xlsx file data ...
Posted: Tue Jan 23, 2024 4:39 pm
by ebs
Hello HeX0R!
I have an XLSX spreadsheet that causes your code to get stuck in a loop.
Would you be willing to look at this spreadsheet to try to figure out what's going on?
If so, I will send you a PM with a link to download it.
Thank you,
Eric
Re: read excel .xlsx file data ...
Posted: Tue Jan 23, 2024 4:46 pm
by loulou2522
I'm very surprised that no one has mentioned comate, because with this module it's even possible to emulate visual basic quite simply and thus control an excel file.
Re: read excel .xlsx file data ...
Posted: Tue Jan 23, 2024 8:38 pm
by Little John
loulou2522 wrote: Tue Jan 23, 2024 4:46 pm
I'm very surprised that no one has mentioned comate
Please read this thread once again.