vbaraw field is NULL even when bookVBA property is set to true #348

New Issue

2016-01-12T20:39:53Z

sfdcale commented

2016-01-12 20:39:53 +00:00

(Migrated from github.com)

    <script>
        sforce.connection.query(
            "SELECT Id, Body FROM StaticResource WHERE Name = 'Sample_file'", 
            { onSuccess : handleUpdate,
              onFailure : handleFailure });
        function handleUpdate(result) {
            result = result.getArray('records');
            //console.log(result[0].Body);
            var workbook = XLSX.read(result[0].Body, {type:"base64",bookVBA:true});
            console.log(workbook.vbaraw);
        }
    </script>

Here, I am reading Excel file "Sample_file.xlsm" and trying to get the vba code present in the file by passing option parameter bookVBA as true but it returns null.

Note: It is reading the contents of the excel perfectly but not the vba code.

Could somebody help me on this? I don't know what is wrong I am doing here. Thanks!

``` javascript <script> sforce.connection.query( "SELECT Id, Body FROM StaticResource WHERE Name = 'Sample_file'", { onSuccess : handleUpdate, onFailure : handleFailure }); function handleUpdate(result) { result = result.getArray('records'); //console.log(result[0].Body); var workbook = XLSX.read(result[0].Body, {type:"base64",bookVBA:true}); console.log(workbook.vbaraw); } </script> ``` Here, I am reading Excel file "Sample_file.xlsm" and trying to get the vba code present in the file by passing option parameter bookVBA as true but it returns null. <b>Note</b>: It is reading the contents of the excel perfectly but not the vba code. Could somebody help me on this? I don't know what is wrong I am doing here. Thanks!

Sign in to join this conversation.