How to show the EXCEL table direct to arbortext

[gcevallos]

If we have a EXCEL  table and we want to show it direct to ARBORTEXT what is best way to do it

[GarethOakes]

Have you tried copy and paste? Out of the box, Arbortext has support for "smart copy/paste" from MS Word but I haven't tested Excel.

[lfraley · Accepted solution]

Gareth is right, you can copy and paste from Excel. However, if you want the data to be pulled live from Excel then you want the Data Merge feature. There are two videos on youtube:

1. Arbortext Monster Garage https://www.youtube.com/watch?v=fBBFEpo5prk

2. Arbortext User Group https://www.youtube.com/watch?v=NLlRvzhYDjg

[RayStachowiak]

Liz is correct, Arbortext 6.1 has the ability to allow you to copy a table and paste into a document, however this is a static version. The alternative Data Merge requires a separate license to use this feature believe, so something to consider.

Ray

[lfraley]

Data Merge does not require a separate license, unless you're talking about a license for Excel (or Oracle or SQLServer).

[gcevallos]

‌We got the connection excel to arbortext, but only using Arbortext XML DocBook V4.0

but when we try to do the same, with DITA Thechnical Content, at Insert>marckup>mode, the query is not available

the question.  is posible to insert the dinnamic Excel table in Arbortext Dita>Consept?