User-defined functions

SpreadsheetConverter does not support Excel macros, but you can manually convert your macros to JavaScript and use them in the converted web page.

SpreadsheetConverter supports Excel formulas and about 300 Excel functions. Macros written in Visual Basic for Applications (VBA) are not automatically converted and included with the web page.

However, if you can translate these functions yourself, the generated code can call them.

In the spreadsheet udf_toy.xls you can see the signature of the three functions that can be user-defined. The functions will be called each time the spreadsheet is recalculated.

Our implementation is currently limited to three user-defined functions per spreadsheet. If you need more flexibility, you can use the first string argument to send the name of the function, and have a switch first in your code to activate the corresponding functionality.

Our recommendation is that you define the functions twice, once in Excel for testing, and then in JavaScript for implementation.

You have to manually paste the definitions into the HTML created by SpreadsheetConverter every time you convert the spreadsheet.

Try this Excel add-in now!

Click on Download to install and test this Excel add-in for Windows.

Click on Upload to let us convert a spreadsheet for you for free.