I'm trying to import excel (365) file, and I can't do it.
I'll mention that until I've updated the Office to 365 everything worked fine.
Someone's having a similar problem or someone has a solution?
Open( "C:\Desktop\namefile.xlsx", Worksheets( "Sheet1" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 2 ), Data Starts on Row( 3 ), Data Starts on Column( 1 ), Data Ends on Row( 0 ), Data Ends on Column( 0 ), Replicated Spanned Rows( 1 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Treat as Hierarchy( 0 ) );
Just a thought: is the file still open in Excel? If so, close out of Excel. Maybe that would fix it?
I tried to import the Excel file in JMP 11 and it didn't work,
but I tried to import the same file in JMP 14 and it works! :)
I don't know what the problem was but it works.
Thx to all for the support.
There are no labels assigned to this post.