search for: first_row

..."XLS") parsed_file = Excelx.new(filename,false, :ignore) if (file_format.upcase == "XLSX") raise t "#{filename} is not an Excel file!" if (!parsed_file) parsed_file.default_sheet = parsed_file.sheets[0]#''Sheet2''#oo.sheets[1] first_row = parsed_file.first_row last_row = parsed_file.last_row first_column = parsed_file.first_column last_column = parsed_file.last_column #logger.info "#### Total Rows:#{last_row}, first_row:#{first_row}, last_row:#{last_row}, first_column:#{first_column}, last_column:#{las...

.../controllers/uploads_controller.rb) def process_file post = Upload.import(params[:file]) flash[:ok] = "data imported" redirect_to :action => index end and here is my model (in models/upload.rb): def self.import(file) FasterCSV.foreach(file.path,:headers=>"first_row", :col_sep=>"\t") do |row| # here is where we will parse the data but just this stub for now: row.each{|row| puts "row: #{row.inspect}"} end end Can anyone please point out my dumb error here? Would sooooooooo appreciate the help (this forum rocks...

...eturns that occur within(!) a database text field and to read until "line feed" = end or row is reached? I tried to use option ":row_sep" but it did not work, it still uses the returns within the text field as end of row, too: FasterCSV.foreach("test", :headers => :first_row, :col_sep => ",", :row_sep => "\n") do |row| (\n should be line feed in ruby, right?) I also thought about replacing the return and line feed symbols by something else, but I don''t want to loose the return-information which I need for displaying the text of this...

holaa todos ante todo un cordial saludo alguien que me pueda ayudar. se plantea lo siguiente necesito mostrar 2 campos de una tabla los cuales son mtin_mtin,mtin_descri de una tabla llamada re_tmtinv de esos dos campos se necesita obtener el codigo y la descripcion,y luego ser mostrado para despues ser agregados a un formulario. el problema que tengo es que ya tengo la vista pero esta en blanco