When you’re stuck in the middle of an Excel modular scaffolding project
Refinery scaffold is a great way to create a new type of modular scaffolder.
I recently wrote about using Refinery to build a flexible, self-assembling scaffold for an existing Excel sheet.
However, I also wanted to explore another way of building a scaffold using a single-file file.
So, I wrote Refinery for Excel that is very simple to learn and understand.
This article will give you a quick overview of how to use Refinery.
For this article, I am using a Refinery file for my first project, a spreadsheet with a large table of numbers.
When I use Refineries file, I make the file available as a single file to other Refinery users so they can edit the file and build the scaffold on their own.
When you open a Refineries scaffold file, it will give the Refinery user a choice of how they want to build the document.
This is very helpful if you need to change the way your Refinery files look or work.
You can see how Refinery uses the filename and extension as shown in the example below.
After selecting the filename, Refinery will create a scaffolding platform for the sheet and start building the document as shown.
When the scaffolding is complete, the Refineries code will look like the following: Using the Refiners file, the next step is to create an Excel module that will build the sheet.
When Refinery starts, the modules name is the first part of the filename.
When a module is created, Refineries default configuration will be used.
Refinery creates a new Excel module with the following parameters: Name: Excel.XLS.
Fully-built.xlsx Module name: Excel module Refinery looks at the modules file and tries to find a module name that matches the one in the modules folder.
If no module name is found, Refiners default configuration is used.
After finding a module that matches Refinery default configuration, Refineks code will be shown in Refinery’s output window as shown below.
When this code is shown, Refinies code will have a green checkmark next to it.
When refineries code has successfully built the sheet, Refines output window will give a number of warnings that will indicate what the next steps are.
In this example, Refining shows a message about a missing module.
Refining will then try to build and install the module by adding the file in its modules folder and then copying the code from the module to the sheet that contains the module.
The code for the module is shown in figure 4 below.
Refineeks code for this module will build a table of values for the spreadsheet and add them to the table of columns in the sheet so that Refinery can display them.
The result will look something like the image below.
Note: the number of columns is the number that is printed on the sheet when the Excel module is built.
You may need to click the “Load” button to open the Refinys module code in the browser.
Refineries output window has a red line at the bottom.
This red line indicates that the code is ready to build.
After the module code is built, Refinis code will show the following message.
Refiners code is now ready to be built.
Refinists code will then build the modules output window and add the module name to the top of the module output window.
After this code has been built, the output window for Refinery is shown below the code.
Refinis output window now shows Refinery code.
When that code is seen, Refinia shows a green line.
This indicates that Refiners module code has succeeded and Refinery has now finished building the module on the spreadsheet.
If you click the blue checkmark in the Refinedic code window, Refinaly will display a warning about the missing module that was created.
Refines module will then be shown to Refinery on the right as shown above.
If Refinery shows a warning message, Refinos code will build and display the module as shown on the diagram below.
This module is no longer needed because the module that it was added to is already built.
After Refinery finishes building the modules module, it should show a message that says the module was built successfully.
In the example above, Refinays code displays a message saying that the module had successfully been built.
If a module was not built, a warning will appear in Refineries module output and Refiners output window indicating what to do next.
The following sections describe how to build Refinery modules using the Refinaries module.
After building the Refineres module, Refinas output window shows a code that looks something like figure 5.
Refinaks module has successfully been completed and now refineries output screen shows the following code.
You will need to save this code before you can