similar to: Converting character to numeric using the package "XLConnect"

> On Aug 30, 2017, at 12:24 PM, Nelly Reduan <nell.redu at hotmail.fr> wrote: > > Hello, > > From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my

The Excel file can be found from this link: https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh [https://r1.res.office365.com/owa/prem/images/dc-xlsx_40.png]<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh> File.xlsx<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh> Partag? via OneDrive Thanks very much for your help. Nell ________________________________ De : David Winsemius

Thanks very much for your answer. I?m trying the function ?strtoi? but it fails to convert character to numeric after the command "set[index] <- strtoi(set[index])". > strtoi(set[index]) ## This works: all values are numeric !!! [1] 1 2 3 4 2 8 9 7 > set[index] <- strtoi(set[index]) > print(set[10,1]) ## Problem: must be numeric !!!! [1] "1" Thanks

Hi Nelly, Are you trying to convert hexadecimal to decimal? nrdf Setting Value 1 Parameters a 2 Parameters b 3 Parameters c 4 Parameters d 5 Parameters e 6 Parameters 2 7 Parameters 8 8 Parameters 9 9 Parameters 7 10 1 a 11 2 b 12 3 c 13 4 d strtoi(nrdf$Value,16) [1] 10 11 12 13 14 2 8 9

Nelly Reduan a partag? un fichier OneDrive avec vous. Pour l?afficher, cliquez sur le lien ci-dessous. <https://1drv.ms/u/s!Apkg2VlgfYyDgRAeVIM0nEajx0Fb> [https://r1.res.office365.com/owa/prem/images/dc-png_20.png]<https://1drv.ms/u/s!Apkg2VlgfYyDgRAeVIM0nEajx0Fb> Screenshot 2017-11-12 18.49.43.png<https://1drv.ms/u/s!Apkg2VlgfYyDgRAeVIM0nEajx0Fb> Hello How can I perform

Thank you very much Rob for your answer. I have some difficulties to understand how to apply my agent-based model to each parameter combination generated by the LHS, in particular when parameters are defined by probability distributions. Indeed, I have multiple parameters in my model: parameters which are defined by a single value (like ?temperature", "pressure?) and parameters which are

>May 26, 2017; 11:41am Nelly Reduan Latin Hypercube Sampling when parameters are >defined according to specific probability distributions >Hello, > I would like to perform a sensitivity analysis using a Latin Hypercube Sampling (LHS). >Among the input parameters in the model, I have a parameter dispersal distance which is defined according to an exponential probability

Hi, Attached are two datasheet to be read. My raw data "130502temp.xlsx" contains numbers with ' symbols, and they can't be read as numbers. Even if I copy and paste as numbers to form a new file "130502temp_number1.xlsx", they could not be read smoothly. 1. How can I read the datasheet as numbers? 2. How can I treat the notation "-" as (1)

When using XLConnect's readWorksheet, instead of it correctly reading string and numeric columns, I receive NA's with the following message: " Error when trying to evaluate cell A2 - not implemented yet" I do not know what this means. Can anyone please assist? -- __________________________ *Barry E. King, Ph.D.* Chief Modeler Qualex Consulting Services, Inc.

Hi, I have two questions on the function "readNamedRegionFromFile" in XLConnect pacakge. 1. In the documentation, # multiregion xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/multiregion.xlsx", package = "XLConnect") # Load a single named region into a single data.frame. df

Hi experts, I want to read data from an excel data like this: for the fifth column, from first row until 140 but only 1,3,5,7,.....139 (only 70 values), How can I do it in R? thanks [[alternative HTML version deleted]]

I think you should take this conversation private or seek local statistical expertise. This is about strategies for analysis, not about programming in R. Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Wed, May 31, 2017 at

When I read a time hh:mm:ss from a excel sheet with gdata read.xls it is as expected. When I read the time with readWorksheet I get 1899-12-31 00:20:00 UTC. I would prefer XLConnect because it does not nee perl installed but the data coming with XLConnect is not usable.

Hi Download the xls file from this link http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls <http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls> I tried this --------------------------------------------------------------- library(XLConnect) url = "http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls" local.xls.file = tempfile() download.file(url,

Hola, Pensé que esto iba a ser trivial en R, pero me estoy encontrado muchos con mi problema en internet, y que las soluciones ofrecidas no terminan de funcionar. Estoy intentando leer un fichero .xls en ubuntu con los siguientes paquetes y nada: require(RODBC) conn = odbcConnectExcel("madrid.xls") # open a connection to the Excel file sqlTables(conn)$TABLE_NAME # show all sheets df =

Hi, I tried to read xlsx files by "XLConnect" packages, but the dates are one day earlier than it is supposed to be. I moved from California to Taiwan (Eastern Asia), and it worked well in California, but not in Taiwan. Even if I adjust my Mac time to California time zone, it gives the wrong dates. I don't know which part of the setting (in RStudio or in my Mac?) I should adjust.

Hi John, It could be due to this: https://support.microsoft.com/en-au/help/214330/differences-between-the-1900-and-the-1904-date-system-in-excel Jim On Sat, Sep 23, 2017 at 1:04 PM, John <miaojpm at gmail.com> wrote: > Hi, > > I tried to read xlsx files by "XLConnect" packages, but the dates are > one day earlier than it is supposed to be. I moved from California

> > > Hola chic en s, > > sigo intentando crear un archivo de Excel pero no hay manera. Sigo los pasos del documento de ayuda siguiente: > > http://altons.github.io/r/2015/02/13/quick-intro-to-xlconnect/#load > > los pasos que hago son: > > install.packages("XLConnect") > require(XLConnect) > wb <-

Hola amigos, buenos días Esto sigue avanzando. Estoy ahora tratando de establecer la conectividad de R con Excel y he seguido dos viídeos en YouTube de una profesora llamada Bebilda que se explica muy bien. Con ambos tengo el mismo problema así que planteo uno de ellos, éste es: https://youtu.be/_pSJQO_9I4k?list=PL7DA3FDA21A1A6310 Pero os lo explico brevemente: Cargo el paquete RODBC >

> On Sep 23, 2017, at 6:30 AM, Eric Berger <ericjberger at gmail.com> wrote: > > Jim, > I don't see how that link could be related to John's issue. Symptoms > related to your link involve discrepancies of four years whereas John is > seeing discrepancies of one day. > The MS Excel starting point was off by one day. R does not repeat that error. MS claims that