1 Reply Latest reply on Aug 18, 2011 5:45 PM by John Hawkinson

    Export to Excel...from ID CS5

    creusche

      Hi there, my coworker posted something similar on the InDesign forums but I thought I would ask over in scripting as well. I've also searched tho forums and found alot of info on importing from excel but I'm wondering about exporting to excel.

       

       

      We are in the process of trying to populate a database with content that  is in InDesign CS5. In order to populate the database the data needs to  be in excel and then into the database. Rather than  cutting and pasting, is there a way to export from InDesign CS5 into  excel?

       

      To give some background we are using multiple pages with alot of content.

       

      Think 36 weeks of schedules (tables) organized by week and day..... followed by 2 text frames (or more) worth of content. Our boss would like to have everything organized as it looks in the schedule but I don't think it will be that easy and I think it would take alot of man hours to accomplish.

       

       

      We've tried this method:

      Select/Highlight all the table data.

      Table > Convert Table to Text (Column seperator = Tab, Row seperator = paragraph)

      Select/Highlight all the resultant text

      Export > Text

      Open the resulting text file with Excel

       

      Which only added extra information the the excel file we couldn't use.

       

      Are there and scripts or plugins we could try?

        • 1. Re: Export to Excel...from ID CS5
          John Hawkinson Level 5

          Your colleague's post:Populating Database HELP!

          I think it is best to stick to that thread, otherwise we get needless duplication of effort.

          As it is, we are already puzzled, because the offered solutions should just work fine.

           

          Indeed, you say:

          We've tried this method:

          Select/Highlight all the table data.

          Table > Convert Table to Text (Column seperator = Tab, Row seperator = paragraph)

          Select/Highlight all the resultant text

          Export > Text

          Open the resulting text file with Excel

           

          Which only added extra information the the excel file we couldn't use.

          What kind of added information you couldn't use?

          That doesn't make much sense at all!

           

          Giving us an example of the files, and screenshots of the problem would help a lot.

           

          But don't do it in this thread! Do it in the main thread! That way everyone working on the problem can work together and we won't be divided in our Quest!