How to import from Excel without it underlining the content in InDesign?

[andrewl74901267]

I am importing a selected cell range from Excel as a linked file. When I do this using a Formatted Table it includes Paragraph Rule underline in the first cell. There is no formatting that I can see in the cell in Excel. Is it possible to stop this happening?

<Title renamed by moderator>

[Abambo]

Can you post a screenshot?

[andrewl74901267]

Sorry thought I had attached with post.

 

[jane-e · Accepted solution]

---

@andrewl74901267 wrote: 

When I do this using a Formatted Table it includes Paragraph Rule underline in the first cell. 

---

Table styles include Cell styles; Cell styles include Paragraph styles; Paragraph styles include Character Styles.

Have you checked the styles that have been applied? Start with Table styles — what style has been assigned to the first column?

Jane

[andrewl74901267]

Located and sorted the problem thank you.

[jane-e]

---

@andrewl74901267 wrote:

Located and sorted the problem thank you.

---

Was the underlining in a Paragraph (or Character style) that was part of a Cell style that was applied to the first column in the Table style? Or something else?

Jane

[andrewl74901267]

Yes thank you it was. I couldn't drill down to see the actual 'rule' setting itself, but went into New Table Style / General / Cell Styles / New Cell Style / Paragraph Styles and set it to 'No Paragraph Styles'. Then copied this across all Cell options.

[Jumpenjax]

I usually save as pdf. Then open in photoshop sauce as Jpeg or tiff. Only main cell lines stay. All others are dropped.

[jane-e]

Hi Lee,

I'm confused. With your method, how will it work when the edits to the linked table are later updated in Excel? Do you then have to make a new PDF and open the entire InDesign document in Photoshop or just the table, then reimport it as an image? My apologies, but I am not following your workflow.

Jane

[Jumpenjax]

I am sorry, I just replace the new one if changes are made.

[Jumpenjax]

Should have answer all your questions. I just replace the new file tiff or jpeg using same method above and click replace on InDesign file not the other way.

[andrewl74901267]

I see that would be a quick fix thank you, however, I'm setting this document up with many cells across a large priced catalogue that will be updated regularly so to avoid copying and pasting each time there's an update I need the cells to auto update.