Skip navigation
WendyIDEXX
WendyIDEXX Calculating status...
Currently Being Moderated

From Excel to Indesign

Apr 27, 2012 3:02 AM

Version:1.0 StartHTML:0000000149 EndHTML:0000001318 StartFragment:0000000199 EndFragment:0000001284 StartSelection:0000000199 EndSelection:0000001284     I would like to know if there is a way when I change copy content in excel file then the indesign file will change immediately. E.g.: so my client have excel files contain characters/numbers and they would like me to build a table in indesign document. Next day, my client change the numbers and they want to have it as fast as possible in our indd table. Until now, we did it manually (like copy paste each table from MS excel file). Is it possible to change table content in indesign (indd) directly from an excel file without losing paragraph or character styles?
I lost the styles with this tricks
http://help.adobe.com/en_US/indesign/cs/using/WSa285fff53dea4f86173837 51001ea8cb3f-6f41a.html
http://forums.adobe.com/message/4088696 (with JavaScript)
 
Thank you

1290 Views   2 Replies   Latest reply: Steve Werner, Apr 27, 2012 6:08 AM
 
Replies
  • Peter Spier
    Currently Being Moderated
    1. Peter Spier,
    Apr 27, 2012 3:36 AM   in reply to WendyIDEXX
    Report

    You can choose to link the spreadsheet data and Place the sheet or a range rather than pasting it, and it will update like any other link. When it updates, though, the the formatting will revert to the formatting in Excel UNLESS you define and use Cell styles and Table Styles for your tables.

     

    Placed spreadsheets are not linked by default, so before placing you must go to the preferences and change the option to link. You will probably wnat to change it back after placing the table, or all of your placed text will also be linked.

     
    |
    Mark as:
  • Steve Werner
    Currently Being Moderated
    2. Steve Werner,
    Apr 27, 2012 6:08 AM   in reply to Peter Spier
    Report

    Incidentally, when using Cell Styles and Table Styles and updating your Excel file, you would still have to reapply the header attribute to rows. But in the about-to-be-released InDesign CS6, that header information is retained.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points