Hi, I'm using the 'spreadsheet' gem to generate a number of invoices automatically. In itself that works great, but when I come to print the files I have generated I get the error message "Microsoft Excel did not find anything to Print". Has anyone else run up against this problem and does anyone know how to get round it. Oh, and by the way, I also generated a one cell Excel file thus: require 'spreadsheet' Spreadsheet.client_encoding = 'UTF-8' book = Spreadsheet::Workbook.new sheet1 = book.create_worksheet sheet1[0,0] = 'Hello' book.write 'C:/Dokumente und Einstellungen/Jim/Desktop/new.xls' and still had the same problem. This was just to check I hadn't done something weird in my code.
on 2009-01-16 17:06
on 2009-01-16 19:30
Jim, On Fri, Jan 16, 2009 at 5:05 PM, Jim Burgess <firstname.lastname@example.org> wrote: > Hi, > I'm using the 'spreadsheet' gem to generate a number of invoices > automatically. > In itself that works great, but when I come to print the files I have > generated I get the error message "Microsoft Excel did not find anything > to Print". > Has anyone else run up against this problem and does anyone know how to > get round it. Yup, that was a known problem until a couple of days ago. Fixed in 0.6.3. hth best, Hannes
on 2009-01-16 19:54
Hi Hannes, I updated the gem and now it works like a charm. Thanks a million. Jim. P.S. One more question I have regarding the spreadsheet gem - how do you apply a thick border to a cell? format = Spreadsheet::Format.new :color => :black, :weight => :bold, :size => 12, :align => :left, :border =>1 will just give you a thin border. I tried increasing the number, stipulating :thick as a parameter, but no joy