Importing of Multiple tabs excel sheet

http://help.smartsheet.com/articles/504553-importing-files-to-create-new-sheets

Importing Multiple Sheets from a Microsoft Excel Workbook

Only the first (left-most) worksheet tab of an Excel workbook will be imported. Look at the very bottom of your Excel workbook to see if you have multiple tabs.



If you have multiple tabs you'd like to import to Smartsheet:

• Import the workbook into Smartsheet once to create a new sheet, as described above.

• Go back to the Excel file and move a different tab into the left-most position by clicking on it and dragging it to the left.

• Save the Excel file, and import it to Smartsheet again. This will create a new sheet based on the information in the tab you just moved into the left-most position.

• Repeat the process until you've created a sheet for each tab in the workbook.

• In Smartsheet, consider moving all of the sheets into a folder or workspace for organizational purposes.

I solved this (on my Mac) by creating an AppleScript that takes a given Excel workbook and exports each tab as a file using the name of the tab as the filename. You can then follow the aforementioned instructions to import each file. Tedious to import but, it works.

We had a team using a workbook with well over 300 tabs and my script was able to churn through it over a coffee break. I had to actually build in a delay and slow it down or Excel (for Mac) effectively died after the first 40 or 50 tabs.

I can't upload the script but here's the text below of the AppleScript:

Excel-SaveSheet.scpt

set f to (choose file)

set posixF to POSIX path of f

tell application "Finder" to set filesDir to container of f as alias as text

tell application "Finder" to set fName to name of f as text

set posixDir to POSIX path of filesDir

{f, fName, posixF, filesDir, posixDir}

tell application "Microsoft Excel"

    launch

    open posixF

    set wkbkSrc to workbook fName

    set theSheets to every sheet

    repeat with i from 1 to number of items in theSheets

        set srcSheet to sheet i of wkbkSrc

        

        set wkbkTarg to make new workbook

        set lastTargSheet to sheet (count of sheets) of wkbkTarg

        

        copy worksheet srcSheet before lastTargSheet

        

        tell wkbkTarg

            set srcSheetName to name of srcSheet

            set fullTargFile to (posixDir & (srcSheetName & ".xlsx")) as text

            save workbook as filename fullTargFile overwrite yes

        end tell

        delay 3

        close active window

        delay 3

    end repeat

end tell