How can I convert an Excel file to html for viewing online?

I have an Excel I want to upload to my website but in html format. The layout is very simple with one tab only and not much contents (an overview of my previous projects only).

Can I easily and quickly convert this to html and then upload to my website's public_html?
LVL 1
hermesalphaAsked:
Who is Participating?
 
Bill PrewCommented:
Have you tried doing a Save As and then selecting HTML format for the output file?  That should give you a file you can upload to the web server and view there.



»bp
0
 
hermesalphaAuthor Commented:
Thanks, the layout was perfect when I did as you suggested. But two things:

1. I get this message:
Internet Explorer restricted this webpage from running scripts or ActiveX controls.
And even when I click on
Allow blocked content
it takes a very long time before I can scroll on the page. Maybe only my IE settings.

2. I get a 404 - File not found even after I've uploaded the file and entered the correct URL (I click on the file from the index page where it says Parent Directory in my web browser).
0
 
Bill PrewCommented:
Yes, you will get that warning in IE.

As far as the 404 you need to also upload the directory with a name that starts with the HTML file name.  It will be in the same folder you saved in and with have "_files" on the end.


»bp
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Ryan ChongCommented:
Can I easily and quickly convert this to html and then upload to my website's public_html?
so you got 2 tasks here:
1. convert Excel content to HTML

to do this, try record a macro and you would get something like below to customize with:

Sub Macro1()
'
' Macro1 Macro
'

'
    ChDir "D:\SomePath"
    ActiveWorkbook.SaveAs Filename:="D:\SomePath\Book1.htm", _
        FileFormat:=xlHtml, ReadOnlyRecommended:=False, CreateBackup:=False
End Sub

Open in new window


2. upload to your website as a public html

to do this, we probably can use a FTP account to upload your file from backend.

IF you want to automate these 2 steps as a single click-and-go feature, then you probably need to think whether you want to do it locally or develop a web-based solution. A lot of approaches we can think of here
0
 
hermesalphaAuthor Commented:
Thanks, would work for me. I got help from the website company also, they wrote some script, don't know where they put it, probably in some folder under public_html.

I can easily get my Excel up on the website now, but not so easy with my PDF. I tried first to convert to image, but the image is not very good and partly not possible to read the text. However, I need the PDF as image also for inserting in my e-mail signature. Anyway, that is probably another question I need to post here.
0
 
Ryan ChongCommented:
PDF is not a good medium to store images, not mentioning that it's not efficient to convert PDF to images. so, you probably need to get the images with higher resolution from your source provider?
0
 
hermesalphaAuthor Commented:
The PDF is not image from the beginning, it is readable text. But I need to get it to image so I can include it in my e-mail signature.
0
 
Ryan ChongCommented:
The PDF is not image from the beginning, it is readable text. But I need to get it to image so I can include it in my e-mail signature.
noted your requirement, since this is different from what you have been initially asked, i would suggest you to create a new question to address this issue.
1
 
Bill PrewCommented:
Anyway, that is probably another question I need to post here.

Agreed.


»bp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.