Resolving "Input String Was Not in a Correct Format" Error When Adding a Table to an Excel Report

Issue: When attempting to add a Qlik native straight table to an Excel report in Mail & Deploy, you may encounter the error:

Input string was not in a correct format.

This issue occurs even though the table can be successfully added as an image, but it fails when added as a table object.

Solution:

To resolve this issue, follow these steps:

1. Reset Styling for the Table:

• In Qlik Sense or QlikView, locate the straight table that you want to add to the report.
• Reset any custom styling applied to the table. This includes removing any non-default formatting for:
  • Font sizes
  • Colors
  • Column width adjustments
    

• Save the changes to the table.
  

2. Reattempt Adding the Table:

• Go back to Mail & Deploy and try adding the straight table to the Excel report again as a table object.
• Test if the error persists after the styling reset.

3. Verify Data Consistency:

• Ensure that all values in the straight table can be parsed correctly (e.g., no invalid or mismatched data types).
• Check for special characters or improperly formatted data in calculated columns or expressions.

4. Update to the Latest Version:

• Ensure that you are running the latest version of Mail & Deploy, as updates often include fixes for known issues.
  

---

Additional Tips:

• If the issue persists, try exporting the straight table to Excel directly from Qlik to verify if the error is related to the data itself.
• As a temporary workaround, if resetting styling doesn't work, continue using the table as an image until a permanent fix is implemented.

---

By following these steps, you should be able to resolve the "Input string was not in a correct format" error and successfully add the straight table to your Excel report as a table object.

• Related Articles

• Resolving EXPRESSION FAILED: DECLARATION EXPECTED Error in Qlik Sense with Mail & Deploy

  You may encounter the following error when working with expressions in Qlik Sense, especially when using Mail & Deploy: EXPRESSION FAILED: DECLARATION EXPECTED This error typically occurs when there are no apparent syntax errors in the expression ...

• Resolving EXECUTION EXCEPTION: THE CANCELLATIONTOKENSOURCE HAS BEEN DISPOSED Error in Qlik Sense with Mail & Deploy

  You may encounter the following error message when using Mail & Deploy with Qlik Sense: EXECUTION EXCEPTION: THE CANCELLATIONTOKENSOURCE HAS BEEN DISPOSED This error is typically caused by misconfigured virtual proxies in the Qlik Management Console ...

• What to do if the report's Tables don't have the font as in the Qlik App?

  FIRST CREATED ON 17 Feb 2025 I AUTHOR Emma Camacho If the Report's Table Element does not have the font used in the Qlik Sense App and the Default Settings in Cell Settings is set to Keep Original. Issue The Qlik Sense App has the font Source Sans ...

• What should I do if The window of the Microsoft Excel Workbook could not be determined appears when using the Designer?

  FIRST CREATED ON 25 Jun 2024 I AUTHOR Emma Camacho If you encounter an issue where the window of the Microsoft Excel Workbook cannot be determined in Mail & Deploy, it can prevent proper file interactions. Here’s a brief guide to help you ...

• What to do if getting the error The remote server returned an error: (403) Forbidden?

  FIRST CREATED ON 19 Feb 2024 I AUTHOR Emma Camacho When rebuilding the cache of a Datasource, generating a Report or running a task the following error will appear if M&D doesn't have permission to access the Qlik Sense App. Issue Der Remoteserver ...