issues with parsing xlsx file about rubyxl HOT 6 CLOSED

+1 :)

from rubyxl.

Can you guys please provide more information on reproducing this issue?

from rubyxl.

thanks for this awesome gem.
but i m not able to parse xlsx files.

RubyXL::Parser.parse( params['file_to_upload'].tempfile)

where params['file_to_upload'] is >

while parsing it gives: *** RuntimeError Exception: Not .xlsx or .xlsm excel file

is there something i m missing?

error:

` Not .xlsx or .xlsm excel file
 raise 'Not .xlsx or .xlsm excel file' unless @skip_filename_check ||
/home/abc/.rvm/gems/ruby-1.9.3-p484@sample/gems/rubyXL-2.4.3/lib/rubyXL/parser.rb:26 : in `parse'
/home/abc/.rvm/gems/ruby-1.9.3-p484@sample/gems/rubyXL-2.4.3/lib/rubyXL/parser.rb:10 : in `parse'

from rubyxl.

@yogendra689: Yes. You are missing the ability to read and comprehend English language.

Your file is named RackMultipart20140320-9475-1smhr7c

While the gem is expecting the file to have .xlsx or .xlsm extension.

Yes, I know that technically, the extension does not matter, but this validation is the original gem creator's design that I did not get around to fix just yet, as there are many other things that need fixing first. And it helps at times too because it prevents people from trying .xslb files, which this gem is not designed to parse.

As a quick fix, rename your file before passing it to RubyXL.

from rubyxl.

but content_type of the file
"Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
indicates its a xlsx file.
is it necessary to specify full file path with extension for parsing?

from rubyxl.

Yes, it is necessary to specify full file path with extension for parsing.

from rubyxl.