You can place the table as formatted from Excel or you can do it in InDesign.
So, Bob, if I place it in InDesign, I'd need to restyle it to match my InDesign formatting, correct? Right now, I don't see a way to "place" it into a table already set up in InDesign other than cutting and pasting.
If you place as an unformatted table you can assign table and cell styles. If you choose to, you can do all the formatting in Excel and place it as a formatted table.
Either one works so it depends on what you’re comfortable with.
Thank you. I think, since I'm using already established InDesign tables from previous years (this is a large, yearly report that has 80 plus tables), that cutting and pasting the numbers into the InDesign, beautifully set up and intricate tables seems to make the most sense. The client was wondering if "importing" them would be an error-free way to set them up. But restyling them all in InDesign to match previous years seems like another way to introduce errors.
Errors come up only, if you don't use styles: Paragraph, Character, Cell and Table Styles.
I have a question in relation to this thread.
I would like to import data from excell into a indesign master page resulting in the master page creating new pages in sequence in line with the excel document.
ie. excel document contains list of page titles and i would like the list to import into a text box and create a new document for each new text box/cell entry.
excel. cell 1 = "index
excel. cel 2 = chapter one"
ind. master page 1 = "index"
ind. master page 2 = "chapter one"
Any ideas? im sure indesign must support this...