import sys

sys.path.append(RPR_GetResourcePath() + r"/UserPlugins")

from RIGDOCKS_python import *

from AZSTOKE_BRONZE_python import *

from AZSTOKE_SILVER_python import *

from AZSTOKE_GOLD_python import *

・Import RIGDOCKS

retval, inputList = AZ_GetUserInputList("", 2, "Source Path,Excel Path", ",")

・Prompt for the required input

if retval:

    sourceParentPath = inputList[0]

・Get the parent folder path of the audio files from the input values

    excelPath = inputList[1]

・Get the Excel file path from the input values

    track = AZ_InsertTrackSearchUniqueOnly(0, "work")[0] 

・Create a track named "work"

    sourcePathList = AZ_GetFilePathList(sourceParentPath, "wav")

・Get all audio file paths under the parent folder

    items = AZ_InsertMediaItems(track, sourcePathList, 0, 1, 0)

・Insert the audio files into the "work" track

    excel = AZ_Excel_OpenFile(excelPath)

・Open the Excel file

    worksheet = AZ_Excel_OpenWorksheet(excel, "items")

・Open the "items" worksheet of the Excel file

    for item in items:

        _,itemName,_ = AZ_GetMediaItemName(item)

        _,itemLength = AZ_GetMediaItemLength(item)

・Get the media item name and length

        searchResult = AZ_Excel_SearchRowsInWorksheet(worksheet, itemName, "A")

・Search whether the worksheet has a row corresponding to the media item name

        resultRow = ""

        if searchResult["Cells"] is not None:

                for k in searchResult["Cells"]:

                    resultRow = k

        if resultRow == "":

・Get the row number of the search result

            searchResult = AZ_Excel_SearchRowsInWorksheet(worksheet, ".+", "A", ",A", True)

・Get rows where column A is not empty

            newRow = 1

            if searchResult["Cells"] is not None:

                        for _ in searchResult["Cells"]:

                            newRow += 1

・Get the row numbers of rows where column A is empty

            AZ_Excel_SetCellValue_ByNumber(worksheet, newRow, 1, itemName)

            AZ_Excel_SetCellValue_ByNumber(worksheet, newRow, 2, itemLength)

・Write the media item name and length as a new row

        else:

・If there is a corresponding row

            cell = "B" + str(resultRow)

            AZ_Excel_SetCellValue(worksheet, cell, itemLength)

・Write the length in column B

    AZ_Excel_SaveDocument(excel)

・Save the Excel file

    AZ_Excel_CloseFile(excel)

・Close the Excel file

- API LINK -

AZ_InsertTrackSearchUniqueOnly

AZ_GetFilePathList

AZ_GetMediaItemName

AZ_GetMediaItemLength

AZ_Excel_OpenFile

AZ_Excel_OpenWorksheet

AZ_Excel_SearchRowsInWorksheet

AZ_Excel_SetCellValue_ByNumber

AZ_Excel_SetCellValue

AZ_Excel_SaveDocument

AZ_Excel_CloseFile