Multiple file import Excel hidden row

[#1]

Hello,

I am using JMP 18 and I need to import multiple excel files.
As different users applied different filters I add this command to import even filtered rows from all excel files.
<

However the filtered data are not imported. Is there a difference on how JMP or excel handle hidden vs filtered rows? Is there another command I should use?

Many thanks for your help

Marie

[#2]

Does single file export work fine for you?

For me Multiple File Import (and normal Open with settings) seem to work fine: I have very simple excel file like this where value = 2 has been filtered out from A

and multiple file import is able to import it

View more...

Multiple File Import(
	<

[#3]

Dear Jarmo,

Thanks for your prompt reply.
It is working when I do it for only one table but it doesn't work if I do it for multiple files either using jsl or the platform.

My excel sheets have macros and it is a date filter.
Not sure if it could make a difference.

[#4 · Accepted solution]

I would guess that it could make a difference depending on how the macros have been created, for example the data might not be there at all if it is being filtered out by a macro (so it is not hidden) but if it works for single file that seems a bit weird (If I just copy paste my simple demo excel sheet it is still working with Multiple File Import).

Maybe you can just avoid Multiple File Import and loop over the files using some JSL if Multiple File Import has some problems importing your file. It might also be worth contacting JMP support as there could be some bugs (excel import did change in JMP18 https://community.jmp.com/t5/JMP-Knowledge-Base/Changes-to-the-import-of-Microsoft-Excel-files-in-JMP-18/ta-p/655981)

[#5]

Thanks again,

Yes I will contact support.

The data are here and just filtered, the macros are executed on other columns than the one filtered.

Your fast and precise answers are really helping me with my JSL.

Best,

Marie

[#6 · Accepted solution]

Hello,

I have followed up with support and think it is worth to put the answer here so people struggling will find the answer here.

Hidden and Filtered rows are two different things. So "<<Set Excel Suppress Hidden Rows( 0 )," doesn't apply to filtered rows.
You have to remove filter from excel so you can import all data in JMP.

[#7]

I would like to add;

- In JMP 18 - the JSL script generated by Excel Import Wizard to "Suppress Hidden Rows (1)" seems didn't work.

It works in JMP 17.2.

- I've contacted JMP Technical support but rather than creating a new discussion, I think it would beneficial to continue from this discussion to avoid duplicating almost similar topic:

So far, the work-around that I can think-of requires me to accept this "hidden" row in Excel during importing.

But, it messed-up 24 numeric columns "Data type" including 6 columns with "Date format" due to 1 empty row.

I'm looking for an alternative to "Suppress the Hidden Rows" during Excel Import before adding more lines to my script.

Thanks