How many sheets in Excel file

With JavaScript you cound set the excelImportPreference:

app.excelImportPreferences.sheetIndex = 2;

If you don't run into an error, you know you have an Excel file with at least two sheets.

Thx Stefan

-- In Applescript:

tell application "Microsoft Excel"

  set theCount to count sheets --> 4

  (* -- another way:

  -- get the sheet names:

       set xlNameList to name of every sheet --> {"Sheet1", "Sheet2", "Sheet3", "Sheet4"}

  -- and count the names:

       set xlNameListCount to count xlNameList

  *)

end tell

I could not find anything in the scripting API that gives the count of sheets available in Excel file. You could use VBScript or Applescript to get this info from your jsx.

-Manan