similar to: Re: Importing / Parsing Large Excel Files ?

Displaying 20 results from an estimated 1000 matches similar to: "Re: Importing / Parsing Large Excel Files ?"

2013 Oct 04
2
pregunta
En el libro EPICALC (pagina 229-230) en el que está el siguiente script, todo nos funciona bien, pero cuando vamos a life table, ya allí no avanza, lo señalamos en el script, por favor quizá se nos haya ido algún detalle, pero fuimos siguiéndolo por el libro paso a paso y no no hemos percatado Todos los de el paquete survival de la ayuda del R funcionan perfectamente
2013 Oct 04
1
pregunta
Hola Jose, y podrias enviar algun link al libro o enviar esa parte escaneada ?? para minimizar la posibilidad de que haya algo en la transcripcion del script ... Slds, eric. On Fri 04 Oct 2013 01:59:33 PM CLT, daniel wrote: > José, > > La función survfit espera como argumento una fórmula. Al pie del help de la > función survfit dice: > > "Versiones anteriores del código
2009 Oct 17
2
New issue with a New Vista Client - couldn't find service
Running a samba server version 3.0.7 on a FreeBSD box Life has been fine with XP and so forth I added a new vista workstation to my small network Vista found my shares and I am able to access them with no jerking around with authentication types or such as I use appropriate pw and user name to log into the vista box. Problem is vista is spamming my server, taking up >50% cpu
2009 May 05
0
How to write data into excel files using roo
Hai, I am using parseexcel to export data to a excel,while exporting a large amount of data it shows a MaxSizeError. Ithink that i will use roo for exporting data into excel.But i dont know the codings to write data into excel can anyone help me.. Thanks in Advance -- Posted via http://www.ruby-forum.com/.
2004 Feb 16
1
xls2csv.pl: Script to translate Excel files into CSV
I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. Usage ----- perl xls2csv.pl <excel file> [<output file>] [<worksheet number>] Translate the Microsoft Excel spreadsheet file contained in <excel file> into comma separated value format (CSV) and store in
2010 Oct 18
7
excel parser (preferably perl)?
I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from rpmforge anyway). Is the current CPAN version better? Or the equivalent java tools? Or
2019 Jun 02
3
Incluir un rango de varias variables explicativas a un modelo
Hola, Quiero especificar una ecuación con varias variables explicativas de una manera eficiente sin necesidad de escribir todas y cada una. Tengo un conjunto de variables (junto con otras) dentro de una base de datos que se llaman pot23 pot311 pot312 pot 316 pot317........... pot80. No necesariamente están secuenciadas. Quisiera saber cómo indicar que incluya todas las variables de pot23 a pot80
2009 Sep 29
1
not permitted to access this share
I've checked the wbinfo all returns as expected . I've checked the user on the UNIX server can access the files and dir - no problem. I don't understand if SAMBA is actually try to map FIRSTGROUP\admandymarr on to the share ? If it is then it wont work, as the share only specifies the username not the domain and username. I'm not using PAM for these shares , is it needed ? Am I
2007 Jan 26
2
Centos 4.4 perl modules. where are they?
I need to install VICIDIAL (cause is a free outbound call solution) and vicidial wants the following perl modules: MD5 Digest::MD5 Digest::SHA1 readline Bundle::CPAN DBI (found the rpm perl-DBI) DBD::mysql (found the RPM perl-DBD-Mysql) Net::Telnet Time::HiRes Net::Server OLE::Storage_Lite Spreadsheet::ParseExcel I do not want to taint the installation if an RPM is available on the DVD or in
2001 Dec 15
1
Understanding backup-dir semantics
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Please cc in replies as I am not subscrubed to the list - However I have just searched backwards over the list archive looking for an answer and I can't find any posts relating to this. I am currently backing up my family's windows machine over the network to my linux box by mounting the windows disk as a file share an using cp to copy
2008 Sep 08
1
Roo gem installation fail
hi I am tried to install roo gem 1.2.0 but it gives me following error. It seems it require stdio.h which is not present. Can you please help me how to install roo gem checking for stdio.h... no *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration
2013 Oct 17
1
Fwd: Read a Number column with leading zeros using Roo gem
Hi all, I am trying to open and read a xlsx file, which I have attached. The upc column in that file, is the one I''m talking about. If I open the file in the Open Office Spreadsheet, it is correctly displaying with leading zeros. But if I read it with Roo gem it truncates the leading zeros. I understand this is the expected behavior since the column type is Number. But how is Open Office
2005 Nov 19
3
Permissions problem I don't understand
I am try to use rsync from my windows box (under cygwin) to back up "My Documents" on to a debian server (known on my home network as roo.home) running rsyncd from inetd where it is run as root. my rsyncd.conf file sets the gid and uid to user backup.backup thusly:- syslog facility = daemon uid = backup gid = backup hosts allow = 192.168.0.0/24 hosts deny = 0.0.0.0/0 timeout = 600
2019 Jun 04
3
Incluir un rango de varias variables explicativas a un modelo
Hola, gracias por la respuesta, No me funcionó debido a que los nombres de las variables no están seriadas, es decir, los nombres de las variables son del tipo: x23 x25 x30, x301 x320, x80. Entonces me da este error: Error in eval(predvars, data, env) : object 'pot24' not found. Debido a que pot24 no existe, ya que de pot23 se brinca a pot30. En Stata es algo muy simple de hacer, solo
2011 Feb 02
1
Roo gem performance problems
I am getting unacceptable performace problems by using the roo gem for reading a file by using XLSX or XLS library from this gem. Someone may suggest me an alternative about how to parse an .XLSX file? <code> parsed_file = Excel.new(filename,false, :ignore) if (file_format.upcase == "XLS") parsed_file = Excelx.new(filename,false, :ignore) if (file_format.upcase ==
2006 Aug 02
2
Behaviour that I don't understand
I am trying to set up rsync as a daemon under WindowsXP (professional) in order to be able to backup this machine on to a linux server. I am struggling with an issue I don't understand. I don't know whether it is an Rsync issue or a Cygwin issue, so I am asking both mailing lists. My WindowsXP machine has ip address 192.168.0.25 and name rabbit.home My Linux machine has ip address
2013 Oct 04
0
pregunta
José, La función survfit espera como argumento una fórmula. Al pie del help de la función survfit dice: "Versiones anteriores del código también permiten la especificación de una sola curva al omitir el lado derecho de la fórmula, es decir, ~ 1. El manejo de este caso requiere algunas manipulaciones poco comunes y frágiles, este caso ya no es compatible." (sepan disculpar la
2007 Jan 17
12
Excel sheet generation
Hi, Does anyone know of a package that will help with generation of spreadsheets? (xls files, not csv) Thanks, Fredrik --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe
2013 Oct 04
8
is there any way to convert .xlsx to .xls
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
2011 Aug 05
2
Which is more efficient?
Greetings all, I am curious to know if either of these two sets of code is more efficient? Example1: ## t-test ## colA <- temp [ , j ] colB <- temp [ , k ] ttr <- t.test ( colA, colB, var.equal=TRUE) tt_pvalue [ i ] <- ttr$p.value or Example2: tt_pvalue [ i ] <- t.test ( temp[ , j ], temp[ , k ], var.equal=TRUE) ------------- I have three loops, i, j, k. One to test the all of