I am using excel to json converter in unity from GitHub - Benzino/ExcelToJsonConverter: A Unity plugin to convert Excel files to Json and got an error when converting from excel containing languages like French, German, Spanish, … to json, a square box character will appear in json. How to fix this error? Thanks!
sounds like it doesn’t support utf8 / those special characters in some step of the code…?
could try adding debug.logs to see where it breaks (or maybe parsing from excel already fails not the saving or outputting?)
yes, maybe. when i run debug on unity, i saw error of excelReader with its cellsValue pairs. Note that excel file is not corrupted, json file can also edit squares into special characters of that language but the problem is when converting to json it has character error
then could try converting same string manually in code (not from excel importer),
does it break also?
and where are you viewing the json?
if you can attach sample json, could check that also.
1 Like
it’s no problem with string, but json files can be edited directly to be correct to the original, but with many lines this is very time consuming. Do you have any solution?
If you’re just using it for localization purposes, you might be better off exporting as a CSV and using any of the numerous CSV importers out there
do those boxes contain enough info, so that you can use replace string?
(as in: if you view the json file with hex viewer, do the boxes have unique characters, so that you can then replace with correct letter)
but this tool only support for .xls…
a
example for you to understand
Yes, you will use a different, more well supported tool instead. XLS is a finicky format while CSV is, by design, meant to be more interoperable.
1 Like
do you have another tool with csv? suggest for me, thanks!!