top of page

Jotting Note

Some draft notes

廣告設計師 + 企業合作軟體講師

部落格區域長期施工中。

原本當成個人隨手資料筆記用途,簡單記錄下感興趣的內容讓自己想看時方便點。

年會努力在工作之餘花時間整頓一下這個區域。

偶然查資料迷路點進來的人,有出處的文獻會有網址。可到原本出處看詳細圖文 :)

2023.4

搜尋

Indesign插入連動的Excel表格

Import from Excel to InDesign (incl. Table Styles)




How to Insert and Link an Excel Table in InDesign: Create Product Sheets

This tutorial will show you how to insert and link a Microsoft Excel file in Adobe InDesign. We’ll create product sheets that retain formatting from the Excel spreadsheet.

  • You can download the free project template from the button above.

The ability to copy Excel formatting to an InDesign document can be convenient in many instances, although some control is lost as part of the process. If you want to import an unformatted table in InDesign and apply formatting at a later stage to have a greater level of control, check out this other InDesign Place command tutorial. Pagination overcomes conversion issues and accurately converts even the most complex spreadsheets. It can also combine multiple data sources, e.g., product information from Excel files and pricing information from your ERP export. Table of Contents

  1. Preparing the Excel file

  2. Selecting a cell range

  3. Starting our InDesign document

  4. Linking InDesign and Excel

  5. Place the Table

Insert and link an Excel table in InDesign

Preparing the Excel file Let’s start our tutorial by preparing our Excel file. Below you can see an example of a formatted spreadsheet that is a perfect candidate for this method: Images should be inserted at this stage (if required) by using Insert -> Picture.

Selecting a cell range We now need to define the table cells that we want to import. Do this by selecting the relevant data, right clicking and pressing Define name. We’ve called our range “mercedes”: This step isn’t essential but is recommended as a best practice. It’s also only supported for .xlsx files in InDesign CS6 versions and later. Complete the process by saving and closing the Excel file.

Starting our InDesign document Now open InDesign and create a new document. Check the Primary Text Frame option in the New Document dialog box to ensure that the text flows correctly from page to page. (This option is referred to as Master Text Frame in older versions of InDesign). Also select the desired page orientation, column number and gutter size. Clicking on OK should reveal our new working document:

Linking InDesign and Excel We can next change a setting that will link our InDesign document with our Excel spreadsheet. This linking isn’t enabled by default but vastly simplifies any subsequent updates. You’ll now be able to edit the Excel data and have changes reflected quickly and easily within your InDesign layout. The required setting is found under Edit > Preferences > File Handlings. Here you’ll need to check the box marked Create Links When Placing Text and Spreadsheets.

Place the table We’re now ready to add the spreadsheet to our InDesign file. Start by drawing a text frame with the Text tool and moving/resizing it to your desired location/area. Now choose File > Place from the InDesign menu – or by using Ctrl+D on a Windows machine or Cmd+D on a Mac. You’ll now see a new Place dialog box. Select the file you want to import, click on Show Import Options in the bottom left corner and then click Open. A new Import Options dialog box will appear. We need to choose the range of table cells that we want to import under the Cell Range heading. We should see our previous label, i.e., ‘mercedes’. We then need to select the format for our data. We’ll use Formatted Table as our table includes formatting and images: Selecting Formatted Table will also allow us to check the Include Inline Graphics box. This box is essential to include the spreadsheet’s images with the import.

It's done! Now click OK to see the following result: You have successfully created a product sheet by linking an Excel table in InDesign!

最新文章

查看全部

InDesign預覽印刷尺寸 (indesign preview print size)

當您以100%查看時,InDesign CS6或更高版本將顯示實際打印尺寸-它會自動檢測主顯示器的分辨率以顯示實際打印尺寸。標尺尺寸為100%時,將以其實際尺寸查看。如果選擇“視圖”>“打印尺寸”,當前的Photoshop將為您提供實際的打印尺寸。在這種情況下,縮放百分比將取決於顯示器的分辨率和文檔的分辨率。Photoshop的100%視圖始終以1:1的監視像素預覽圖像,以將圖像顯示在屏幕上。 I

bottom of page