You mean the question is in the subject. However, your question is not very clear.
a) import a PDF of the Excel sheet and place it on an exmpty, i.e. separate page in ID
b) copy certain columns from Excel sheet and paste on an empty, i.e. separate page in ID. The result depends on your import settings. If you want to gain a table that looks like in Excel, normal copy & paste will do.
You can not generate and insert new pages by importing anything.
Thank you very much.
Yes i have come to the conclusion that I had no better solution that cut and paste on separate pages.
You can also specify a range when placing the spreadsheet.
>You can not generate and insert new pages by importing anything.
Well, that's not true. That's exactly what happens when you import text and autoflow. I don't know any way to make that work with a spreadsheet, though, without scripting. I suspect it would ge relatively easy to script importing columns from Excel on a one column:one page basis, but you need to ask over in the scripting forum: InDesign Scripting
Scripting is an interesting idea but too involved for that only one occurence (26 pages is not a great deal).
But thanks anyhow.
Peter Spier wrote:
Ah, I remember that as an option in the preferences. Well, so it can be done. But I'd never use it. Too little control an how many pages will be generated etc. I prefer placing the imported pages myself.
Auto-flow is not the same as Smart Text Reflow (which I also turn off in the prefs). Autoflow is what happens when you hold the shift key and click to place a text file. Most of the ime the presumption is that you want the whole thing, and it's a lot faster to let ID add frames or pages as required than to add pages manually and click on each one.