Ask Your Question

Import images into libreoffice base database without using a form to manually import individual images

asked 2017-03-19 22:53:20 +0200

somnath gravatar image

updated 2017-03-19 22:53:36 +0200

I have a LibreOffice Calc spreadsheet that contains the following fields to generate student admit card.

  1. Roll number
  2. Name
  3. Semester
  4. Passport sized photograph

and other fields..

The 4th field contains the absolute path of the images. How can I print admit cards of each individual student using Forms in LibreOffice Base?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-20 04:38:58 +0200

Ratslinger gravatar image

updated 2017-03-20 05:46:23 +0200

There are different ways to use data from a spreadsheet in Base. A very simple method is to start the creation of a new database. Row 1 will be used for field names. On the opening dialog select Connect to an existing database. Then use the dropdown selector just below that and choose Spreadsheet. Click Next button. Use the Browse button and select your spreadsheet. Then Finish. Give the DB a name & save location and save it. It is a read only table you can use for Queries and Report generation.

If you want actual DB tables, you can copy the sheet data and paste into table section of main Base screen. Dialogs will prompt you to complete the actual table. Typically you would want row 1 data to become table field names.

There are other possible methods like using Writer and doing a mail merge.

LO documentation can be found on the Document Foundation site - click here.


Just want to clarify, the actual images are not necessary. The path is fine. In Report Builder use an Image control and tie it to the field containing the path. The image will be brought in to the report from its' location. Embedded pictures (Blobs) are a bit of a problem especially with space and don't even work with mail merge.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-19 22:53:20 +0200

Seen: 352 times

Last updated: Mar 20 '17