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, "volume")

・Open the "volume" worksheet of the Excel file

    for item in items:

        _, itemName, _ = AZ_GetMediaItemName(item)

・Get the media item name

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

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

        volume = 0

        for k, v in (searchResult.get("Cells") or {}).items():

            volume = float(v.get("B") or 0)

・If there is a corresponding row, get the volume value in column B

        if volume != 0:

            AZ_SetMediaItemVolume(item, volume)

・Only if a volume value was obtained, set the media item's volume to that value

    AZ_Excel_CloseFile(excel)

・Close the Excel file

- API LINK -

AZ_InsertTrackSearchUniqueOnly

AZ_GetFilePathList

AZ_GetMediaItemName

AZ_SetMediaItemVolume

AZ_Excel_OpenFile

AZ_Excel_OpenWorksheet

AZ_Excel_SearchRowsInWorksheet

AZ_Excel_CloseFile