Use the GridData3 method, which includes the DataFileOptions parameter, to open a particular worksheet in an Excel file. The sheet specification is one of the DataFileOptions options.
SurferApp.GridData3("c:\temp\book1.xls",DataFileOptions:="sheet=Test", ShowReport:=True,OutGrid:="c:\temp\book1.grd")
Updated November 2, 2018
Comments
0 comments
Please sign in to leave a comment.