Secure data imports
You can import assets, individually or in bulk, through Excel worksheets. To ensure the security of your data, imported files are subjected to an Antivirus scan.
To further improve security, Content Hub includes additional measures to prevent data corruption and execution of malicious code.
Deactivation of formulas
Content Hub automatically deactivates formulas in imported Excel files by prefixing an apostrophe to all cell values that start with =
, +
, -
, or @
characters. This means formulas are treated as plain text after being imported; for example, a cell containing the formula =1+1
will render =1+1
as plain text instead of calculating a value of 2
.
Blocking macros
Macros are scripts written in Visual Basic for Applications (VBA) and used in Microsoft Office documents to automate long or repetitive tasks. While these can be helpful, malicious actors sometimes create harmful macros that run unwanted programs or delete files. For example, macros can use the VBA SHELL
command to run harmful programs or the KILL
command to delete files.
To prevent this, Content Hub uses the Aspose.Cells library to manage Excel sheets, blocking the execution of macros. Aspose.Cells does not support running VBA functions. For more information, see Can Aspose Cells run Macros.