Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Title: Windows "List separator" settings may cause CSV Return Value of Excel (.xlsx) contents not to separate columns properly with commas.
Q. I am using CSV as Return Value of a plugin and reading data from an Excel file (.xlsx). However the CSV results put all columns in one column and do not separate them correctly. How do I fix it?
A. One likely cause is the settings of your Windows. Windows has a setting called "List separator". It is hidden deep at the bottom layer of Region settings (for some Microsoft reason).
Please follow the steps below. It should fix it.
Image RemovedWindows
Go to
Settings => Region => Related Settings (Additional date, time, and regional settings)
You will now arrive at
Control Panel\Clock and Region
Click Change date, time, or number formats
Click Additional settings...
List separator to comma as in the second popup window.
Image RemovedImage Added
Image RemovedImage Added
Other links which may help you -
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|