How can I change the import options for an Excel table in InDesign CS5.5?

[J.Kahl]

Hi,

I have a problem with an InDesign script that works this way in ID CS4 and ID CS5, but stops working in ID CS5.5.

What the script should do, is to change the import preferences for a table saved in an Excel file so that I can place an unformatted table into a new textFrame in my InDesign document. The Excel document is an .xlsx-File.

function setExcelImportPrefs() {
    with (app.excelImportPreferences) {
         app.excelImportPreferences.tableFormatting = TableFormattingOptions.excelUnformattedTable;
        }
}

What the script does (or at least seems to do) is: nothing. The table that is placed into the textFrame by the script is always formatted, as this seems to be the standard preference of InDesign CS5.5 for importing tables out of excel files.

Does anybody have a hint for me how to make the script work in ID CS5.5?

[-hans- · Accepted solution]

As it runs on my machine (!) one reason may be that right spelling should be : TableFormattingOptions.EXCEL_UNFORMATTED_TABLE

[J.Kahl]

-hans-, which version of InDesign do you use? CS5.5? If so, did you install all the Updates there are for that version?

[-hans-]

7.5.3

[J.Kahl]

Okay, now it is working. I had to save the XLSX-file into the older XLS format, but that seems to work quite well.

But I won't ever understand why InDesign loses its backward compatibility from one version to the other.

Thank you, -hans-.