similar to: Problem saving xls Office 2007 #1

I did so: winecfg changed xp on vista added msxml3 and changed on Native (Windows) sh winetricks msxml3 gdiplus riched20 riched30 vcrun2005sp1 allfonts dotnet20 changed rpcrt4.dll on another error: http://paste.org.ru/?91emea [Question] [Question] [Question] [Question] [/list][/list]

Hi R users: I don't know if you have had the following problem trying to export to an "xls" format file in a non windows platform. I try to use the following packages: 1. dataframes2xls (version 0.4.4) (with phyton 2.7 and 3.1) 2. WriteXLS (version 1.9.0) (with perl and testPerl working) Even "xlsx" package that take too long and do not finish. The data frame I try to

Hi All Getting the below error when running the source code My requirement is : I want read / write the excel sheet ( both xls / xlsx ) from Ruby , if you have any other solution also share with me .. *Source Code :* * * * bash-3.2$ cat rubyXL.rb require ''rubyXL'' workbook = RubyXL::Parser.parse("test.xlsx") workbook = RubyXL::Workbook.new sheet_Name =

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.

I have recently switched to Ubuntu 8.04. And being a user that still needs the functionality of MS Office, I attempted to install Office 2007 by following the instructions @ http://samanathon.com/how-to-install-microsoft-office-2007-in-ubuntu-804/ And during the setup I fear that I have misinterpreted something as I now can't even get to the Wine configuration menu. I Have tried removing

Hi All, In my code @format_text = @workbook.add_format(:bold =>false) I get following error undefined method `font'' for {:bold =>false}:Hash in gems/spreadsheet-0.6.4/lib/spreadsheet/excel/writer/workbook.rb:352 when i try to export data into the XLS i am using following gems spreadsheet --version 0.6.4 spreadsheet-excel --version 0.3.5.1 My problem is when i use same code

I am having a problem in reading the columns from an xls file. Following is the code: workbook = Spreadsheet::ParseExcel.parse(params[:dump][:file]) worksheet = workbook.worksheet(0) skip=0 worksheet.each(skip) { |row| puts row.at(0) } I am storing "Customer" in the first row first column. When I print, it is received as

Dear All, I am using excel.link package to open and modify Excel files. When I manually open Excel, all my add-ins are loaded without a problem. But when I open Excel using excel.link package, like: xls<-xl.get.excel() xl.workbook.open("MyFile.xlsx") some Excel add-ins are (installed but) not loaded. Since the problem is related to local add-ins at my side, I cannot reproduce the

library(xlsReadWrite) mydata<-read.xls("file path", header=TRUE) however if I change xls to csv it works just fine. Any ideas what I'm doing wrong? I have have also using the package gdata with the exact same error. Below is the error that pops up. Error in findPerl(verbose = verbose) : perl executable not found. Use perl= argument to specify the correct path. Error in

Hi all, currently we have troubles with the constellation of Office 2007 / 2010 and samba 3.6.6 on Debian 7.5. I can open a Excel file only one time without a write protection. The File is protected on the second try. I can move and copy the file wihtout any Problems. If I move such a Excel File I can open it again for only one time without a write Protection. I already reseted and checked

I am using Wine version 1.1.29 on Jaunty. I have installed Office 2007 and installed winetricks, however, when I click on a Office program, nothing happens.

hey, I'm using samba version 3.6.6 on debian wheezy and windows 7 clients with office 2010, on my samba share I've the following settings: [cad] comment = CAD path = /mnt/samba-daten/work/webdav/cad writable = yes valid users = root, @cad, @fg-domuser admin users = abc, def, ghi create mask = 0770 force create mode = 0770 directory mask = 0770 force directory mode = 0770 veto

R version 2.13.1 OS X (or Windows) Colleagues, I received a number of files with a .xls extension. These files open in XL and, by all appearances, are XL files. However, it appears to me that the files are actually XML: > readLines(dir()[16])[1:10] [1] "<?xml version=\"1.0\"?>" [2] "<Workbook

Hello Guys, does anybody know if there''s anyway to upload a .xlsx file and then convert it to .xls file for later processing? i''d like to use spreadsheet to write a new xls file but it doesn''t support xlsx and the file is only importable with that format sadly. I saw roo but I don''t know if there''s a direct way to do it. -- You received this

One can import data from Excel ODBC source, but of course it is user's responsibility to ensure that the data are consistent. Each worksheet in the Excel workbook can be accessed as a table (for example, for Sheet1, you should type "select * from [Sheet1$]". The worksheet should have first row containing the column names, and the data rows should follow (the

On 29/10/15 10:51, Gary Stainburn wrote: > On Wednesday 28 October 2015 21:12:19 Ned Slider wrote: >> On 28/10/15 11:55, Gary Stainburn wrote: >>> We are receiving LOTS of emails that contain empty XLS or DOC documents >>> with embedded virus macros. These are getting past SPAMASSASSIN, Clamav >>> and Kaspersky. >>> >>> I'm trying to write

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

Hi, I?m using R package RDCOMClient (http://www.omegahat.org/RDCOMClient/) to retrieve data from MS Excel workbook. I?m using the code below to count the number of sheets in the workbook and then loop the data from sheets in to a list. ############# R code ################### library(gdata) library(RDCOMClient) xl <- COMCreate("Excel.Application") sh <-

Hi, This may be due to several reasons. That I can think about: 1) Ensure you close *all* possibly open workbooks: nBooks <- xl[["Workbooks"]]$Count(); for (i in seq_len(nBooks)) xl[["Workbooks"]]$item(i)$Close(SaveChanges=FALSE); 2) The excel application reference does not seem to be really released until the garbage collector runs. So this may help: xl$Quit();

I can use gdata to successfully read in the example Excel file, but not any other excel files. Why might this be the case? It seems that the problem has something to do with opening the database but no indication as to what the problem is. So i'm at a loss of how to fix it. > library(gdata) gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED. gdata: read.xls support