The task pane

The task pane is where you do much of your work with SpreadsheetConverter. It lets you add graphical widgets and set options for the converted web page.

The task pane is pretty wide and can occupy a significant portion of the screen in Excel. The Task Pane section of the SpreadsheetConverter menu allows you to Show the task pane when you need it and Hide it when it’s no longer needed.

Screenshot of the Taskpane choice in the SpreadsheetConverter ribbon

The task pane has tabs for its different sections.

If you click on the Widgets tab you get a list of the various graphical widgets you can insert into the spreadsheet.

Click on the Cell tab to adjust the settings for the widget in the currently selected cell.

On the Workbook tab, you set most of the conversion options.

On the Worksheets tab you mainly get to select the worksheets should be visible in the converted web page, and to hide worksheets that only contain long tables of internal lookup data.

Screenshot of the Worksheets tab with two worksheets automatically hidden

After each conversion, any error messages are available on the Errors tab of the task pane. Shorter messages in the upper section link to more detail below.

Adjusting the task pane

To change the width of the task pane, drag the horizontal separator left/right to match your requirements.

To show/hide the task pane, you can click on the dotted symbol on the horizontal separator, or use the Task Pane section of the SpreadsheetConverter menu.

Screenshot of the dotted symbol on the horizontal separator between the spreadsheet and the task pane