Convert to XLSX command - setting outfields eliminate shape and objectid

Carmen Durham

April 16, 2025 20:24

Hi all,

I have a custom command set for some parcels that will appear as an option for only parcels results. This is set on the “feature actions” menu for a “sublayer extension” within the map's “layer extensions”

It is titled “Export to XLSX for Mailout” . The intent is to export only fields needed for mailing to parcel owners to an excel spreadsheet.

the custom command set is this:

[

    {

        "name": "results.convert-to-xlsx",

        "arguments": {

            "useFormattedValues": false,

            "outFields": [

                "PIN",

                "OWNAM1",

                "STREET",

                "CITY",

                "STATE",

                "ZIP5"

            ],

            "includeHeaderRow": true

        }

    },

    "system.download-file"

]

 

The fields are limited to the fields shown above in the export but the ObjectID and the geometry fields still appear in the .xlsx export. see image below:

What can be done so that objectid and geometry are not exported? I tried a few other arguments but no luck.

Thanks,

Carmen

1

• 

  Brandon Turner

  May 05, 2025 22:10

  To export without the geometry field, you can setthe geometryFormat argument to “NONE”.

  "geometryFormat":"NONE"

  I do not have advice on removing the OID field unfortunately.

  1
• 

  Carmen Durham

  May 09, 2025 17:09

  Thank you Brandon, this worked for me.  I can live with the ObjectID in the spreadsheet because people will understand it as some sort of ID.  Geometry field would confuse people.

  0

Please sign in to leave a comment.