Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Publish online - Excel data as Html

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Tue Jan 31, 2017 11:10 am    Post subject: Publish online - Excel data as Html Reply with quote

If you would like to publish your Excel data online as a web page, let's say as HTML file, then follow these steps:


Open the worksheet you want to save or select the range of your data that you want to publish.

Click on File or Microsoft Office button > click Save As

The 'Save As' window opens.

From Save as type: > select Web Page > type any file name

Look, in the image, above the Publish... button you have two options either to save the Entire Workbook or Selection: Sheet (for current worksheet). I will select the current worksheet only.






But if you select any range from your worksheet, then it would show you the selected range.






click the Publish button > the Publish as Web Page window opens.





Here under Publish as:

click on Change... (to give a title) > Set Title window opens (type any suitable title for your data)

click on Browse... to choose the location to save your web page

check or click the AutoRepublish every time this workbook is saved this will automatically republish your Excel data after each saving of your worksheet.

check or click the Open published Web page in browser this will open the web page immediately after the saving.

Click on Publish .






That's it Smile




*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.

For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group