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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewIT / Software Engineering ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 PrewIT / Software Engineering ConsultantCommented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
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 ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
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 ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
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 PrewIT / Software Engineering ConsultantCommented:
Anyway, that is probably another question I need to post here.

Agreed.


»bp
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
HTML

From novice to tech pro — start learning today.