Introduction to Weaving
Weaving is the core process orchestrated by Sheetloom to manufacture a new spreadsheet from the template supplied.
When weaving initiates, Sheetloom scans the template and matches ranges or worksheet names to Stitches, executes the Stitch query, and injects the results into the named range or worksheet of the new spreadsheet it creates from the template.
Weaving
Navigate to the Group where the template is located and click the 'Weave' icon located on the right of the file row, or choose the file and click the 'Weave' button that displays at the top of the page.
Weaving initiates. Notifications will appear in the bottom right corner of the screen confirming that Sheetloom is checking the template, weaving has begun, and the woven file is ready for download. If weaving fails, an error message is displayed.
If a Stitch query contains a parameter, a parameters dialogue box will pop up.
Add the required value and click Weave to continue, or Close to cancel the operation. In the example shown, the User is required to provide the name of the office they want the query to filter on.
Weaving continues as described in the previous section.
Download the woven file by clicking the brief notification that appears
Files can also be downloaded from the Spreadsheets page at any time.
To enable tracking and version control the new sheet name is comprised of the original template name, appended with the date and time of weaving.
The notification box will disappear if the user navigates away from the page but this does not affect weaving.
Woven sheets can also be downloaded from the Spreadsheets page at any time.