CreativePro Forum

Return to Member Forum

• Author
  Posts
• • November 1, 2013 at 10:40 am #66066
    Justine Dowsing

    Participant

    Hi,
    I’ve got a book with 10 chapters, each using the same numbered paragraph style for numerous photo captions and my client needs to produce a spread sheet in excel that gives the number with the caption in 2 separate columns ready for them to add add various extras such as date taken etc. Is there a way to export all the text of one paragraph style to an excel sheet? Or even just to select all the text of a certain style so that it can be copied and pasted (much as you can in Word)?
    Thanks so much…your help could save days!
    Justine

  • November 1, 2013 at 11:26 pm #66074
    Gert Verrept

    Member

    Importing data in excel requires a certain format (tab delimited, cvs ….). When you export a peace of text it will be imported in excel as one cell, unless you’re able to select what you want, and add some formatting excel understands. Automatically selecting text with a certain para style isn’t possible, I think.

  • November 3, 2013 at 3:00 am #66076
    Alberto Gutierrez

    Participant

    Hi Justine. A solution will be to make a “fake” table of contents selecting as the only entry the paragraph style you want. Select no page number and if there are several indesign documents in the book check the option to find the entire book. Copy and paste the text of the TOC and voilà.

    Hope it helps.

  • November 4, 2013 at 3:11 am #66081
    Justine Dowsing

    Participant

    Thanks Gert and Alberto for your responses. A simple genius solution there Alberto, with the ‘contents’ which has worked brilliantly being as the image captions are generally pretty short. Thank you ;0)

• Author
  Posts