Actions

Category

Difference between revisions of "Tips and tricks 1.5"

From Joomla! Documentation

(Excel to Joomla)
Line 5: Line 5:
  
 
1. Open up your Excel Workbook. Mine is Schedule.xls
 
1. Open up your Excel Workbook. Mine is Schedule.xls
 +
 
2. Highlight the part you want displayed on your site. Give that range a name. (I named mine HTM)
 
2. Highlight the part you want displayed on your site. Give that range a name. (I named mine HTM)
 +
 
3. Save the workbook.
 
3. Save the workbook.
 +
 
4. Save the workbook again as a Web Page (Name your file, Select the range, Select Publish )
 
4. Save the workbook again as a Web Page (Name your file, Select the range, Select Publish )
 +
 
5. I created a folder on my server named HTML
 
5. I created a folder on my server named HTML
 +
 
6. Upload your web page to the folder you create. (Mine is Schedule.htm)  
 
6. Upload your web page to the folder you create. (Mine is Schedule.htm)  
 +
  
 
Open Joomla Backend
 
Open Joomla Backend
  
 
1. Create a new Menu Item
 
1. Create a new Menu Item
 +
 
2. Select the Wrapper Type
 
2. Select the Wrapper Type
 +
 
3. Name the Menu and on the right enter the URL for your htm file. (Mine is http://95.0.74.132/schedule.htm)
 
3. Name the Menu and on the right enter the URL for your htm file. (Mine is http://95.0.74.132/schedule.htm)
 +
 
4. Hint: File name is Case Sensitive. You may have to change the Width Parameter.
 
4. Hint: File name is Case Sensitive. You may have to change the Width Parameter.
 +
  
 
Save and Publish the menu.
 
Save and Publish the menu.
 +
 
Preview your site and you should be able to see your Excel Sheet.
 
Preview your site and you should be able to see your Excel Sheet.
  
 
Charlie Adams
 
Charlie Adams

Revision as of 15:17, 15 July 2009

How to place a copy of an Excel Worksheet on to your web site for Viewing only.

Thanks to: imanickam for suggesting this approach

1. Open up your Excel Workbook. Mine is Schedule.xls

2. Highlight the part you want displayed on your site. Give that range a name. (I named mine HTM)

3. Save the workbook.

4. Save the workbook again as a Web Page (Name your file, Select the range, Select Publish )

5. I created a folder on my server named HTML

6. Upload your web page to the folder you create. (Mine is Schedule.htm)


Open Joomla Backend

1. Create a new Menu Item

2. Select the Wrapper Type

3. Name the Menu and on the right enter the URL for your htm file. (Mine is http://95.0.74.132/schedule.htm)

4. Hint: File name is Case Sensitive. You may have to change the Width Parameter.


Save and Publish the menu.

Preview your site and you should be able to see your Excel Sheet.

Charlie Adams

Pages in category ‘Tips and tricks 1.5’

The following 44 pages are in this category, out of 44 total.

A

C

D

F

G

H

H cont.

I

L

M

O

P

P cont.

R

S

U