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 appropriate Group and click the 'Weave' icon located on the right of the file row, or choose the file and click the 'Weave' button that displays on the top of the page.
Weaving is initiated. During the process, 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, [ADD LINK TO PARAMETERS PAGE] a Parameters dialogue box will pop up after Weave has been initiated.
Add the value required 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. [LINK TO SPREADHEETS PAGE]
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.
Navigating away from the Templates page during weaving will cause the notification box to disappear but this does not affect weaving.
You can also download previously woven sheets from the Spreadsheets page at any time.