Type error for objectArray

[KarmaPoliceT2]

Copy pasting this into excel scripts throws an error "Office Scripts cannot infer the data type of this variable. Please declare a type for the variable." for the line "let objectArray = []"

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 85ab721c-371b-8901-abdc-adbbcbd2c81b
• Version Independent ID: 5cd477ae-cce5-a942-4297-6f23aebd3267
• Content: Output Excel data as JSON - Office Scripts
• Content Source: docs/resources/samples/get-table-data.md
• Product: excel
• Technology: scripts
• GitHub Login: @o365devx
• Microsoft Alias: o365devx

[AlexJerabek]

Thanks for reporting this @KarmaPoliceT2. I'll investigate this and fix the sample soon.

[AlexJerabek]

Hi @KarmaPoliceT2,

I'll post a PR to address this soon. The issue relates to the recent change of Office Scripts no longer supporting the any type. You can read more about that here. The fix is to give an explicit type to the table row array and values passed to that array.