Follow

How do I specify the XLS sheet name in the Surfer GridData automation command?

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 February 15, 2017

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.