Managing Elements from an Excel File

The following procedure shows how to create and use and Excel file that allows you to drive the parameters of each facet of the Optical Lens individually.

To create and use an Excel file:

Prerequisites:

An Optical Lens Rectangular or Circular must already be defined.

No group must have been created. Only the Ungrouped Elements must be present (and Central Closing group in case of an Optical Lens Circular).

Make sure the Optical Lens is compatible with the Excel file definition.

  1. From the Design panel, open the Optical Lens.
  2. If you want, modify the parameters related to the facets in the Style and Ungrouped Elements definitions.
    The Style and Ungrouped Elements parameters corresponds to those who will be created and applied when you create the Excel file.
  3. Open the main node of the Optical Lens.
  4. In the main node definition, from the Excel file drop-down list, click Create Excel.

    An Excel file is created based on the input parameters set in the Style and Ungrouped Elements definition.

    The Excel file opens automatically upon creation.

  5. If you had already created the Excel File (automatic opening of the file already done), from the Excel file drop-down list, click Open file.
    Important: For Speos to know that you modified the Excel file, you must open the file from here. Otherwise, if you open the file outside of the interface, Speos cannot know if you modified it.
  6. Modify the Excel file as you want.

    In the Excel file, each sheet correspond to a parameter and each cell in a sheet corresponds to one specific facet of the Optical Lens.

    Tip: To find the match between a cell in the Excel file and its facet in the 3D view, you can hover over the feature. This will give you the cell coordinates.

  7. Save the Excel file.
  8. In Speos, click Compute to generate the Optical Lens and take into account the changes.
The Optical Lens is generated and built in the 3D view.