Advertisement
Can anyone point me to a cohesive tutorial on getting data from Excel into an Indesign doc? I've seen Adobe's information and that all makes sense. What I really need is info on how to set up the Excel doc, and some advice on best workflows. Thanks!
posted by:
|
Advertisement
Advertisement
-
Re: xml to indesign tutorial?
Sat, October 6, 2007 - 11:57 AMThis may help:
www.webee.ro/2007/04/03/...in-indesign/ -
-
Re: xml to indesign tutorial?
Sat, October 6, 2007 - 4:18 PMClose but no cigar. Thanks for trying though. I am talking about using tagged xml data in Excel. I think I'm slowly finding my way though. It's another one of those cases where the chasm between bean counters and creatives can only be spanned by the bravest of designers! -
-
Re: xml to indesign tutorial?
Sat, October 6, 2007 - 8:26 PM
-
-
-
Re: xml to indesign tutorial?
Sun, October 7, 2007 - 8:37 AMi've been looking for something like that for ages... maybe we should write one?
-
Re: xml to indesign tutorial?
Tue, October 30, 2007 - 1:24 AMYou can also just highlight and cut and paste straight from excel into InDesign...the formatting is default, but you get the raw data and when you're in InDesign, you can resize the table, drag the cells bigger and smaller, and format all the text like normal...
-
Re: xml to indesign tutorial?
Sat, November 10, 2007 - 11:23 AMMaybe I should describe what I'm trying to do. I have a co-worker who creates eleven calendars per month. He does all the cut & paste currently & it's a huge pain. Meanwhile we receive the information in excel tables. If Excel can export XML data, and InDesign can import XML data, why not make it as easy as possible to get the data into the calendar template? Why cut & paste 330 - 341 cells every month? (BO-ring!) Aren't computers supposed to make our lives easier? (Yeah ok maybe.)
Anyway right now I'm hot on the trail of the solution. I'm not sure how to set up the XML structure so as to account for repeating records, ie multiple events on a given day. -
-
Re: xml to indesign tutorial?
Mon, November 12, 2007 - 10:43 PMOK, excel will output XML, but unless you know XSLT (or a scripting language), or you can get really creative with <cell> tags repeating for days on end it is not too useful. There are some great programs out there like Oxygen that will take the info from an excel spreadsheet and convert it to really clean XML, though you still may need to do some translations to get things into the order that you want. There are also a couple of websites that you can use to translate CSV file to XML. To go into it more fully here, will probably be unclear and not in depth enough.
This may help
www.creativyst.com/Prod/15/
There are lots of ways to go about this, it just really depends on the scope and the amount of time that you have to figure it out, but it is all very doable. -
-
Re: xml to indesign tutorial?
Tue, December 4, 2007 - 12:26 PMTHANK YOU!!!!!!!!!!!!!!!!!!!!
If I come up with anything I'll post back here.
-
-
