to ms excel
Does anyone have or can anyone write an simple script that list all articlenumbers+name+price in a list to open in Excel.
I can't find "Set Delimited" :)
In Excel ->
more applause for the dev's
What is the encoding (or where to set it up)? When importing the CSV file into excell, the encoding is unreadable. Eastern characters are wrongly encoded.
Script works default in UTF-8 so I think you should use UTF-8.
Well, on the webpage everything works well. But importing the exported CSV file into Excell makes it unreadable because of EE characters. I have tried to change any available encoding. Results are always bad. Under UTF-8 or any other encoding the EE characters are wrong.
1.Save the exported file as a csv on the local disc
Didn't help. I tried all possible encodings for the File_Origin (btw. there is no 65001 UTF there available). And I also tried to use any excel available encoding. Still the texts in exported file are wrong.
send me a part of this csv file
upps, i didn't see the link to the file.
Well. As I wrote above, I work with iMAC and there is no "5.In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier) " available. Also, I have found in other forums a hint how to try it. But it seems to be a little complicated:
Anyway, after some ex/imports I have found another problem in "Price". If the price is >12, the number is exported as datum (e.g. 12.25 is exported as dec.25). How to correct this?