similar to: Re: Can not open Excel password protected file

I have installed Win 1.1.42 on Ubuntu10.04 and installed Excel2007 as part of MS Office 2007. I can open a non-password protected .xlsx file without a problem. However, when I try to open a password protected .xlsx file, I get an error message "The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization." I am certain

i am unable to open a file which is saved as .xlsx format in R . The file contains approximately 1,50,000 rows. So I m not able to save it as csv file.Please suggest ways to open this file -- View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017273.html Sent from the R help mailing list archive at Nabble.com.

I have a Toshiba laptop that came with Windows XP and OneNote installed. I then installed Ubuntu Dapper Drake and am dual-booting the system. I want to run OneNote on Ubuntu with WINE. Obviously I could set up WINE to use the dual-booting native DLLs (but I don't know how to do that), and I can't install OneNote directly on Ubuntu with WINE because while I have a legal copy of the full

>What are you actually using for authentication ? We are using Quest Authentication Services (formerly Vintela Authentication Services), which is a Kerberos/LDAP/Active Directory client for UNIX & Linux. Authentication and Identity Mapping appears to work correctly, I can log on and see my uid/gid/correct groups list with SSH and group-based access for files and directories appears to

Buen día, Estoy extrayendo solo una parte de texto de una celda en Excel, pero tengo un inconveniente. Quiero extraer el texto desde donde dice *textura* hasta el siguiente punto, pero hay unas celdas que dicen *texturas* y me está extrayendo también ésta *s*, cómo podría cambiar el siguiente código para que me extraiga tanto textura como texturas. Quedo muy atento, gracias. rm(list = ls())

Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) > channel <- odbcConnectExcel("results.xlsx") Error in odbcConnectExcel("results.xlsx") : odbcConnectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel

Dear Rxperts, Through Windows OS, I created shortcuts (paste as shortcut) to excel spreadsheets ( with "xlsx" as the file extension). I wasn't able to read the shortcuts through R and using "read" functions of "xlsx" package. exf <- "a1.xlsx.lnk" > read.xlsx(exf,1) Error in .jcall("RJavaTools", "Ljava/lang/Object;",

I have several hundred Excel 2007 data files in a folder. I would like to read every file in a single given folder using a loop. I have searched the FAQ, the forum archives here, other or older R boards and the R Import / Export documentation, and have asked some very knowledgeable R users without learning of a solution. I hope someone here can help. I understand that the most common

I?ve got an Excel workbook with about 30 worksheets. Each worksheet has 10000 rows of data over 30 columns. I?d like to read the data from each worksheet into a dataframe or matrix in R for processing. Normally, I use read.csv when interacting with Excel but I?d rather manipulate a multisheet workbook directly than set about splitting the original workbook and saving down each part as a csv.

HI, I have large dataset of many countries. I have written the program to run through each country to generate one output for each country. I want to put the output like this: one sheet has output for one country. How do I achieve it by r. I have tried this: library(xlsx) write.xlsx(nnn, "vn.xlsx", sheetName="Sheet1") [1] but when I change sheetName="Sheet2"

Hi, I need some help to export a data frame with 83 rows and 1411 colums. I have used the package RODBC until now. But now, I have 1411 colums that I can't send to the old excel. If anybody knows a package to convert my data frame in xlsx tell me! Thanks for help in advance! Pamela Botrel -- View this message in context:

Hi all, I have imported xlsx file (Excel 2007) into R using the following scripts. *library(RODBC) * *setwd(".......") * *query <- odbcConnectExcel2007(xls.file = "GI 2010.xlsx", readOnly = TRUE) dat <- sqlQuery(query, "select * from [sheet1$]", as.is = TRUE, na.strings = "exp")* *dat* contain one column consisting of intergers and characters

Hi List, just to know if the issue is only a problem of mine or if it is a general issue due to the new MS Office pack. I'm using R 2.11.1 32 bits in a Windows 7 x64 with the MS office 2010 x64 installed. I can import .xls files normally (the same way I did with my Excel 2007 32 bits). But the function odbcConnectExcel2007 isn't able to import .xlsx files now that I have the new version of

Hm thats stange? i have test some lock options, masks, etc. but i got everytime the Error Microsoft Excel can not be accessable file ?Volumes:test:path:DB0B7110? ?. > Am 19.02.2015 um 16:33 schrieb L.P.H. van Belle <belle at bazuin.nl>: > > Hai, sorry about the delay.. i had to do some work here.. > > in my global settings in smb.conf > > ## Acl-EA settings >

Hello again, I'd like to determine if an Excel file is open or writable. Can anyone help me with that? I write some stats to an .xlsx Excel file using the xlsx package. I can't write to the file unless its closed. How do I determine if the .xlsx file is open or closed so I can write to it? I've looked at file.info and file.access and I couldn't get those to work for me. Any

i was trying this configuration yesterdayand does not help. But i was find out more things. When I?m connect with CIFS the Problem can not reproduced. A saw with SMB and with CIFS the Logfile ~filename.xlsx not unlinked everytime when Excel will be closed. > Am 20.02.2015 um 09:54 schrieb Daniel M?ller <mueller at tropenklinik.de>: > > If everything fails try this. Is

i have the following for a share on my samba 3.6.6 directory mode = 2770 force directory mode = 2770 blocking locks = no can you try these. Greetz, Louis >-----Oorspronkelijk bericht----- >Van: oliver.werner at kontrast.de >[mailto:samba-bounces at lists.samba.org] Namens Oliver Werner >Verzonden: donderdag 19 februari 2015 12:45 >Aan: samba at

Muchas gracias Carlos, lo que quiero hacer es lo siguiente: extraer el texto que hay entre textura/s hasta el punto final. Ejemplo: *Moderadamente profundos, bien drenados, de textura franco arenosa a franco arcillo arenosa. Fertilidad natural media* Lo que quiero extraer sería: *franco arenosa a franco arcillo arenosa * Al final lo pude realizar de la siguiente manera: df <-

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

Muchas gracias por la alternativa de utilizar la librería stringi, Carlos, no la conocía. On Fri, 31 Mar 2023 at 12:11, David Camilo Gomez Medina < dcgomezme en unal.edu.co> wrote: > Muchas gracias Carlos, lo que quiero hacer es lo siguiente: extraer el > texto que hay entre textura/s hasta el punto final. > Ejemplo: > *Moderadamente profundos, bien drenados, de textura franco