How do I import a multi page pdf file into a CALC sheet?
First answer: You canāt. All you can edit is the original document from which this print-out has been generated and then create a new PDF from the modified document. PDF is just an electronic print-out with similar restrictions as a paper print-out.
Second answer: Use a software able to extract the textual content from the PDF and see, what can be done with the pure text.
1 Like
Thanks Villeroy
Taking your advice I opened GIMP and converted a page to png image format. I could then insert the page into CALC with Insert>image drop down from CALCās top menu bar. Iām still trying to get a multipage pdf into png as a single fileā¦but thatās another help site.
No general answer possible: See PDF as a container for a programming language to place objects on a page. So you have to find out first, what you have. I have a big archive of pdf files generated by scanning documents. So the files are photos of pages.
Other may contain fonts/letters and even words. You can try as a fitst step to select pars of contents and see what you can copy and paste. My āphotos of pagesā would need an OCR-software to access text or figures.
.
Then you need to tell, what you expect from import to Calc. A picture of a page in a Cell a @koyotak seems to understand? Or does your pdf contain some table?
EDIT: There is pdfSAM or pdfTK to split pdf-files.
.
Just to mention it: pdf can be opened in Draw, but this is a graphics oriented approach, usually not usable as āimport-filterā for Calc.
There are 2 types of PDF.
- The PDF you get when you export something printable like an office document. It contains graphic elements and text. In a PDF reader, you can select text and copy to clipboard.
- The PDF you may get from a scanner. It contains one bitmap per sheet. Here you canāt select any text. If I recall correctly, the Tagged Image File Format can store multiple pages in one image file.
I think I have a non editable pdf type and I am only looking to put it into CALC as an image in source support of data used in the main spreadsheet sheets. Iāll keep playing with input/output formats within GIMP to get the desired 6 page in one image file that Iām trying to achieve.
Just store the PDF in the same directory as the spreadsheet document and use cells with hyperlinks opening the right PDF when you click on it. You may just store the file name in one cell, say Picture_0001.PDF in cell A1, and then =HYPERLINK(A1) returns a clickable hyperlink to open Picture_0001.PDF.
take a screenshot of the pdf-window as a picture.
Works for āscreen size readableā pdfs but canāt seem to make progress with a multipage pdf. Iām going down the convert pdf to png route at the moment.
You can import a pdf-file into LO-DRAW, than from LO-DRAW per OLE-Object to LO-CALC. I have tested one sheet, I donāt know if more sheets are possible. Try those.
The png file format cannot handle more than one page per definition. You will have to capture the pages of the pdf one by one into different png files. āDrawā can help you with that, or gimp, or quite few others as well.