In the API, one way to get data that is common to most of our sequential surface types, like Radius of Curvature or Thickness, is obtainable by starting with the GetSurfaceAt() function within the ILensDataEditor interface. This will return an object within the ILDERow interface:

 

In MATLAB, obtaining the first surface as an object within the LDERow interface might look like as follows:

 

From here, we can obtain the common data between sequential surfaces using the following properties:

 

Retrieving and setting the Parameter values, however, is a little different. One of the most direct ways to deal with this is to use the GetCellAt() function:

 

With this method, we'll have to specify the column value itself based on the column location in the spreadsheet, which includes all of the common data (the following screenshot is using the Express View to show the 'Par 0' column which is accounted for in the indexing of the LDE):

 

So, you can use GetCellAt() to retrieve a specific cell in your spreadsheet, and subsequently use the IEditorCell interface properties to get and set Parameter Values (and you can also retrieve the header for that cell from here as well!):

 

Of course, this is just one way to retrieve this set of information. Another function in the ILDERow interface called GetSurfaceCell() behaves very similarly, but requires the use of enumerated values to select the column of interest:

 

For some demonstration on how this function works, you can take a look at the following Knowledgebase articles:

• 
  

  Tips and tricks when using the ZOS-API with MATLAB

  
  


• 
  

  ZOS-API using MATLAB

  
  

~ Angel