import an excel file containing images into publisher

[notabene34]

Hello
does anyone have a solution to be able to import an excel table into publisher, each line of which contains a pictogram (jpg file). When I import my excel file, the images are not there. However, I scrupulously followed the import method in excel. The images are fine in each cell because when I sort the file in excel the images are sorted fine too. Should the file be saved in a specific format? I saved it in xlsx format. I work in mac OSX Ventura environment
Thank you

test.xlsx

[thomaso]

In the .xlsx the images aren't literally content of cells but placed in a separate layer which is ignored on import/place or APub's data merge feature.

A workaround would be to export a PDF from Excel -> open in APub. This will keep the images in their layout (position, order, size) for further use and editing in APub, e.g. to combine these images with the correctly imported .xlsx table. (Note the size of the resulting .tiff images, which seems inefficient for this content).

[notabene34]

thank you for your reply. As there are more than 1500 rows in my table, the only solution I have found is to import the excel file as a table without the images and then copy/paste in the appropriate empty cell the small images which do not will only be 4mm high. We can also regret that publisher cannot manage tables as easily as InDesign by linking table columns to each other as they do with text. As far as my work is concerned, I will have to split my huge painting into several parts. I also tried to do a data merge but both in publisher and inDesign the applications crash.

[Komatös]

Hi @notabene34

For data merge it can be useful to link the pictograms just in time.

Create a directory in which all pictograms are stored.

In the cell where the pictograms are to be inserted, enter the path to the pictograms including the file name. See example.

Additional effect, the master file remains pleasantly small!

With 1500 rows, this is undoubtedly a hard work.

 

The first line must contain the headings!

Edited December 26, 2022 by Komatös

[thomaso]

2 hours ago, notabene34 said:

We can also regret that publisher cannot manage tables as easily as InDesign by linking table columns to each other as they do with text. As far as my work is concerned, I will have to split my huge painting into several parts.

With 1500 rows and the Affinity lack of table flow across several spreads it may be easier to use no table in Affinity but a text frame with tabs. This would enable you to use text flow and get the required number of frames and pages automatically created by Affinity.

[lacerto]

Obsolete.