RStudio Desktop : Import Excel Screen can't import data when use Japanese Language sheet name.

tminoda · March 19, 2020, 7:59am

Hi.
I'm facing issues which Import Excel screen can't import data when I use Japanese Language sheet name.
Please let me know how to resolve this issue.

[Current Situation]

I want to upload Excel file which contains Japanese sheet name and data using Import Excel Data screen in Environment tab.
I can see Japanese file name in "Sheet" and data was showen correctly Japanese text in this screen.
However, when I select Japanese sheet name then popup error message raising with garbled Japanese character.
Generated R codes in "Code Preview" is works fine.

[Environment]

Windows 10
RStudio Desktop (Version 1.1.456)
sessioninfo()

sessionInfo()
R version 3.6.2 (2019-12-12)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows >= 8 x64 (build 9200)
Matrix products: default
locale:
[1] LC_COLLATE=Japanese_Japan.932 LC_CTYPE=Japanese_Japan.932
[3] LC_MONETARY=Japanese_Japan.932 LC_NUMERIC=C
[5] LC_TIME=Japanese_Japan.932
attached base packages:
[1] stats graphics grDevices utils datasets methods base
loaded via a namespace (and not attached):
[1] compiler_3.6.2 tools_3.6.2 Rcpp_1.0.3 cellranger_1.1.0
[5] readxl_1.3.1

kevinushey · March 23, 2020, 6:05pm

Do you see this issue in RStudio v1.2 (the current release) or in the RStudio preview release?

tminoda · March 24, 2020, 1:26pm

Hi, @kevinushey.
Thank you for your reply.

OK. I will check v1.2 and release note.
If I have any questions then I will reply this topic.

Best regards.
Thank you.

TomasG · March 24, 2020, 4:21pm

I made a try importing an Excel file with japanese characters in the sheet names and got the same problem.
You could import the file using the sheet number in the code, like this:

library(readxl)
read_excel("C:/Your_path/japanese_test.xlsx", sheet = 2)

tminoda · March 25, 2020, 6:29am

Hi, @TomasG
Thank you for your reply.

Yes. I have already checked works fine for R code level.
But in this case, I would like to use UI screen for import Excel file because user is new to R and RStudio.

Could you please share your RStudio Desktop's version?
If you face same issues on same version which I'm using it then it might be resolve upgrade RStudio Desktop Version. (My version is RStudio Desktop (Version 1.1.456))

Best regards.
Thank you.

tminoda · March 25, 2020, 6:45am

Hi, @kevinushey
Thank you for your support.

I read v1.2 release note also Issues on Github.
It seems that these release note and Issues resembles to my issues.

[Release note]
https://rstudio.com/products/rstudio/release-notes/
-> #1910
[Github Isses]

github.com/rstudio/rstudio

non-ASCII paths mishandled in Import Dataset (base) dialog

opened 05:25PM - 04 Jan 18 UTC

closed 04:44AM - 10 Jan 18 UTC

kevinushey

bug reproducible

From https://support.rstudio.com/hc/en-us/community/posts/115004014074-Encoding-…problems-after-upgrade. Note that this only effects the `Import Dataset (base)` dialog; the dialog using `readr` works just fine. To reproduce: 1. Create a file called `鬼.csv` (or a similar pathname with non-ASCII characters), 2. Invoke the `Import Dataset (base)` dialog, and point it to the path of that file, 3. Press the Ok button to confirm the dialog, 4. Note the code generated uses a mis-encoded path -- `鬼` has been changed to `\xBC`. ![screen shot 2018-01-04 at 9 24 44 am](https://user-images.githubusercontent.com/1976582/34575911-1fd6422a-f131-11e7-9370-31eb7d3394b2.png)

Could you please let me know if you know these issues was fixed in latest version ?
If these issues was fixed and included latest version then I will start upgrade from 1.1.4 to 1.2 or higher.

Best regards.
Thank you.

TomasG · March 25, 2020, 11:51am

@tminoda my current RStudio Desktop version is 1.2.5033.
I also tried with sheet names using other special characters and got the same issue.

kevinushey · March 25, 2020, 4:25pm

To the best of my knowledge, this is fixed in the RStudio v1.3 preview release.

tminoda · March 26, 2020, 11:51am

Hi, @TomasG
Thank you for your confirmation.
I understand this version can't resolve my issue...
I will try to use v.1.3 .

Thank you for your support!

tminoda · March 26, 2020, 12:07pm

Hi, @kevinushey
Thank you for your reply.

Sure. I will try to upgrade my environment to v1.3.
If I have some questions I will update this ticket.

Best regards.
Thank you.

tminoda · March 31, 2020, 12:53am

Hi, @kevinushey
Thank you for your waiting.

I updated latest version (Version 1.3.929) to my laptop and try to attempt same import operation previously.
Unfortunately, I faced same issue. We can see Japanese sheet name but when I select Japanese select name in "Sheet" select box then same error happens again.

So could you please tell me what is next step if you have any idea?

Thank you for your help.
Best regards.
Thank you.

kevinushey · March 31, 2020, 5:09pm

Thanks for following up. Would you mind filing this as a bug report at https://github.com/rstudio/rstudio/issues?

tminoda · April 1, 2020, 10:13am

@kevinushey
Thank you for your reply.

I posted bug report at Github issues.

github.com/rstudio/rstudio

RStudio Desktop : Import Excel Screen can't import data when use Japanese Language sheet name.

opened 10:09AM - 01 Apr 20 UTC

closed 10:32AM - 19 Feb 21 UTC

tminoda

bug data import stale

I'm facing issues which Import Excel screen can't import data when I use Japanes…e Language sheet name. **[Current Situation]** - I want to upload Excel file which contains Japanese sheet name and data using Import Excel Data screen in Environment tab. - I can see Japanese file name in "Sheet" and data was shown correctly Japanese text in this screen. - However, when I select Japanese sheet name then popup error message raising with garbled Japanese character. - Generated R codes in "Code Preview" is works fine. - I updated latest version (Version 1.3.929) based on RStudio community advice, however, I faced same issue. I have already posted and discussed below RStudio Community before. https://community.rstudio.com/t/rstudio-desktop-import-excel-screen-cant-import-data-when-use-japanese-language-sheet-name/57089 Please consider fix this issue if possible. Best regards. Thank you.

If I have something missed out or misunderstanding then please let me know.

Best regards.
Thank you.

system · April 22, 2020, 10:13am

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.