Price list in Affinity Publisher

[LSW]

Hello

It is possible to create price list in Affinity Publisher? I try to add excel file in Data Merge and display my price's but I don't have excel table and my prices are in different sites. 

[Komatös]

Hi @LSW

How is the data organized in the Excel file?

You will surely have a row with headings? For example like this:

Partnumber | Article | Stock | Price

[thomaso]

Of course it is possible to create a price list in APub.

2 hours ago, LSW said:

I try to add excel file in Data Merge and display my price's but I don't have excel table

If you don't have an Excel table what did you try to add? Note, you can use various file formats for Data Merge:

Quote

Data source types

Data sources include text (plain/CSV/TSV), JSON and XLSX spreadsheet files (e.g. Microsoft Excel, Apple Numbers, LibreOffice). The text files could be an exported address book or contact lists. Your data records could also include image links (resource path names) which can be be associated with a picture frame in Publisher—on merging, the referenced images (e.g., profile or product photos) merge into picture frames sequentially.

… but Affinity does not read or collect data directly from websites.

[h_d]

16 minutes ago, thomaso said:

Apple Numbers

Only if you export from Numbers to .xlsx, .csv or .tsv. Plain .numbers files can't be used as data sources.