1 Reply Latest reply on Sep 28, 2016 10:16 PM by milligramme

    Possible or not to change Table_Formatting_Options

    BEGINNER_X Level 3

      Hi All,

       

      My request is to change the table formatting options

      from "TableFormattingOptions.EXCEL_UNFORMATTED_TABBED_TEXT"

      to "TableFormattingOptions.EXCEL_FORMATTED_TABLE"

       

      Screenshot for your more clarifications,

       

      Screen Shot 2016-09-28 at 1.51.49 PM.png

       

      To:

       

      Screen Shot 2016-09-28 at 1.51.56 PM.png

       

       

      Trying code is below:

       

      alert( app.excelImportPreferences.tableFormatting)
      
      if((app.excelImportPreferences.tableFormatting == TableFormattingOptions.EXCEL_UNFORMATTED_TABLE) || (app.excelImportPreferences.tableFormatting == TableFormattingOptions.EXCEL_UNFORMATTED_TABBED_TEXT) || (app.excelImportPreferences.tableFormatting == TableFormattingOptions.EXCEL_FORMAT_ONLY_ONCE)) 
      {
          app.excelImportPreferences.tableFormatting = TableFormattingOptions.EXCEL_FORMATTED_TABLE;
          }
      
      
      alert(app.excelImportPreferences.tableFormatting)
      

       

       

      Regards

      Siraj