If you've suddenly found yourself working from home without your Golden Software product, don't worry! Contact us with your product key or the name of your company/university and we'll get you a free, temporary license. In times like these, we all need a little extra good will.

Welcome to Golden Software Support

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 November 2, 2018

Comments

0 comments

Please sign in to leave a comment.

Welcome to Golden Software Support

Related articles