Hidden Excel Rows

[ecotton]

Hello!

Is it possible to pull in an excel sheet with hidden rows and leave those same rows hidden? Would a specific macro work? 

Thanks :)

[IraWatt]

Hey @ecotton,

Don't know if there is a way natively in Alteryx, as far as I've seen Alteryx removes all formatting information such as hidden. However its definitely doable using the python tool, could build a macro around this: How to read excel cell and retain or detect its format in Python - Stack Overflow.

HTH,

Ira