Excel how to display just rows autofilter?

[robertsan]

Hi, I have an excel file with 5000 rows, when I apply autofilter it display 2 or 50 rows (others rows are hidden) how to display in labview just rows not hidden in excel? thanks for your help 

[Coamín]

Hi robertsan

You can use the invoke node for excel ( Autofilter or Advance filter). I attach an image with them. If you don't have experience with that, an easy way could be that with an excel macro you copy the data filtered to other sheet and you read the data in LabVIEW.

You can find examples in Help>>Find examples>>search>>excel

If you have questions, just tell me.

También este foro se puede responder en español por si así lo prefieres.

Saludos

Coamín Cruz