12:08 am (GMT+10:00)
> To: pod...@gmx.com, users@hop.apache.org
> Subject: Re: Any trick to read data from Excel file where no of columns is
> not known?
>
> It’s not part of our distribution but there is a python transform [1]
>
> Cheers,
> Hans
>
> [1] ht
+10:00) To:
pod...@gmx.com, users@hop.apache.org Subject: Re: Any trick to read data from
Excel file where no of columns is not known? It’s not part of our distribution
but there is a python transform [1]Cheers,Hans[1]
https://github.com/m-a-hall/hop-cpython On 2 December 2022 at 12:59:04
will be one day?
>
> Regards
>
>
>
> Sent: Thursday, December 01, 2022 at 4:28 PM
> From: "Matt Casters"
> To: users@hop.apache.org
> Subject: Re: Any trick to read data from Excel file where no of columns is
> not known?
>
> A long time ago I did this in &#
Thank you!
Sent: Friday, December 02, 2022 at 1:07 PM
From: "Hans Van Akelyen"
To: pod...@gmx.com, users@hop.apache.org
Subject: Re: Any trick to read data from Excel file where no of columns is not known?
It’s not part of our distribution but there is a python transform [1]
Ch
tages. But there's no Python
action in Hop :-(
There will be one day?
Regards
Sent: Thursday, December 01, 2022 at 4:28 PM
From: "Matt Casters"
To: users@hop.apache.org
Subject: Re: Any trick to read data from Excel file where no of columns is
not known?
A long time ago I did th
e: Any trick to read data from Excel file where no of columns is not
known?
A long time ago I did this in 'another' tool.
IIRC this is what's involved:
1) Scan the Excel files and determine the sheets, number of columns, their
names and data types
1a) Sheets: leave the sheet name
A long time ago I did this in 'another' tool.
IIRC this is what's involved:
1) Scan the Excel files and determine the sheets, number of columns, their
names and data types
1a) Sheets: leave the sheet name blank in the list, simply set start
column/row to 0/0, include sheet name as an additional co
