read excel .xlsx file data ...

[al2791]

It's OK
Thank you very much

[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!

[HeX0R]

You are right, should be fixed now.

[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

[HeX0R]

Yeah, I'm pretty sure, whoever "developed" that format must have had some serious brain damage

[loulou2522]

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

[infratec]

Yes, but ...

not in Linux and not in macOS.

[Little John]

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?

[Kurzer]

Yeah, I'm pretty sure, whoever "developed" that format must have had some serious brain damage

Yes, especially because of the "shared strings technology".

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.

[doctorized]

Tested HeX0R's code and work just fine. Is there a way to read xls files too?

[mk-soft]

Is a different format.
Try with ODBC driver

[doctorized]

Is a different format.
Try with ODBC driver

Is there any example?

[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

[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.

[Little John]

I'm very surprised that no one has mentioned comate

Please read this thread once again.