Microsoft Office Tutorials and References
In Depth Information
Sharing data beyond Excel
Sharing data beyond Excel
Yes, some people don’t use Excel, and you might meet one someday. Seriously, plenty of
reasons exist for making Excel-based data accessible outside the program, whether or not
Excel is available at the destination. Posting data to a website or creating data sets for
proprietary analysis software are two possible applications where you might want data that can
fly free, independent of the Excel mother ship.
Office Web Apps
Office Web Apps give you a familiar Office experience when you are away from your Office
applications on your computer. With your Office files uploaded to a web storage location
such as your own website or Windows Live SkyDrive, you don’t need your own computer or
software to view and perform light editing of Word, Excel, PowerPoint, and OneNote files.
You just need a computer running a popular Web browser.
For more information about Office Web Apps, see Chapter 27, “Working in the cloud.”
Using web file formats
Two options in the Save As Type drop-down list in the Save As dialog box produce files you
can use as webpages: Web Page (HTM, HTML) and Single File Web Page (MHT, MHTML).
They produce essentially the same result, the important difference being that the Web Page
format saves not only a main HTML file but also a folder containing supporting files that
must travel with the main file. As you might expect, the Single File Web Page format
manages to cram it all into a single file without using the supporting folder. Single File Web
Page has the advantage of being more portable, but Web Page gives you more control
over individual elements. A separate cascading style sheet is created using the Web Page
format, along with individual HTML files for each worksheet in the workbook. Figure 2-37
shows the contents of the supporting folder that is created after saving a five-sheet
workbook named Team Sales using the Web Page file format.
If you are an HTML aficionado, you can open the supporting files in other programs.
For example, if the original workbook contains graphics, Excel saves them as separate
image files (JPEG, PNG, or GIF) you can modify with an image-editing program. Or you
can change the fonts used by editing the cascading style sheet with a text editor such as
Notepad. This is not work for the timid, of course. The slightest editing error in the HTML
code for any of the files has the potential to render them all unusable.
Search JabSto ::

Custom Search