To publish reports from XLCubed you will need to have the XLCubed Web Edition installed on an appropriate server. The publication process is very straightforward and any report that can be opened in your XLCubed enabled version of Excel can be published.
Click here for videos showing web publishing.
To begin the publication process first open the XLCubed report and select the Publish to Web ribbon item (or the XLCubed > Publish to Web menu option in Excel 2003 and below) in Excel. This will display the Publish dialog:
The dialog allows you to connect to an XLCubed Web Edition server and select where the current report should be published. The detailed steps are outlined below:
- Connect to the server you want to publish to:
- Enter the name of the XLCubed Web Edition server you want to connect to in the Web Site field. This will depend on how you have installed the XLCubed Web Edition software on your server.
- Click Connect, and if connection is successful the folders available on the server will be displayed in the right hand side of the dialog (Folder to publish to).
- Enter the Report details:
- Type in the Name and Description that you want to give the report. The Name will appear in the Navigation tree view and on the report's tab. The Description will appear in the Repository on detail pages.
- Select where to publish:
- Navigate through the folders on the server to find the location you want by clicking on the tree on the right-hand side of the Publisher dialog. The report will be published to the folder that is currently highlighted.
- Existing reports are also shown in the tree. If an existing report is highlighted, then XLCubed will attempt to replace it with the published report.
- Depending on how your Administrator has configured the XLCubed Web Server it is quite possible that although you may be able to see a folder, you may not have the required security privileges to actually write (publish) to that directory. If this is the case a message will be displayed informing you that publication was not possible and you must select a folder to which you do have write permission. Contact your System Administrator to discuss permissions further.
- Choose options:
- Display after Publish causes XLCubed to open the published report in your web browser when the publication process is finished.
- You can click the Preview button to allow you to view the report in a browser without permanently publishing it to the server. A new browser window is opened when this option is selected.
- Click the Publish button to actually publish the report to the server. On successful completion a message is displayed confirming that the report will now be available in XLCubed Web Edition's repository.
If you see a message saying:
"The maximum number of rows that can be published is 1000. Sheet1 has
please see the Publishing more than 1000 rows page.
You can right-click to manage your Repository folders. The following options are available:
- Rename – renames the currently selected folder
- Add Sub Folder – adds a new sub-folder beneath the currently selected folder
- Add Top Level Folder – adds a new folder at top level of Repository
- Delete – deletes the currently selected folder
If you are using a SQL Repository you can right-click on a report and select Manage... to view and manage the report's permissions, history, views (including live version), schedules and preview image.