Forum Discussion

rashmi's avatar
rashmi
New Contributor III
3 years ago

Dynamically parse the excel without having sheet index or sheet name

Hi, Anyone aware of how do we parse the excel with multisheet without even knowing sheet index / sheet name with having certain number of records in each sheet. I am having requirement to remove ...
ptaylor's avatar
ptaylor
Employee
3 years ago
Copy Link

Mohit, this is just an odd bug in the Designer’s viewer for JSON preview data. If you actually save the output of the JSON Formatter to a file using a File Writer, you’ll see that the empty string is a pair of double quotes as you expect.