Via vBase Workbook
Last updated
Last updated
The vBase Excel Library enables you to generate verifiable data and datasets directly from Excel.
The written instructions below guide you through the process using the latest version of vBase_Excel_Stamper.xlsm.
may also be helpful in gaining an overview of the setup and stamping process.
.
Unzip vBase_Excel_Setup_Latest.zip into a local directory on your computer.
Uninstall any existing version of the library.
Install the new version by running setup.exe.
If open, close vBase_Excel_Stamper.xlsm.
Unblock the file (if needed):
In Windows File Explorer, right-click vBase_Excel_Stamper.xlsm.
Select Properties.
In the General tab, locate the Security section.
If you see: "This file came from another computer and might be blocked...", check Unblock.
Click Apply, then OK.
Open vBase_Excel_Stamper.xlsm in Excel.
When prompted, enable macros.
Fill in the Stamping Parameters table on the vBase Setup sheet.
Run the vBase functions listed in the vBase Setup worksheet to generate new stamped data.
Stamp a range of cells using one of the following methods:
Function Method:
Example:
Keyboard Shortcut:
Press Ctrl + Shift + S to stamp the selected range via the StampRange macro.
You're now ready to start creating verifiable data!
To verify that your Excel data has been stamped:
Locate the relevant stamped file on your system.
Load the file to:
To create a verifiable collection:
Zip all the stamped files in the relevant collection directory.
(Exclude system files like desktop.ini.)
Verify the collection by loading the zipped file to:
Your API and Private Key, require you to .
Once logged in, these parameters are in the User Profile under
Note: Stamps are assigned to a based on the Collection Name specified in the Stamping Parameters.