Support Article
Export to excel functionalityusing MSOGenerateExcelFile activity
SA-41142
Summary
While exporting data to excel all data (including number, percentage values) are retrieved as text in the excel sheet.
Error Messages
The number in the cell is formatted as text or preceeded by an apostrophe
Steps to Reproduce
Export data to excel.
Root Cause
The activity MSOGenerateExcelFile does not support the functionality that they are attempting to achieve.
The issue is that the values are stored as text on the clipboard, which causes Excel to override any formatting specified in the template.
Resolution
Use macro function or use viewexceldata Out-of-the-box (OOTB) activity with extreme customization to achieve the requirement.
Published October 17, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.