Is there any way to know the client machines language settings? specifically the List separator (Delimiter) selected. Because, in my project website (Developed using PHP, Javascript, Jquery) the client can export reports in csv format. At present we are creating this csv with "comma" as the delimiter. But for some of our clients , when they open this CSV the datas are showing in one column itself with comma separated.
I understood this is because the default List separator selected in their OS control panel configuration may be a different delimiter than comma. However, we don't want to tell to every client to change their OS configuration.. Is there any other solution for this? If i generate xls file instead of csv this same issue will come in future right???