Back

If your email is not recognized and you believe it should be, please contact us.

  • You must be logged in to reply to this topic.Login

InDesign 5.5 for Windows and Excel: find a code/price in .xls, replace into Indd

Tagged: 

Return to Member Forum

  • Author
    Posts
    • January 30, 2019 at 4:36 am #114022
      Service Dynergy
      Member

      Hello,
      i’m a new member.
      I’m working on a catalog price and I would like to connect data (product code and it’s price) from excel file with table inside InDesign.
      Inside InDesign textboxes are not in the same place/table or page.
      I know but i’m not find it that there is a apple script that read the price code in indesign, than find it in excel and replace it in Indesign.
      For example:
      in indesign i have this table:
      code product unit price
      005132 1 lt #005132# €

      in excel this table
      code product price
      005132 1.000

      i need that the script find 005132 in excel table and replace in indesign #005132# with 1.000

      Is it possible?

      Thank you

    • January 30, 2019 at 9:11 am #114029
      Michel Allio for FRIdNGE
      Participant

      Yes! …

      Best,
      Michel, for FRIdNGE
      michel.allio.fridnge@gmail.com

      • January 31, 2019 at 7:37 am #114050
        Service Dynergy
        Member

        Michel Allio, thank u but i don’t understand what mean your answer…

    • January 31, 2019 at 9:16 am #114056
      Masood Ahmad
      Participant

      Ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha :)

      Welcome to the Forum.

      I was expecting this from you. Only a handful people knows that Michel do not work for free until it is a one liner script.

      You can contact Michel on the email ID given by him and send your requirements in detail.

      Happy Scripting… :)

    • January 31, 2019 at 9:55 am #114059
      Michel Allio for FRIdNGE
      Participant

      Masood,

      As often about me, you’re totally wrong! …

      The last script I gave for free, some days ago, had … 2 lines!

      Maybe you become old and forgot you posted a comment in this thread! ;-)

      See: https://creativepro.com/topic/search-for-different-indent-sizes-with-one-command

      Best,
      Michel, for FRIdNGE

    • January 31, 2019 at 10:01 am #114061
      Masood Ahmad
      Participant

      Yes, I should have counted that as well :)

  • Author
    Posts
Viewing 4 reply threads
  • You must be logged in to reply to this topic.
Forum Ads