Skip navigation
yoghurtbrain12
yoghurtbrain12 Calculating status...
Currently Being Moderated

InDesign doesn't import .xlsx correctly. Any idea is welcome!

Jan 8, 2013 8:10 AM

Tags: #cs5.5 #import #excel

Hi, I have the following problem: when importing .xlsx with cells that contain text as a result of a formula, the cell is empty when imported as "unformatted table". When imported as "formatted table", the content of the cells is there. "Regular" text cells (no formula) are imported correctly as "unformatted". Cells including numbers as a result of a formula are imported correctly anyway.

 

Saving the .xlsx as .xls is not an option, I get the file from a customer who surely won't do so;-) Importing as "formatted table" is a bad option, because the tables are formatted via SmartStyles by me and updated by the customer several times during production process. Any other idea is appreciated! Thank you.

 

Tested on different Macs with ID CS5 / 5.5 / 6 and .xlsx from Mac and PC.

315 Views   2 Replies   Latest reply: Mike_Edel, Apr 30, 2013 7:09 AM
 
Replies
  • Narraman
    Currently Being Moderated
    1. Narraman,
    Feb 19, 2013 4:34 PM   in reply to yoghurtbrain12
    Report

    +1 Im experiencing the same problem.

    Using:

    Indesign CS6 Version 8.0

    Excel 2010. Version 14.0.6112.50000 (64 bit)

     

    A workaround im using for now is a macro button that copies the "values only" to another worksheet in excel i labeled "indesign". that way i have all the output i require in text only format. (All i have to do now is wait for the day i forget to run the macro and use outdated data in my indesign file. )

     
    |
    Mark as:
  • Mike_Edel
    Currently Being Moderated
    2. Mike_Edel,
    Apr 30, 2013 7:09 AM   in reply to Narraman
    Report

    Exact same problem over here on Windows.

    Windows 7 64 bit SP1

    Excel 2010 32 bit

    As soon as I save as XLS it works but that breaks our workflow and is potentially unsafe (if somebody uses a 2010 only feature you will probably even lose data)

     

    Just reported it as a bug.

     

    Given that the "-1 doesn't import from xlsx" problem is also still not fixed (since CS4!) I'm wondering whether Adobe really wants to support the format. Trouble is, most people will have switched to 2010 or 2013 by now...

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points