Dear Jihee, This appears to be a different problem. You were apparently able to access the spreadsheet file, but the R Commander didn't find a suitable worksheet in it.
Try downloading and reading the file at <https://socialsciences.mcmaster.ca/jfox/Courses/R/ICPSR/Prestige.xlsx>. If that works, send me privately (i.e., directly) your Excel spreadsheet file and I'll take a look at it. Best, John > On Jan 16, 2019, at 9:49 PM, 우지희 <wjh1...@ht.co.kr> wrote: > > Dear John, > > now i can use english thank you very much!! > > um.. but nothing's changed... with that {r} message at R Markdown. > > There's no dataset. > > i tried both .xls and .xlsx . > > > Jihee > > > > <fbe6254214d94e74b98569b08bb3bf07.png> > > > > From: "Fox, John" <j...@mcmaster.ca> > Sent: Thursday, January 17, 2019 10:59:44 AM > To:"우지희" <wjh1...@ht.co.kr> > Cc:"<r-help@r-project.org>" <r-help@R-project.org></r-help@r-project.org> > Subject:Re: [R] importing data error question > > > Dear Jihee, > > Probably the easiest way to change the language to English temporarily in R > is to enter the command > > Sys.setenv(LANGUAGE="en") > > at the R command prompt prior to loading the Rcmdr package. > > I hope that this helps, > John > > > > On Jan 16, 2019, at 7:02 PM, 우지희 <wjh1...@ht.co.kr> wrote: > > > > Thanks for your help! > > > > I was having trouble with finding how to use english... > > > > Even though I try to use english language, I couldn't change language of R > > commander. (it is still korean) > > > > Sorry but.. do you know how to change language of "R commander"? I have no > > idea why it doesn't change. > > > > Best, > > Jihee > > > > From: "Fox, John" <j...@mcmaster.ca> > > Sent: Thursday, January 17, 2019 1:59:03 AM > > To:"우지희" <wjh1...@ht.co.kr> > > Cc:"r-help@r-project.org" <r-help@r-project.org> > > Subject:Re: [R] importing data error question > > > > > > Dear jihee, > > > > I've looked into this problem further, using my Mac where it's easier to > > temporarily change languages and character sets than on Windows, and I > > discovered the following: > > > > I was able to duplicate your problem with importing Excel files when > > working in Korean. There's a similar problem with the import SAS b7dat > > files but not with the other file-import dialogs. > > > > I observed a similar problem when working in Chinese (LANG="zh") but not in > > simplified Chinese (zh_CN) or Japanese (ja), so the problem isn't simply > > with non-Latin character sets. There is no problem in English, Spanish > > (es), or French (fr), and I didn't check the other languages into which the > > Rcmdr is translated. > > > > I think that the problem originates in the Korean and Chinese translation > > files and I'll contact the translators to see whether they can fix it. > > > > Thank you for reporting this issue. > > > > John > > > > > On Jan 14, 2019, at 11:36 PM, Fox, John <j...@mcmaster.ca> wrote: > > > > > > Dear jihee, > > > > > >> On Jan 14, 2019, at 9:00 PM, 우지희 <wjh1...@ht.co.kr> wrote: > > >> > > >> You said previously that you were using a Mac, so I'm surprised that you > > >> now say that you're using Windows. I don't have a Windows 7 system, but > > >> I can confirm that importing from Excel files works perfectly fine under > > >> Windows 10, as I just verified, and I'd be surprised if the Windows > > >> version matters. > > >> > > >> --> no, I never said i was using a Mac. > > > > > > Sorry, I guess I got that from the error message you originally reported, > > > which was "Error in structure(.External(.C_dotTclObjv, objv), class = > > > "tclObj") : [tcl] bad Macintosh file type "“*”"." I've never seen that > > > error and it seems peculiar that it would occur on a Windows system. > > > > > >> > > >> You still haven't reported the versions of R, the Rcmdr package, and the > > >> other packages that you're using. The easiest way to do this is to show > > >> the output of the sessionInfo() command. > > >> > > >> --> sessionInfo() > > >> R version 3.5.2 (2018-12-20) > > >> Platform: x86_64-w64-mingw32/x64 (64-bit) > > >> Running under: Windows 7 x64 (build 7601) Service Pack 1 > > >> > > >> Matrix products: default > > >> > > >> locale: > > >> [1] LC_COLLATE=Korean_Korea.949 LC_CTYPE=Korean_Korea.949 > > >> [3] LC_MONETARY=Korean_Korea.949 LC_NUMERIC=C > > >> [5] LC_TIME=Korean_Korea.949 > > >> > > >> attached base packages: > > >> [1] tcltk splines stats graphics grDevices utils datasets methods > > >> [9] base > > >> > > >> other attached packages: > > >> [1] RcmdrPlugin.SensoMineR_1.11-01 RcmdrPlugin.FactoMineR_1.6-0 > > >> [3] Rcmdr_2.5-1 effects_4.1-0 > > >> [5] RcmdrMisc_2.5-1 sandwich_2.5-0 > > >> [7] car_3.0-2 carData_3.0-2 > > >> [9] SensoMineR_1.23 FactoMineR_1.41 > > >> > > >> loaded via a namespace (and not attached): > > >> [1] gtools_3.8.1 Formula_1.2-3 latticeExtra_0.6-28 > > >> [4] cellranger_1.1.0 pillar_1.3.1 backports_1.1.3 > > >> [7] lattice_0.20-38 digest_0.6.18 RColorBrewer_1.1-2 > > >> [10] checkmate_1.8.5 minqa_1.2.4 colorspace_1.3-2 > > >> [13] survey_3.35 htmltools_0.3.6 Matrix_1.2-15 > > >> [16] plyr_1.8.4 pkgconfig_2.0.2 haven_2.0.0 > > >> [19] scales_1.0.0 openxlsx_4.1.0 rio_0.5.16 > > >> [22] lme4_1.1-19 htmlTable_1.13.1 tibble_1.4.2 > > >> [25] relimp_1.0-5 ggplot2_3.1.0 nnet_7.3-12 > > >> [28] lazyeval_0.2.1 survival_2.43-3 magrittr_1.5 > > >> [31] crayon_1.3.4 readxl_1.2.0 nlme_3.1-137 > > >> [34] MASS_7.3-51.1 forcats_0.3.0 foreign_0.8-71 > > >> [37] class_7.3-14 tools_3.5.2 data.table_1.11.8 > > >> [40] hms_0.4.2 tcltk2_1.2-11 stringr_1.3.1 > > >> [43] munsell_0.5.0 cluster_2.0.7-1 zip_1.0.0 > > >> [46] flashClust_1.01-2 compiler_3.5.2 e1071_1.7-0 > > >> [49] rlang_0.3.1 grid_3.5.2 nloptr_1.2.1 > > >> [52] rstudioapi_0.9.0 htmlwidgets_1.3 leaps_3.0 > > >> [55] base64enc_0.1-3 gtable_0.2.0 abind_1.4-5 > > >> [58] curl_3.2 reshape2_1.4.3 AlgDesign_1.1-7.3 > > >> [61] gridExtra_2.3 zoo_1.8-4 knitr_1.21 > > >> [64] nortest_1.0-4 Hmisc_4.1-1 KernSmooth_2.23-15 > > >> [67] stringi_1.2.4 Rcpp_1.0.0 rpart_4.1-13 > > >> [70] acepack_1.4.1 scatterplot3d_0.3-41 xfun_0.4 > > >> > > >> This was the status that I tried to import Excel data. > > > > > > These packages seem up-to-date. > > > > > >> > > >> Also, have you tried importing an Excel file in the Rcmdr *without* the > > >> two plug-in packages loaded, as I suggested in my original response? > > >> > > >> --> I tried without plug-in packages, but It didn't work. > > > > > > OK, so you tried the setup that works for me and, I assume from the lack > > > of similar error reports, for others. > > > > > >> > > >> It occurs to me that the problem may be produced by using the Rcmdr > > >> under R with a non-Latin set, but if that were the case I would have > > >> expected the problem to have surfaced earlier. Did you try reading > > >> another kind of file, such as a plain-text data file? > > >> > > >> --> I don't know what is plain-text data file..... > > > > > > A plain-text data file could, e.g., be created from an Excel file by > > > exporting a worksheet as a .csv (comma-separated-values) file; you could > > > read this into the Rcmdr via Data > Import data > from text file, > > > specifying the field separator as commas. > > > > > >> > > >> i'll try R with English. > > > > > > I'm curious to see what happens. > > > > > > Best, > > > John > > > > > >> > > >> From: "Fox, John" <j...@mcmaster.ca> > > >> > > >> Sent: Monday, January 14, 2019 11:15:36 PM > > >> > > >> To:"우지희" <wjh1...@ht.co.kr> > > >> > > >> Cc:"<r-help@r-project.org>" > > >> <r-help@R-project.org></r-help@r-project.org> > > >> > > >> Subject:Re: [R] importing data error question > > >> > > >> Dear jihee, > > >> > > >>> On Jan 13, 2019, at 9:28 PM, 우지희 <wjh1...@ht.co.kr> wrote: > > >>> > > >>> > > >>> > > >>> From: "우지희" <wjh1...@ht.co.kr> > > >>> Sent: Monday, January 14, 2019 9:40:26 AM > > >>> To:"Fox, John" <j...@mcmaster.ca> > > >>> Subject:Re: [R] importing data error question > > >>> > > >>> > > >>> Thanks for your replies. > > >>> > > >>> I'm using windows 7, I loaded FactoMineR, > > >> > > >> You said previously that you were using a Mac, so I'm surprised that you > > >> now say that you're using Windows. I don't have a Windows 7 system, but > > >> I can confirm that importing from Excel files works perfectly fine under > > >> Windows 10, as I just verified, and I'd be surprised if the Windows > > >> version matters. > > >> > > >>> SensoMineR and then Rcmdr. (Downloaded FacroMineR, SensoMineR, Rcmdr, > > >>> Rcmdrplugin.FactomineR, Rcmdrplugin.SensomineR and other required > > >>> packages that downloaded automatically) > > >>> This problem occurred when I select Data > Import data > From Excel > > >>> file. > > >>> I checked FactoMineR and SensoMineR packages are loaded and using.. > > >> > > >> You still haven't reported the versions of R, the Rcmdr package, and the > > >> other packages that you're using. The easiest way to do this is to show > > >> the output of the sessionInfo() command. > > >> > > >> Also, have you tried importing an Excel file in the Rcmdr *without* the > > >> two plug-in packages loaded, as I suggested in my original response? > > >> > > >> It occurs to me that the problem may be produced by using the Rcmdr > > >> under R with a non-Latin set, but if that were the case I would have > > >> expected the problem to have surfaced earlier. Did you try reading > > >> another kind of file, such as a plain-text data file? > > >> > > >> Best, > > >> John > > >> > > >>> > > >>> > > >>> > > >>> From: "Fox, John" <j...@mcmaster.ca> > > >>> Sent: Friday, January 11, 2019 10:48:38 PM > > >>> To:"PIKAL Petr" <petr.pi...@precheza.cz> > > >>> Cc:"우지희" <wjh1...@ht.co.kr>; "r-help@R-project.org" > > >>> <r-help@r-project.org> > > >>> Subject:Re: [R] importing data error question > > >>> > > >>> > > >>> Dear Petr and jihee, > > >>> > > >>> The Rcmdr can import Excel files, and as I just verified, it can do so > > >>> on a Mac listing files of all types (*) in the open-file dialog box > > >>> (which is the default). > > >>> > > >>> So, as Petr suggests, more information is required to help you, > > >>> including the versions of macOS, R, and all packages you have loaded. > > >>> In particular, does the problem occur when you try to read the Excel > > >>> file *without* FactoMineR and SensoMineR loaded? Also, when the does > > >>> problem occur -- immediately when you select Data > Import data > From > > >>> Excel file, or at some other point? > > >>> > > >>> Best, > > >>> John > > >>> > > >>> ------------------------------------------------- > > >>> John Fox, Professor Emeritus > > >>> McMaster University > > >>> Hamilton, Ontario, Canada > > >>> Web: http::/socserv.mcmaster.ca/jfox > > >>> > > >>>> On Jan 11, 2019, at 5:07 AM, PIKAL Petr <petr.pi...@precheza.cz> wrote: > > >>>> > > >>>> Hi > > >>>> > > >>>> I do not use Rcmdr but from documentation it seems to me that it does > > >>>> not have much to do with importing data from Excel. > > >>>> > > >>>> So without some additional info from your side (at least used > > >>>> commands) you hardly get any reasonable answer. > > >>>> > > >>>> Cheers > > >>>> Petr > > >>>> > > >>>>> -----Original Message----- > > >>>>> From: R-help <r-help-boun...@r-project.org> On Behalf Of ??? > > >>>>> Sent: Friday, January 11, 2019 9:14 AM > > >>>>> To: r-help@R-project.org > > >>>>> Subject: [R] importing data error question > > >>>>> > > >>>>> Hi I'm jihee and I have a question about error... > > >>>>> > > >>>>> I'm using R 3.5.2 and tried to use Rcmdr package. > > >>>>> > > >>>>> and using FactoMineR and SensoMineR to analyze sensory data through > > >>>>> PCA > > >>>>> > > >>>>> but i can't import excel data with Rcmdr. > > >>>>> > > >>>>> it has this messege : > > >>>>> > > >>>>> Error in structure(.External(.C_dotTclObjv, objv), class = "tclObj") : > > >>>>> [tcl] bad Macintosh file type "“*”" > > >>>>> > > >>>>> what is wrong with my R??? T_T > > >>>>> > > >>>>> Thanks for your help. > > >>>>> > > >>>>> jihee. > > >>>>> [[alternative HTML version deleted]] > > >>>>> > > >>>>> ______________________________________________ > > >>>>> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > > >>>>> https://stat.ethz.ch/mailman/listinfo/r-help > > >>>>> PLEASE do read the posting guide > > >>>>> http://www.R-project.org/posting-guide.html > > >>>>> and provide commented, minimal, self-contained, reproducible code. > > >>>> Osobní údaje: Informace o zpracování a ochraně osobních údajů > > >>>> obchodních partnerů PRECHEZA a.s. jsou zveřejněny na: > > >>>> https://www.precheza.cz/zasady-ochrany-osobnich-udaju/ | Information > > >>>> about processing and protection of business partner’s personal data > > >>>> are available on website: > > >>>> https://www.precheza.cz/en/personal-data-protection-principles/ > > >>>> Důvěrnost: Tento e-mail a jakékoliv k němu připojené dokumenty jsou > > >>>> důvěrné a podléhají tomuto právně závaznému prohláąení o vyloučení > > >>>> odpovědnosti: https://www.precheza.cz/01-dovetek/ | This email and any > > >>>> documents attached to it may be confidential and are subject to the > > >>>> legally binding disclaimer: https://www.precheza.cz/en/01-disclaimer/ > > >>>> > > >>>> ______________________________________________ > > >>>> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > > >>>> https://stat.ethz.ch/mailman/listinfo/r-help > > >>>> PLEASE do read the posting guide > > >>>> http://www.R-project.org/posting-guide.html > > >>>> and provide commented, minimal, self-contained, reproducible code. > > >>> > > >>> > > >>> > > >>> > > >>> 우지희 연구원 / 초콜릿개발팀 > > >>> e-mailwjh1...@ht.co.krDirMobile > > >>> 홈페이지www.ht.co.kr페이스북www.facebook.com/haitaico > > >>> Address서울특별시 용산구 한강대로 72길 3 (남영동) 해태제과식품(주) 04352 > > >>> 상기 메일은 지정된 수신인만을 위한 것이며, 부정경쟁방지 및 영업비밀보호에 관한 법률을 포함하여 관련 법령에 따라 보호의 대상이 > > >>> 되는 영업비밀, 산업기술 등을 포함하고 있을 수 있습니다. 본 문서에 포함된 정보의 전부 또는 일부를 무단으로 제3자에게 공개, > > >>> 배포, 복사 또는 사용하는 것은 엄격히 금지됩니다. 본 메일이 잘못 전송된 경우, 발신인에게 알려주시고 본 메일을 즉시 삭제하여 > > >>> 주시기 바랍니다. > > >>> The above message is intended solely for the named addressee and may > > >>> contain trade secret. Industrial technology or privileged and > > >>> confidential information otherwise protected under applicable law > > >>> including the Unfair Competition Prevention and Trade Secret Protection > > >>> Act. Any unauthorized dissemination, distribution, copying or use of > > >>> the information contained in this communication is strictly prohibited. > > >>> If you have received this communication in error, please notify the > > >>> sender by email and delete this communication immediately > > >>> > > >>> > > >>> > > >>> > > >>> 우지희 연구원 / 초콜릿개발팀 > > >>> e-mailwjh1...@ht.co.krDirMobile > > >>> 홈페이지www.ht.co.kr페이스북www.facebook.com/haitaico > > >>> Address서울특별시 용산구 한강대로 72길 3 (남영동) 해태제과식품(주) 04352 > > >>> 상기 메일은 지정된 수신인만을 위한 것이며, 부정경쟁방지 및 영업비밀보호에 관한 법률을 포함하여 관련 법령에 따라 보호의 대상이 > > >>> 되는 영업비밀, 산업기술 등을 포함하고 있을 수 있습니다. 본 문서에 포함된 정보의 전부 또는 일부를 무단으로 제3자에게 공개, > > >>> 배포, 복사 또는 사용하는 것은 엄격히 금지됩니다. 본 메일이 잘못 전송된 경우, 발신인에게 알려주시고 본 메일을 즉시 삭제하여 > > >>> 주시기 바랍니다. > > >>> The above message is intended solely for the named addressee and may > > >>> contain trade secret. Industrial technology or privileged and > > >>> confidential information otherwise protected under applicable law > > >>> including the Unfair Competition Prevention and Trade Secret Protection > > >>> Act. Any unauthorized dissemination, distribution, copying or use of > > >>> the information contained in this communication is strictly prohibited. > > >>> If you have received this communication in error, please notify the > > >>> sender by email and delete this communication immediately > > >> [[alternative HTML version deleted]] > > >> > > >> ______________________________________________ > > >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > > >> https://stat.ethz.ch/mailman/listinfo/r-help > > >> PLEASE do read the posting guide > > >> http://www.R-project.org/posting-guide.html > > >> and provide commented, minimal, self-contained, reproducible code. > > > > > > ______________________________________________ > > > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > > > https://stat.ethz.ch/mailman/listinfo/r-help > > > PLEASE do read the posting guide > > > http://www.R-project.org/posting-guide.html > > > and provide commented, minimal, self-contained, reproducible code. > > > > > > > > > > > > 우지희 연구원 / 초콜릿개발팀 > > e-mail wjh1...@ht.co.kr Dir Mobile > > 홈페이지 www.ht.co.kr 페이스북 www.facebook.com/haitaico > > Address 서울특별시 용산구 한강대로 72길 3 (남영동) 해태제과식품(주) 04352 > > 상기 메일은 지정된 수신인만을 위한 것이며, 부정경쟁방지 및 영업비밀보호에 관한 법률을 포함하여 관련 법령에 따라 보호의 대상이 되는 > > 영업비밀, 산업기술 등을 포함하고 있을 수 있습니다. 본 문서에 포함된 정보의 전부 또는 일부를 무단으로 제3자에게 공개, 배포, 복사 > > 또는 사용하는 것은 엄격히 금지됩니다. 본 메일이 잘못 전송된 경우, 발신인에게 알려주시고 본 메일을 즉시 삭제하여 주시기 바랍니다. > > The above message is intended solely for the named addressee and may > > contain trade secret. Industrial technology or privileged and confidential > > information otherwise protected under applicable law including the Unfair > > Competition Prevention and Trade Secret Protection Act. Any unauthorized > > dissemination, distribution, copying or use of the information contained in > > this communication is strictly prohibited. If you have received this > > communication in error, please notify the sender by email and delete this > > communication immediately > > > > > > 우지희 연구원 / 초콜릿개발팀 > e-mail wjh1...@ht.co.kr Dir Mobile > 홈페이지 www.ht.co.kr 페이스북 www.facebook.com/haitaico > Address 서울특별시 용산구 한강대로 72길 3 (남영동) 해태제과식품(주) 04352 > 상기 메일은 지정된 수신인만을 위한 것이며, 부정경쟁방지 및 영업비밀보호에 관한 법률을 포함하여 관련 법령에 따라 보호의 대상이 되는 > 영업비밀, 산업기술 등을 포함하고 있을 수 있습니다. 본 문서에 포함된 정보의 전부 또는 일부를 무단으로 제3자에게 공개, 배포, 복사 > 또는 사용하는 것은 엄격히 금지됩니다. 본 메일이 잘못 전송된 경우, 발신인에게 알려주시고 본 메일을 즉시 삭제하여 주시기 바랍니다. > The above message is intended solely for the named addressee and may > contain trade secret. Industrial technology or privileged and confidential > information otherwise protected under applicable law including the Unfair > Competition Prevention and Trade Secret Protection Act. Any unauthorized > dissemination, distribution, copying or use of the information contained in > this communication is strictly prohibited. If you have received this > communication in error, please notify the sender by email and delete this > communication immediately ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
