Web Pages INDEX


MacroSoftly Member " MEP " - Macro Entry Person.
Web Pages: The following Utilities (for Excel) create web pages using basic HTML. There is no XML. If you want to make your worksheet or workbook an XML web page then see my personal notes on XML XML: "If you are not using Microsoft Internet Explorer then you cannot view interactive spreadsheets. A spreadsheet appears as an outlined box on the Web page." Open your Excel workbook ... File > Save AS Web Page > Publish ... Interactivity (unchecked) makes the entire workbook a web page, with tabs for the worksheets. You cannot make On-sheet entries but you can make changes to the Source code to add content - then save the Source code as "whatever.htm". Changes you make in the spreadsheet are valid only for the current browser session. If you want to save changes you've made to data on a spreadsheet, you can export the data to a Microsoft Excel worksheet and save it there. Interactivity (checked) makes the entire workbook a web page, with a dropdown to select the worksheets. The interface is that of an excel workbook. You can add formulas and entries into the cells. Format: color, size, merge, numbers, alignment, sorting etc. But you CANNOT SAVE. Interactivity acts like an online Excel Workbook (Excel Viewer) but any changes you make after the first Publish cannot be saved using the Browser "SAVE AS" feature... "AutoRepublish every time this workbook is saved" (checked): This is the only way you can update (or make changes to) the Web Page. Here is an example: fourPage.htm of interactivity. To use this Web page interactively, you must have Microsoft® Internet Explorer 4.01 Service Pack 1 (SP1) or later and the Microsoft Office XP Web Components. This reference WebInteractNone.htm relies on style sheets and an XML list of components. Without them, you only get the framework of the sheet tabs. "The Page Cannot Be Displayed" will show if there is no subfolder with the Sheet Pages. filelist.xml, stylesheet.css, and sheet1.htm, sheet2.htm, sheet3.htm etc are saved into a sub folder named after the filename - "WebInteractNone_files". Look at the bottom of the screen, above the Status Bar, and you will see the Sheet Tabs. SECRET: You can use this framework by a right-click on the Sheet Tab to see the properties. The properties show what sheet name is linked to that sheet tab. you can then load any sheet into that folder as long as you call it, example, sheet001.htm . Click Sheet Tab("Sheet3") ... Back to TOP

MacroSoftly Member " MEP " - Macro Entry Person.

Web Pages:
The following Utilities (for Excel) create web pages using basic HTML. There is no XML. If you want to make your worksheet or workbook an XML web page then see my personal notes on XML
XML:
"If you are not using Microsoft Internet Explorer then you cannot view interactive spreadsheets. A spreadsheet appears as an outlined box on the Web page."
Open your Excel workbook ...
File > Save AS Web Page > Publish ...
Interactivity (unchecked) makes the entire workbook a web page, with tabs for the worksheets. You cannot make On-sheet entries but you can make changes to the Source code to add content - then save the Source code as "whatever.htm". Changes you make in the spreadsheet are valid only for the current browser session. If you want to save changes you've made to data on a spreadsheet, you can export the data to a Microsoft Excel worksheet and save it there.
Interactivity (checked) makes the entire workbook a web page, with a dropdown to select the worksheets. The interface is that of an excel workbook. You can add formulas and entries into the cells. Format: color, size, merge, numbers, alignment, sorting etc. But you CANNOT SAVE. Interactivity acts like an online Excel Workbook (Excel Viewer) but any changes you make after the first Publish cannot be saved using the Browser "SAVE AS" feature... "AutoRepublish every time this workbook is saved" (checked): This is the only way you can update (or make changes to) the Web Page. Here is an example: fourPage.htm of interactivity. To use this Web page interactively, you must have Microsoft® Internet Explorer 4.01 Service Pack 1 (SP1) or later and the Microsoft Office XP Web Components.
This reference WebInteractNone.htm relies on style sheets and an XML list of components. Without them, you only get the framework of the sheet tabs. "The Page Cannot Be Displayed" will show if there is no subfolder with the Sheet Pages. filelist.xml, stylesheet.css, and sheet1.htm, sheet2.htm, sheet3.htm etc are saved into a sub folder named after the filename - "WebInteractNone_files". Look at the bottom of the screen, above the Status Bar, and you will see the Sheet Tabs.
SECRET: You can use this framework by a right-click on the Sheet Tab to see the properties. The properties show what sheet name is linked to that sheet tab. you can then load any sheet into that folder as long as you call it, example, sheet001.htm . Click Sheet Tab("Sheet3") ...

Back to TOP