search for: excelfile

Dear UseRs, I have an update ready for the xlsReadWrite package. It runs my unit tests just fine but there are quite a lot of changes and it would be good if some other people could try it out before it will be submited to CRAN. I won't have more time this week, but I hope to publish xlsReadWrite at the end of next week and I will incorporate eventual bugreports and/or (minor) suggestions

Hi everybody, Question: why are my dataframe and numeric variables a character? I read an excel file via readxl but my dataframe is a character, and numeric variables, eg "yi", are also a character. My excelfile is in English numeric Sometimes the dataframe was indeed a dataframe, but I do not know why it did sometimes. Thank you in advance, Roberto PS I used "guess". The problem is not solve by using "text", "numeric" etc My syntax (I think I cannot send the excel file as bi...

...ually want. On 17-11-17, P. Roberto Bakker wrote: > Hi everybody, > > Question: why are my dataframe and numeric variables a character? > > I read an excel file via readxl but my dataframe is a character, and > numeric variables, eg "yi", are also a character. > My excelfile is in English numeric > Sometimes the dataframe was indeed a dataframe, but I do not know why it > did sometimes. > Thank you in advance, Roberto > PS I used "guess". The problem is not solve by using "text", "numeric" etc > > My syntax (I think I ca...

-------------- next part -------------- An embedded message was scrubbed... From: "=?ISO-8859-1?Q?Ricardo=20Rodr=EDguez?=" <webmaster at xen.net> Subject: Re: [R] query in R Date: Thu, 09 Nov 2006 13:45:21 +0100 Size: 2618 Url: https://stat.ethz.ch/pipermail/r-help/attachments/20061109/e1fbdf8f/attachment.mht

An updated version 1.1.1 of xlsReadWrite has been submitted to cran. Currently the cran version is still 1.0, but you can download the updated version already here: http://treetron.googlepages.com. xlsReadWrite is a package which allows you to natively read and write Excelfiles (windows only). Changes from xlsReadWrite 1.0.0 to 1.1.1 -> added colClasses argument ("rowname", "integer", "double", "factor", "character" and "NA" to determine type of data.frame column) -> "NA" values are no long...

...write native Excel files. The Pro version is a shareware package and adds features such as: ? Sheet handling (select/insert/copy/delete/ren.) ? Select regions (columns, rows, cells or area) ? Append data (several possibilities) ? Work with multiple files at the same time ? Inside information of an Excelfile ? oledatetime classes (Beta) with many additional functions ? the pro version is formally supported. Please have a look for yourself. I have put the documentation online: http://treetron.googlepages.com/00Index.html, http://treetron.googlepages.com/read.xls.html, http://treetron.googlepages.com/xl...

...ory objects (compose reports, append) ? better sheet handling (select/ins/copy/del/...) ? data area subsets (rows/cols/from/to/area) ? use (named) ranges and pick individual cells ? insert images, hyperlinks, work with formulas ? oledatetime type and many helper functions ? get information about an Excelfile. Browse the (shortened) help files: http://treetron.googlepages.com/00Index.html Download a brochure: http://treetron.googlepages.com/xlsReadWrite_Pro_Datasheet.pdf Download the package: http://treetron.googlepages.com/xlsReadWritePro_1.2.1.zip Download Test-/Demoscripts: http://treetron.googlepa...

Hello! I've generated multiple data frames that I wish to export to excel using the function write.table. When I do so all the data is merged into a single column in excel. I Would like the columns of my data frame in separate columns in excel as well but it doesn't work. I tried to download the package WriteXLS and installed Perl on my computer just like it was recommended. I also tried

Hi, How do I open an excel file in R? I have save the excel file in unicode text format, but it is not possible to open the file in R. /Pernilla

*I am a very new user of R. I've spent several hours trying to import data, so I feel okay asking the list for help. * *I had an Excel file, then I turned it into a "tab-delimited" file, as instructed by directions My filename is "lahore.txt" I amusing the following commands for read.delim but i am getting following mesages. Sir i am sending you my excel data file i

Hello everybody, I'm a newbie in R and just went through an introduction class recently. Here's my problem. I have 2 text files (.txt) with plain numbers ('doubles' for those who know c++) ordered into 2 columns as below: coordinate1 value1 coordinate2 value2 coordinate3 value3 ... ... coordinateN valueN I would like to write a small programme in which i would: 1. take

Hallo, I have this dataset with repeated measures. There are two within-subject factors, "formant" (2 levels: 1 and 2) and "f2 Ref" (25 levels: 670, 729, 788, 846, 905, 1080, 1100, 1120, 1140, 1170, 1480, 1470, 1450, 1440, 1430, 1890, 1840, 1790, 1740, 1690, 2290, 2210, 2120, 2040, 1950), and one between-subject factor, lang (2 levels:1 and 2). The response variable