Skip to main content
Known Participant
May 6, 2013
Answered

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

  • May 6, 2013
  • 1 reply
  • 1317 views

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?

This topic has been closed for replies.
Correct answer -hans-

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

1 reply

-hans-Correct answer
Inspiring
May 6, 2013

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

J.KahlAuthor
Known Participant
May 6, 2013

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

Inspiring
May 6, 2013

7.5.3