Create a web page from Excel file

FAQ

This page will answer common questions asked by ExcelGen users.

If you don't find your answer here, please contact us!

Why web page shows less rows/columns then I have?

First limiting factor is [END] tag, that must be located in A column of row or 1st row of column.

Anything after this will be ignored by generation logic.

Check your configuration limits.

Each profile is attached to configuration that limits amount of rows/columns that can be rendered.

Free accounts has tighter limits to preserve server performance.

You can view your current configuration in Dashboard, by pressing Config button in Files block.

See "Upgrade" page for more information.

Why do I see two or three pages rendered at once?

This is a header / footer feature, that you can configure in your file settings, in Dashboard.

If sheet is used as header or footer, it will not be visible in navigation or accessed directly.

If your file has sheets that are named "Header" or "Footer", they will be applied automatically.

How can I not upload specific sheet?

Any sheet can be hidden using role system.

Just remove sheet from default role, or any role you do not want this sheet to be visible in.

You can also name the sheet with "!" at the start. For example "!Sheet2". Then this sheet will be ignored by generation logic.

How can I update file without deleting file settings?

Uploading file with the same name will execute replace function.

In this case your file settings will be preserved.

Replace will not trigger configuration file limits.

If you need another name to your file, you can change it, by editing Title field in your file settings, in Dashboard.

How can I put ExcelGen inside my page?

Technical solution is iFrame - HTML tag.

This depends on what is your web page build upon.

In WordPress, for example, you can download any iFrame plugin.

If you do not have access to your page source or no way to edit it, contact your web page developer.

Why link to my sheet is not working to anyone but me?

ExcelGen beside your profile has a customer system.

When you log in with your profile, you are automatically logged in as admin customer.

You can see the value after last "/" in your URL.

Admin customer are accessible after login only and cannot be accessed by someone without your password.

Change the customer to default, and check default role/customer settings in Dashboard.

Also you can logout customer after logging in as profile, to get a correct URL.

Why my button or shape is not bind to link or button command?

Any shape or object, will inherit command defined in top-left corner cell of your shape.

Using glow or shadow settings on your shape, extends its borders, so it is not where excel wants you to believe.

Try removing those setting, or moving command more left and up.

You can see the size off your shape in browser, by right clicking on it and selecting open or save image.

If your shapes overlap or are too close together, they may render as a single image. Try moving them farther apart.

How to make image change on formula?

Excel provides multiple ways to change images or shapes based on formula.

Click here for more info.

Set <update> tag to top left cell of your image, tom make ExcelGen update changes.

My page is too large / small, how to size it?

Rendered page size is depended on zoom value on your sheet.

Try adjusting slide bar in bottom right corner of Excel.