Import (open) data from excel

sirihofstadtrap

Hi,

I'm trying to import data from excel by using the open function

My code is as follows:

Open("C:\Users\"username"\Documents\Statistics\Test.xlsx");

I use my username instead of "username"

I don't get any error messages, but nothing happens when I run the script.

Why does it not open?

Thanks

sirihofstadtrap

Thank you!

It works if I use the following code:

open("C:\Users\......\Test.xlsx",

                        Worksheets( "Data" ), 

                        Use for all sheets( 1 ),

                        Concatenate Worksheets( 0 ),

                        Create Concatenation Column( 0 ),

                        Worksheet Settings(

                                            1,

                                            Has Column Headers( 1 ),

                                            Number of Rows in Headers( 2 ),

                                            Headers Start on Row( 1 ),

                                            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 )

                                        )

            );