XLS import problem
- This topic has 2 replies, 2 voices, and was last updated 7 years, 5 months ago by .
- You must be logged in to reply to this topic.
Learn / Forums / General InDesign Topics / XLS import problem
Learn / Forums / General InDesign Topics / XLS import problem
Tagged: formatting, spreadsheet, Tables, XLS
Hi Gang,
Pulling my hair out over this one! I’m trying to import an XLS spreadsheet into ID as a link, and apply formatting automatically at the same time. My problem is an odd one – the XLS that I’m importing contains linked cells which are imported as values (ie. the content shows up correctly) when I import the XLS as unformatted. When I try to import the XLS as formatted, ID decides to ignore the cell values of the XLS (return a zero) in each linked cell.
Can anyone advise please? It’s driving me mad!
Best, Simon
I don’t know, but I generally use XLSX instead of XLS. Does that make a difference?
Thanks David – turns out I was using an .xlsx file! I’ve tried using a .xls file and it imports correctly… My problem now is whether the formulae in the .xlsx can handle being converted to .xls, but that’s beyond the scope of this forum :o/
Thanks again, I’m going to raise this as a bug to Adobe (unless itsafeaturenotabug)
Simon
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies allows us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.
You have to be logged in to save.
Not a member? Join Today - it's FREE!