Skip navigation
219 Views 4 Replies Latest reply: Jan 25, 2013 5:02 AM by KarenWisne RSS
ptc-4730507 Copper 2 posts since
Dec 21, 2012
Currently Being Moderated

Jan 7, 2013 5:07 AM

Paste Excel....

We would like to use the Paste Excel... option, however our data model does not allow text content directly in a "cell" element - the text must be wrapped in a "para" element first. This is stopping the Paste Excel option from working. Is there any way of getting Arbotext to automatically wrap the pasted text in the "para" element in each cell?

 

Thanks

    • ptc-3297166 Silver 162 posts since
      Jun 15, 2010
      Currently Being Moderated
      Jan 22, 2013 9:19 AM (in response to ptc-4730507)
      Re: Paste Excel....

      We had some issues with tables and <P> elements. It sure would be nice if PTC would fix the fact that you cannot select a table and click delete mark up to remove all the <P> elements. It will only delete the first cell <P> element. If you want to select the whole table and add and element, it will do it with hesitation. See http://communities.ptc.com/message/182344#182344. This is what we do if a cut and paste creates <P> elements.

       

       

      Bryon 

  • KristerBayer Copper 4 posts since
    Aug 13, 2008
    Currently Being Moderated
    Jan 25, 2013 12:51 AM (in response to ptc-4730507)
    Re: Paste Excel....

    Try to add para to InsertAroundToFix in the .dcf file for your doctype. 

  • KarenWisne Copper 9 posts since
    Jun 18, 2009
    Currently Being Moderated
    Jan 25, 2013 5:02 AM (in response to ptc-4730507)
    Re: Paste Excel....

    I needed to create about 300 tables in Arbortext from data in an Excel file. This may seem an odd way to get it done, but it was fast and worked great for what needed to be done.

     

    I made a template table in Arbortext so my formatting would be right.  Then I opened the .sgml file in notepad and copied the table into Word.  I then made a mail merge of the data using the Excel table.  I saved the mail merged document as a .txt file.  Open the .txt file, CTRL+A, CTRL+C, then CTRL+V right into the Arbortext document where I needed the tables.

     

    You've just got to be really careful where you put your mail merge fields, and where you paste the table back into Arbortext. This may or may not work for your tables or environment, but you would be able to insert the Excel data into a <para> tag.  There may be a fancier programming way to do this too, but that is above my pay grade!

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 3 points
  • Helpful Answers - 1 points