PI: API error: Too many fields defined.
Question ID: 107739

API error: Too many fields defined.
Microsoft JET Database Engine
Void ExecuteCommandTextErrorHandling(System.Data.OleDb.OleDbHResult)

Marked as spam
Posted by (Questions: 22, Answers: 6)
Asked on July 20, 2017 2:32 pm
Answers (1)
Private answer

There might be corrupt data in excel spread sheet. I have reproduce new sheet issue went away in the past.

Microsoft Excel inject extra data (including formula) which can be put into Excel that might affect the test run. To ensure the extra formatting is not used I had recommend exporting sheet to CSV file then closing Excel and re opening the CSV file with Excel. This would clean out most of the isssues.

I have found a tool that will clean out the Excel document called [CleanXLsx](https://github.com/TomMargrave/CleanXLSX) which is a VBScript that will solve this issue and other issues.

Marked as spam
Posted by (Questions: 2, Answers: 98)
Answered on July 20, 2017 2:33 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top