Skip navigation
Currently Being Moderated

Importing data from Excel — I do not want to be table as final result

Nov 26, 2012 6:34 PM

Tags: #table #excel #import_xls

Hi there!

 

Importing XLS data was discussed a lot already. But I don't want to create table, but I need to import text to the prepared textframes across the document.

 

Have a look at the IMG below. There will be about 300 such cells. Photo and textframe below. I have XLS file with all the info. And I need this info to be put to that textframes {green in the IMG}. Is the only solution to Copy > Switch to the ID-window > Paste > Delete redundant paragraphs > Switch to the Excell window? It would require a thousands mouse-clicks & keystrokes…

 

http://i.imgur.com/XVTrW.png

 

The structure of my textframe looks like this {Microlight was typed manually}:

http://i.imgur.com/bnHYP.png

 

Each paragraph has source in XLS file:

 

http://i.imgur.com/4JoIO.png

 

 

I understand importing the Excel table when i wan to create ID table. But I have just a bunch of textfields...

 

Thank you!

 
Replies
  • Currently Being Moderated
    Nov 27, 2012 5:09 AM   in reply to ChristianAaltonen

    This might be a job for Data Merge, or a commercial catalog plugin, but the merged celss are going to be a real problem, I think. Exporting as a text file from Excel  and just palcing it may also work, with the same caveat about merged cells, and a probable need to use find/change to remove tabs.

     
    |
    Mark as:

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