Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Hi
I am facing an issue with "Convert Excel to CSV". In Excel there is data. However, when the excel is inputted to this smart service to convert it to corresponding .CSV, it gets it converted into a CSV but the CSV is empty.
Any help on why is this happening? It was working fine till 7th June (I checked the folder where both the .xslx and corresponding .csv is getting stored). However it is not working now. Just an FYI, the version of my environment is 20.1 and we the upgrade has happened more than month ago (so I don't think the upgrade has anything to do with this).
Can I get a suggestion of why the smart service is behaving like this? Thanks in advance!!
In Convert Excel to CSV Node, please check the value for "Number Of Columns To Read In Row" in Node Inputs, If that is 0, you will receive an empty CSV. Try giving some value or leaving it to blank instead of 0.
I have faced similar issue last week and when I updated this, the node worked fine.
Thanx Hema, this helped !!