Jump to content

Import of Excel file


Recommended Posts

The lack of the ability to insert formulas in a Publisher V1 table meant I had to return to Serif PagePlus (why does an 'upgrade' have fewer features than the original?). The advertised posiiblity of importing excel files into Publisher V2 seemed to fix this but I haven't been able to do this.

The Help led me to believe that one should select the Open command from the File menu but when I do the File Open dialogue doesn't allow me to select a .xlsx file.

I can drag and drop an .xlsx file from Windows Explorer but only the contents of the first cell are displayed in the Affinity document.

Link to comment
Share on other sites

The Affinity product line is not an upgrade from the Plus line, it's a new product line.

AMD Ryzen 7 5700X | INTEL Arc A770 | 32 GB DDR4 3200MHz | Windows 11 Pro (22621.1778)
Affinity Suite V2.1 & Beta 2.1.0.1799
Better translations with: https://www.deepl.com/translator  
SVG preview in Windows Explorer with "SVG-See  Download SVG-See

Impossible things are done immediately, miracles take a bit longer!

Link to comment
Share on other sites

16 hours ago, Komatös said:

The Affinity product line is not an upgrade from the Plus line, it's a new product line.

It was promoted as an improvement on PagePlus etc. so I was disappointed when it had less functionality in this at least.

However, I still need to know how to import an Excel file.

Link to comment
Share on other sites

  • 2 months later...
  • Staff

Hi PDC, 

You should be able to place the .XLSX file into a table via the File > Place menu. Alternatively you can use the Data Merge feature described below.

https://affinity.help/publisher/English.lproj/index.html?page=pages/Advanced/dataMerge.html?title=Data merge

Thanks
C

Please tag me using @ in your reply so I can be sure to respond ASAP.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...

Important Information

Please note there is currently a delay in replying to some post. See pinned thread in the Questions forum. These are the Terms of Use you will be asked to agree to if you join the forum. | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.