|
In Microsoft Excel, with menu "File" -> "Save
as Web page", you can save the Excel data to web pages
and publish to your website.
To password protect web pages created from Microsoft Excel,
please note the following matters.
For multiple sheets Excel file:
After you save a Excel file to web page, MS Excel will generate
a HTML file and a subfolder which contains HTML files of the
sheets.
Suppose the name of the Excel file is "mydata.xls",
and you save it to web page "mydata.htm". The MS Excel
will generate a HTML file "mydata.htm" and a subfolder
"mydata_ files". In the subfolder "mydata_files",
there are several HTML files: "tabstrip.htm", "sheet001.htm",
"sheet002.htm", "sheet003.htm" etc.
The "sheet00X.htm" files are the web pages which
contains the real data in the Excel sheets.
When password protecting web pages created from Microsoft Excel:
1. In step 1, please ONLY select the "sheetX.htm"
files in the subfolder, do NOT select the HTML file outside
the subfolder. Otherwise, Internet Explorer may not work with
it.
2. In step 3, please select the option "Using faster encryption
algorithms". This is because MS Excel always generates
a very large HTML file.
For single sheet Excel file:
In this situation, MS Excel will only generate one HTML file,
so you may lock it as a normal HTML file. Be sure to select
the option "Using faster encryption algorithms" in
step 3. This is because MS Excel always generates a very large
HTML file.
|
