Dear jihee, > On Jan 14, 2019, at 9:00 PM, 우지희 <[email protected]> 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" <[email protected]> > > Sent: Monday, January 14, 2019 11:15:36 PM > > To:"우지희" <[email protected]> > > Cc:"<[email protected]>" <[email protected]></[email protected]> > > Subject:Re: [R] importing data error question > > Dear jihee, > >> On Jan 13, 2019, at 9:28 PM, 우지희 <[email protected]> wrote: >> >> >> >> From: "우지희" <[email protected]> >> Sent: Monday, January 14, 2019 9:40:26 AM >> To:"Fox, John" <[email protected]> >> 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" <[email protected]> >> Sent: Friday, January 11, 2019 10:48:38 PM >> To:"PIKAL Petr" <[email protected]> >> Cc:"우지희" <[email protected]>; "[email protected]" <[email protected]> >> 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 <[email protected]> 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 <[email protected]> On Behalf Of ??? >>>> Sent: Friday, January 11, 2019 9:14 AM >>>> To: [email protected] >>>> 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]] >>>> >>>> ______________________________________________ >>>> [email protected] 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/ >>> >>> ______________________________________________ >>> [email protected] 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. >> >> >> >> >> 우지희 연구원 / 초콜릿개발팀 >> [email protected] >> 홈페이지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 >> >> >> >> >> 우지희 연구원 / 초콜릿개발팀 >> [email protected] >> 홈페이지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]] > > ______________________________________________ > [email protected] 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. ______________________________________________ [email protected] 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.
