Importing Text From Excel

[Brett_Matteen@adobeforums.com]

I am running into a problem when I am trying to import text from an excel spreadsheet into InDesign. When I copy/paste it from Excel, I lose all of the formatting of cells. If I place the text, it will insert it as a table but it still reformats the text. Basically I want to keep the headers centered when importing the file so that I do not have to spend a bunch of time fixing things that were correct before importing the file. I can adjust the columns to be centered if I import as a table, but then there are boxes around the columns and I can't figure out how to eliminate these. In Pagemaker I was able to import directly from a spreadsheet without having to reformat any of the text, but I am at a total loss with InDesign. Any help would be greatly appreciated.

Thanks,
Brett Matteen

[Dave_Saunders@adobeforums.com]

Brett,

Take a look at this page <http://www.pdsassoc.com/index.php?Nav=solnssub&Ban=PopulateTableFromClipbo ard&Info=PDSproducts/PopulateTableFromClipboard/index.php>. I've created a script to address this very problem.

The reason that something like this is not built into the application itself is that in the general case, the problem is insolvable, but in real life, just about everybody is in your situation. That's why I created my script.

Dave