Whatever I do I can not import data from excel. with JMP 11 without excel wizard the column properties were well recognized of xls format.
After switching to V12 all columns are character to JMP and after changing the column to numeric data gets lost.
Open(
"/Users/......../2015_BUDGET_REALISATION.xlsx",
Worksheets( "REALDATA" ),
Use for all sheets( 0 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 1 ),
Data Starts on Row( 2 ),
Data Starts on Column( 1 ),
Data Ends on Row( 0 ),
Data Ends on Column( 0 ),
Replicated Spanned Rows( 0 ),
Suppress Hidden Rows( 1 ),
Suppress Hidden Columns( 1 ),
Suppress Empty Columns( 0 ),
Treat as Hierarchy( 0 )
)
)
First the Date type variable is a character which causes problems when joining/updating/concatenating with another table with same name column wth date/time properties
Try to write a script to change it to numeric but then data gets lost
Switching to date/time doesnt help
Changing the excel format cell also does not help.
Managing Director is waiting for sales report and I am in trouble
