Sharing: Web Object that reads Excel content into Storyline
Dec 03, 2018
Hi! I would like to share a web app that I am using for an Excel course. I have modified this app from SheetJS's great piece of code (Community Edition) that reads Excel file content using JavaScript.
My modified app allows you to specify the worksheet and cells to read in the "submitted" Excel file and writes the cell contents into Storyline variables.
It also changes the background image while the code is processing the Excel file. When inserted into a Storyline file and resized appropriately, it looks like a file input html button.
Try it out here: https://360.articulate.com/review/content/1691ccdb-13d3-4b06-a057-bc75bbe0b232/review
Download the project files here: https://goo.gl/z17BbF
How to use this web object:
- Specify the Excel worksheets and cells to read in "excel-sl2-config.xml" before inserting web object.
- Name Storyline variables using this convention: {sheetname}_{cell address} for the web object to write cell values.
- Create also a Storyline variable: ReadExcelFlag, whose value will become "completed' when the web object has completed reading the specified cells and writing them into Storyline variables. Can use this to trigger next action.
- Most ideal dimension for the web object is 200 x 50 px because the 2 images used to make it look like a button are in this dimension. So the dimension can be changed if you change the images. To avoid changing the code, just use the same file names "btn_select_file.png" and "btn_loading_file.png".
Please leave some comments! :)
2 Replies
That's pretty cool Ginno, thanks for sharing!
Welcome to E-Learning Heroes as well :)
Thanks!
This discussion is closed. You can start a new discussion or contact Articulate Support.