Hello, Thanks in advance for reading. I''m attempting to export data to an excel spreadsheet, and have done so successfully using RubySpreadsheet ( http://sourceforge.net/projects/rubyspreadsheet/ ) which is a port of the Perl WriteExcel module... Many of the methods however were left out, one of them being "insert_bitmap" and unfortunatley the bitmap is an important part of the export. Does anyone know how this can be done, and/or is anyone adventurous enough to help me update the RubySpreadsheet so it can accept images? Thanks in advance sw0rdfish -- Posted via http://www.ruby-forum.com/.
No One has any possible solutions to this problem? Any ideas or links would be appritiated, I''m totally out of ideas. sw0rdfish-2 wrote:> > Hello, > > Thanks in advance for reading. > > I''m attempting to export data to an excel spreadsheet, and have done so > successfully using RubySpreadsheet ( > http://sourceforge.net/projects/rubyspreadsheet/ ) which is a port of > the Perl WriteExcel module... > > Many of the methods however were left out, one of them being > "insert_bitmap" and unfortunatley the bitmap is an important part of the > export. > > Does anyone know how this can be done, and/or is anyone adventurous > enough to help me update the RubySpreadsheet so it can accept images? > Thanks in advance > > sw0rdfish > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > >-- View this message in context: http://www.nabble.com/Exporting-to-Excel-%28-all-versions-%29-tf2092709.html#a5839959 Sent from the RubyOnRails Users forum at Nabble.com.
> -----Original Message----- > From: rails-bounces@lists.rubyonrails.org > [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of sw0rdfish > Sent: Wednesday, August 16, 2006 2:31 PM > To: rails@lists.rubyonrails.org > Subject: Re: [Rails] Exporting to Excel ( all versions ) > > > > No One has any possible solutions to this problem? > > Any ideas or links would be appritiated, I''m totally out of ideas.<question about inserting bitmaps into Excel spreadsheets via rubyspreadsheet snipped> Short of porting the Perl code, there is no solution. In my defense, this method did not exist when I originally ported the code. It wouldn''t be too difficult to port but given the restrictions (24-bit true color bitmap images only, incompatible with write_comment, incompatible with Gnumeric or OOO) it strikes me as being of very limited use. Mind you, I''m assuming there are no 95 vs 97 issues with the port. If there are, then it''s doomed no matter what. If you''re on Windows your other option is to use Win32OLE to generate the spreadsheet instead. Otherwise, you''ll have to put in a feature request with Hans and hope. :/ Regards, Dan This communication is the property of Qwest and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.
First off, thanks for replying Daniel, didn''t expect to bump into you here... :) Secondly, I have no idea where I would start with that... I''m willing to try, but I wouldn''t have the first clue of where to start looking... What class would the Excel interation happen in? I''m assuming I''d have to open the perl source code for worksheet.pl, does it go deeper than that? I''m not too good at this stuff, and unfortunatley (in this case), I''m on a Mac, as are many of the users of the application... I do''nt think Hans is very interested in the project anymore, to the point where the sourceforge page is dead, I think I''m on my own :( P.S. While you''re here... mind explaining the merge function? i can''t get it to work :( Berger, Daniel wrote:> >> -----Original Message----- >> From: rails-bounces@lists.rubyonrails.org >> [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of sw0rdfish >> Sent: Wednesday, August 16, 2006 2:31 PM >> To: rails@lists.rubyonrails.org >> Subject: Re: [Rails] Exporting to Excel ( all versions ) >> >> >> >> No One has any possible solutions to this problem? >> >> Any ideas or links would be appritiated, I''m totally out of ideas. > > <question about inserting bitmaps into Excel spreadsheets via > rubyspreadsheet snipped> > > Short of porting the Perl code, there is no solution. In my defense, > this method did not exist when I originally ported the code. It > wouldn''t be too difficult to port but given the restrictions (24-bit > true color bitmap images only, incompatible with write_comment, > incompatible with Gnumeric or OOO) it strikes me as being of very > limited use. > > Mind you, I''m assuming there are no 95 vs 97 issues with the port. If > there are, then it''s doomed no matter what. > > If you''re on Windows your other option is to use Win32OLE to generate > the spreadsheet instead. Otherwise, you''ll have to put in a feature > request with Hans and hope. :/ > > Regards, > > Dan > > > This communication is the property of Qwest and may contain confidential > or > privileged information. Unauthorized use of this communication is strictly > prohibited and may be unlawful. If you have received this communication > in error, please immediately notify the sender by reply e-mail and destroy > all copies of the communication and any attachments. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > >-- View this message in context: http://www.nabble.com/Exporting-to-Excel-%28-all-versions-%29-tf2092709.html#a5840566 Sent from the RubyOnRails Users forum at Nabble.com.
> -----Original Message----- > From: rails-bounces@lists.rubyonrails.org > [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of sw0rdfish > Sent: Wednesday, August 16, 2006 3:01 PM > To: rails@lists.rubyonrails.org > Subject: [Rails] RE: Exporting to Excel ( all versions ) > > > > First off, thanks for replying Daniel, didn''t expect to bump > into you here... > :)I try to follow the list during the day at work, but that''s about it - just too much volume for me otherwise.> Secondly, I have no idea where I would start with that... > I''m willing to try, but I wouldn''t have the first clue of > where to start looking...Take a look at Worksheet.pm in the Perl source.> What class would the Excel interation happen in?In the Worksheet class (worksheet.rb).> assuming I''d have to open the perl source code for > worksheet.pl, does it go deeper than that?Nope, that''s it.> I''m not too good at this stuff, and unfortunatley (in this > case), I''m on a Mac, as are many of the users of the application...That rules out OLE then. Bummer.> I do''nt think Hans is very interested in the project anymore, > to the point where the sourceforge page is dead, I think I''m > on my own :(He''s using RubyForge now (http://rubyforge.org/projects/spreadsheet/). I gave him access to the SF project just in case he needed it, but that''s more or less an artifact now.> P.S. While you''re here... mind explaining the merge function? > i can''t get it to work :(Sorry, I don''t remember. Regards, Dan This communication is the property of Qwest and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.
Ok Thanks... I''ll see what I can do! RubyForge might give me more luck :) Berger, Daniel wrote:> >> -----Original Message----- >> From: rails-bounces@lists.rubyonrails.org >> [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of sw0rdfish >> Sent: Wednesday, August 16, 2006 3:01 PM >> To: rails@lists.rubyonrails.org >> Subject: [Rails] RE: Exporting to Excel ( all versions ) >> >> >> >> First off, thanks for replying Daniel, didn''t expect to bump >> into you here... >> :) > > I try to follow the list during the day at work, but that''s about it - > just too much volume for me otherwise. > >> Secondly, I have no idea where I would start with that... >> I''m willing to try, but I wouldn''t have the first clue of >> where to start looking... > > Take a look at Worksheet.pm in the Perl source. > >> What class would the Excel interation happen in? > > In the Worksheet class (worksheet.rb). > >> assuming I''d have to open the perl source code for >> worksheet.pl, does it go deeper than that? > > Nope, that''s it. > >> I''m not too good at this stuff, and unfortunatley (in this >> case), I''m on a Mac, as are many of the users of the application... > > That rules out OLE then. Bummer. > >> I do''nt think Hans is very interested in the project anymore, >> to the point where the sourceforge page is dead, I think I''m >> on my own :( > > He''s using RubyForge now (http://rubyforge.org/projects/spreadsheet/). > I gave him access to the SF project just in case he needed it, but > that''s more or less an artifact now. > >> P.S. While you''re here... mind explaining the merge function? >> i can''t get it to work :( > > Sorry, I don''t remember. > > Regards, > > Dan > > > This communication is the property of Qwest and may contain confidential > or > privileged information. Unauthorized use of this communication is strictly > prohibited and may be unlawful. If you have received this communication > in error, please immediately notify the sender by reply e-mail and destroy > all copies of the communication and any attachments. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > >-- View this message in context: http://www.nabble.com/Exporting-to-Excel-%28-all-versions-%29-tf2092709.html#a5840794 Sent from the RubyOnRails Users forum at Nabble.com.
Wow, the package has hand-coded OLE file formats. I bet it''s a lot faster than using OLE automation on a Win32 platform. If performance is not a concern you could use some OLE automation controller for Ruby. I know it exists... If not, you could always shell out to Perl or whatever. If you''re on a *nix platform I believe there are Ruby tools for controlling OpenOffice -- you could generate an OpenOffice spreadsheet and then export that to .xls If there weren''t a successful perl module I''d save as much of the .xls as you''ve generated, copy it, and insert the image using Excel, then save that. Do a bindiff, and that should give a starting point for coding the routine. Since there is a successful Perl module, I''d do one of the following: 1) Shell out to Perl 2) Set up a web service that runs the Perl routines 3) Find the Perl routine that inserts the image, translate it to Ruby, and add it to the rubyspreadsheet code ( maybe in conjunction with the bindiff for analysis, above ) But you''ve probably already though of all that... sw0rdfish wrote:> No One has any possible solutions to this problem? > > Any ideas or links would be appritiated, I''m totally out of ideas. > > > sw0rdfish-2 wrote: > >> Hello, >> >> Thanks in advance for reading. >> >> I''m attempting to export data to an excel spreadsheet, and have done so >> successfully using RubySpreadsheet ( >> http://sourceforge.net/projects/rubyspreadsheet/ ) which is a port of >> the Perl WriteExcel module... >> >> Many of the methods however were left out, one of them being >> "insert_bitmap" and unfortunatley the bitmap is an important part of the >> export. >> >> Does anyone know how this can be done, and/or is anyone adventurous >> enough to help me update the RubySpreadsheet so it can accept images? >> Thanks in advance >> >> sw0rdfish >> >> -- >> Posted via http://www.ruby-forum.com/. >> _______________________________________________ >> Rails mailing list >> Rails@lists.rubyonrails.org >> http://lists.rubyonrails.org/mailman/listinfo/rails >> >> >> > >-------------- next part -------------- A non-text attachment was scrubbed... Name: rob.vcf Type: text/x-vcard Size: 116 bytes Desc: not available Url : http://wrath.rubyonrails.org/pipermail/rails/attachments/20060816/77a85d5d/rob.vcf