how to convert pdf file into xlsx file in ruby on rails

Question

I have uploaded 1 PDF then convert it to xlsx file. I have tried different ways but not getting actual output.pdf2xls only displays single line format not whole file data. I want whole PDF file data to display on xlsx file.

i have one method convert PDF to xlsx but not display proper format.

def do_excel_to_pdf
    @user=User.create!(pdf: params[:pdf])
    @path_in = @user.pdf.path
    temp1 = @user.pdf.path
    @path_out = @user.pdf.path.slice(0..@user.pdf.path.rindex(/\//))
    query = "libreoffice --headless --invisible --convert-to pdf " + @path_in + " --outdir " + @path_out
    system(query)
    file = @path_out+@user.pdf.original_filename.slice(0..@user.pdf.original_filename.rindex('.')-1)+".pdf"
    send_file file, :type=>"application/msexcel", :x_sendfile=>true
end

if any one use please help me, any gem any script.

The given link will give more details http://stackoverflow.com/questions/23223491/how-to-convert-xls-to-pdf-via-php — BEECEE, Oct 18 '16 at 06:11
Possible duplicate of [How to convert PDF to Excel or CSV in Rails 4](http://stackoverflow.com/questions/30183738/how-to-convert-pdf-to-excel-or-csv-in-rails-4) — Gagan Gami, Oct 18 '16 at 06:53
for this case you have to read `pdf` file and then create `csv` file and paste data in it. — uzaif, Oct 18 '16 at 10:40
thanks @uzaif but xls data not display proper format, i already use this way. — Chaudhary Prakash, Oct 18 '16 at 11:56
yes,only small file data get not hole pdf data like image or table. — Chaudhary Prakash, Oct 18 '16 at 12:45

score 1 · Answer 1 · answered Jan 30 '17 at 11:51

I would start with reading from the PDF, inserting the data in the XLSX is easy, if you have problems with that ask another question and specify which gem you use and what you tried for that part.

You use libreoffice to read the PDF but according to the FAQ your PDF needs to be hybrid, perhaps that is the problem.

As an alternative you could try to use some conversion tool for ebooks like the one in Calibre but I'm afraid you will lose too much formatting to recover the data you need.

All depends on how the data in your PDF is structured, if regular text without much formatting and positioning it can be as easy as using the gem pdf-reader

I used it in the past and my data had a lot of formatting - you would be surprised to know how complicated the PDF structure is - so I had to specify for each field at which location exactly which data had to be read, not for the faint of heart.

Here a simple example.

require 'pdf/reader' # gem install pdf-reader

reader = PDF::Reader.new("my.pdf")
reader.pages.each do |page|
  # puts page.text
  page.page_object.each do |e|
    p e.first.contents
  end
end

score 0 · Answer 2 · answered Oct 18 '16 at 07:11

0

not able to find options to convert from PDF to xsls but API Options available for converting PDF to Image and PDF to powerpoint(Link Given Below) Not sure u can change the requirement to show results in other formats!!

http://www.convertapi.com/

answered Oct 18 '16 at 07:11

BEECEE

66
2

you are right but i don't use any api for convert xlsx file like i am convert pdf to excel using " unoconv -d document --format=pdf File Name" – Chaudhary Prakash Oct 18 '16 at 07:29

how to convert pdf file into xlsx file in ruby on rails

2 Answers2