4 Replies Latest reply on Sep 28, 2016 12:42 AM by BEGINNER_X

    TableFormattingOptions.EXCEL_FORMATTED_TABLE

    BEGINNER_X Level 3

      Hi All,

       

      I have clarifications about the below code,

       

      if the Indesign having table import options should be "Unformatted Tabbed Text".

       

      When I import test.xls, it working fine.

       

      In the same time test.xlsx, not working. Please clarify this should be a bug.

       

      Screen Shot 2016-09-26 at 12.55.24.png

       

      myImport_Excel = File ("~/Desktop/test.xls")
      //myImport_Excel = File ("~/Desktop/test.xlsx")  //Not Working
      
      
      var myTextFrame1 = app.activeDocument.pages[0].textFrames.add({geometricBounds: [20, 10, 80, 250]});
      
      
      with(app.excelImportPreferences) {  
      aligmentStyle = AlignmentStyleOptions.SPREADSHEET;  
      tableFormatting = TableFormattingOptions.EXCEL_FORMATTED_TABLE;  
      }     
      
      
      myTextFrame1.place(myImport_Excel)
      

       

       

      Next Feasibilty:

       

      Is it possible to change the import options from "Unformatted Tabbed Text" into "Formatted Table" automatically through script?

       

       

      Thanks in Advance

      Siraj