Overview

This page will help you to start and configure your ExcelGen website.
All you need is an MS excel file.

What can I do?

Draw your page the way you want your web page to look.
Use any formulas or images.
Input or edit data, and recalculate formulas.
Save calculation or export to PDF.

How to hide sheets?

Rename your sheet by adding "!" in front of it. Like "!Sheet1".
This will prevent ExcelGen from reading it.
Hidding sheet in workbook will also force to ignore it.

Roles and Customers

You can set up multiple roles - groups of specific files and sheets.
Then create some customers and add them roles.
Each customer will see only those sheets that are set in there roles.
Each customer will have special link or secret code to log in with.
In this way you can add discounts page to special customers or create separate pages for different languages.
You can control this to level of individual cells, using command. See Command list section.

How to limit columns and rows?

To limit columns, type "[END]" in first row, after last column you want to be visible.
To limit rows, type "[END]" in first column, after last row you want to be visible.

Last empty rows and columns will be ignored, and will not be displayed by default.
You may need this if there are filled rows you want to hide.

Password protected files

If file with password is uploaded, additional dialog will require to enter password.
You can select to store password in data base.
If password is not stored, every access to it will require password before file can be open.
You can store or clear password at any time in dashboard.

Command List

You can set specific commands for cells, by typing them in cell comment.
Note: Every command accepts values and formulas.

Command List

You can set specific commands for cells, by typing them in cell comment.
Note: Every command accepts values and formulas.
Command Value Description Example Image
Input Boolean Sets cell to be input control.
Each input can be customized to specific format. See Input formats section.
<Input>
Output Boolean Sets cell to be read-only input control.
Works the same as Input.
Also forces cell to update on calculation.
<Output>
Update Boolean Also forces cell to update on calculation.
This rule is applied automatically to all cells containing formulas.
Can be used to disable updating on calculation.
<Update=false>
Link Url Makes cell or image in cell a link to specified url.
Can forward to local or external site.
Note: To add link to image, place command in left top corner cell.
Note: Excel build in hyperlinks are supported as well.
<Link=www.google.com>
Link String Makes cell or image a link to another sheet, file or profile.
Note: To add link to image, place command in left top corner cell.
If Profile or File is not specified, it will stay the same as current.
If Sheet is not specified, it will redirect to first file in profile or first sheet in file.
Note: Excel build in hyperlinks are supported as well.
<Link=/?Sheet=Sheet2>
<Link=/?File=MyFile.xlsx&Sheet=Sheet2>
<Link=/?Profile=Anna&File=MyFile.xlsx>
Roles Comma separated roles Shows or hides cell if current user has or has not any of roles assigned to it.
Note: These roles must be created in your Dashboard.
<Roles=EnglishCustomer,Discount10%>
Visible Boolean Shows or hides cell based on value.
True by default.
Recommended usage with formulas.
<Visible=IF(B3>20)%>

Buttons

Buttons can execute custom functions.
Buttons are commands - set in comment block.
Containing cell will be rendered as clickable button.
Command Description Example Image
Calculate Disables automatic calculation and updates value only after button is clicked.
Use this for large files that take too long to update for automatic calculation.
<Button=Calculate>
Save Generates unique link that allows to access and share current calculation. <Button=Save>
DownloadPdf Exports current sheet to PDF format. <Button=DownloadPdf>

Advanced syntax

You can apply single command to multiple cells.
This will apply to all cell commands.

Fill command Syntax: <CommandName[([R/C][+][Count][:][Step])[,][([R/C][+][Count][:][Step])]][=FormulaOrValue]>

Anything within in "[ ]" is optional.
"R/C" means, use one: R (row) or C (column). Lower case r/c are supported.
"Count" is additional number of rows to apply this rule for.
"Step" is to how many rows step over, before applying rule.

So full version of: <Input> is <Input(R+0:1,C+0:1)=True>
Both versions will do exactly the same thing.
Examples:
Command Description Image
<Input(R+10)> Apply Input to current cell, and next 10 below.
<Input(10:2)> <Input(R+10:2)> Apply Input to current cell, and next 10 below, by stepping over 2. Between each of 10 Inputs, there will be one row skipped.
<Input(R+10:2,C+1)>
<Input(R10:2,C1)>
<Input(10:2,1)>
<Input(C+1,R+10:2)>
Same as previous, but apply rule to one additional column right. This will double the amount of inputs.