Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to read Excel in VBCS — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to read Excel in VBCS

Received Response
242
Views
32
Comments
edited Feb 7, 2022 10:54AM in Visual Builder 32 comments

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) {

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!