Contents

# -*- encoding : utf-8 -*-
require 'csv'

module Workbook
  module Writers
    module CsvTableWriter
      # Output the current workbook to CSV format
      #
      # @param [String] filename
      # @param [Hash] options (not used)
      # @return [String] csv (comma separated values in a string)
      def to_csv options={}
        csv = ""
        options = {}.merge options
        self.each_with_index do |r, ri|
          line=nil
          begin
            line = CSV::generate_line(r.collect{|c| c.value if c},{:row_sep=>""})
          rescue TypeError
            line = CSV::generate_line(r.collect{|c| c.value if c})
          end
          csv += "#{line}\n"
        end
        csv
      end
      
      # Write the current workbook to CSV format
      #
      # @param [String] filename
      # @param [Hash] options   see #to_csv
      # @return [String] filename
      def write_to_csv filename="#{title}.csv", options={}
        File.open(filename, 'w') {|f| f.write(to_csv(options)) }
        return filename
      end

    end
  end
end

Version data entries

12 entries across 12 versions & 1 rubygems

Version	Path
workbook-0.4.14	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.13	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.12	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.11	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.10	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.9	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.8	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.7	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.6.0	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.5.1	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.5	lib/workbook/writers/csv_table_writer.rb
workbook-0.4.4	lib/workbook/writers/csv_table_writer.rb