Environment Details

• AE Environment: On-Premise

• AE Version: 8.1.2

• Plugin Version: 4.1

Issue Description

The client reported an issue while processing an XLSB (Excel Binary) file, where the date field was not being read correctly in dd-mm-yyyy format during automation execution.

Due to this issue, the date values were getting misinterpreted, which caused downstream processing problems in the workflow.

Root Cause

The issue occurs because the XLSB format handles date values internally in a binary structure, and during automation/plugin processing, the date format was not being interpreted correctly as dd-mm-yyyy.

Resolution / Workaround Implemented

As a workaround, the XLSB file was converted to XLSX format, and after conversion:

• The date field was read correctly in dd-mm-yyyy format.

• The workflow executed successfully without any date-related issues.

Script Used for Conversion (XLSB → XLSX)----VbScript

WorkingDir = "?{Dir}"
extension = "xlsb"
filePassword = "Efreshjan26"
xlOpenXMLWorkbook = 51
Dim fso, myFolder, fileColl, aFile
Dim FileName, SaveName, ext
Dim objExcel, objWorkbook, objStdOut
Set fso = CreateObject("Scripting.FileSystemObject")
Set myFolder = fso.GetFolder(WorkingDir)
Set fileColl = myFolder.Files
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
objExcel.DisplayAlerts = False
Set objStdOut = WScript.StdOut
For Each aFile In fileColl
    ext = LCase(Right(aFile.Name, 4))
    If ext = extension Then
        FileName = Left(aFile.Path, InStrRev(aFile.Path, ".") - 1)
        filePath = aFile.Path
        Set objWorkbook = objExcel.Workbooks.Open(filePath, 0, True, 5, filePassword)
        SaveName = FileName & ".xlsx"
        objWorkbook.SaveAs SaveName, xlOpenXMLWorkbook
        objWorkbook.Close False
    End If
Next
objExcel.Quit
Set objWorkbook = Nothing
Set objExcel = Nothing
Set fso = Nothing
Set myFolder = Nothing
Set fileColl = Nothing

Final Status

✅ Issue resolved after converting the file from XLSB to XLSX format.
✅ Date values are now read correctly in dd-mm-yyyy format.
✅ Workflow is working as expected.