How to read Excel in VBCS

Summary

How to read Excel in VBCS

Content

I saw some questions in the forum about reading/parsing an Excel file (xlsx), here are the required steps:

1. Add file picker to your page.   

2. Add the following code to the header section of the index.html file in your webapp:

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.0/xlsx.full.min.js"></script>

* no need to import any js library to the project.

3. Add FilePickerSelect event to the file picker object and call the following page module function:

  PageModule.prototype.processFile = function (fileSet) {
        
    var reader = new FileReader();
    return new Promise(function(resolve, reject) {