HTML to Excel Export need to have no color

Posted on 2011-04-29
Last Modified: 2012-05-11
I need to export this html report created by Excel back to excel from the web. The borders keep showing up, however the color on the page does not. The page is suppose to be just black / white and of course automatic formatting of the spacing for the data.

Anyone know how to do that?
Question by:cwells83
    LVL 5

    Expert Comment

    Hi Cwells,

    You have many options to do that
    (1) by using a free tool online to conevrt yr html to excel or doc or pdf.

    (2) Check the doc attached here , will explain you in details how you can import the html into excel.

    (3) check this sites , they have different vision to convert excel to html and vice versa ..

    Hope it helps,
    let me know.


    Author Comment

    We are exporting to Excel from HTML and have a function in place. I just wanted to know if there was an mso- function from excel code that you can use to override the colors on the webpage that transfer to the Excel, as it is to be kept all blck font at that point.

    LVL 5

    Assisted Solution

    If you only need to keep a certain format or b/w ( standard format) then you can use the STYLE option in Excel .. to do that :

    / Open your exported HTML in Excel and select all the sheet then > go to Format > Style.
    / in Style window , select Normal from dropdown menu .
    / Click ok.
    It will give you the option to make the whole page black/white and you select another style or whatever view you hve in yr mind :)

    I hope that's what you wanted.


    Accepted Solution

    We just put into a simulated excel sheet and grabbed session variable to produce results - formatting of color. All done ASP/HTML/VB and Java Script :)
    LVL 5

    Expert Comment

    Please review.
    First, i don't understand the solution which is provided by cwells83 ( the requester)
    Second, I gave all the possible solutions to answer the orignal requested question.
    Thrid, nothing was mentioned about ASP/HTML/VB and Java Script !

    Awaiting for your advise.

    Expert Comment


    You objected to a closure that was awarding you all 500 points. The initial close request was:

    The question was going to be closed as follows:
    Accepted answer: 0 points for cwells83's comment http:/Q_26986394.html#35506450
    Assisted answer: 500 points for wellous's comment http:/Q_26986394.html#35500612

    When involved in questions being closed in this manner, please read the "Close Request Pending" box carefully, and only post objections if the closure is truly unfair.

    Restarting the closure as originally requested by the author.

    Community Support Moderator
    LVL 5

    Expert Comment

    Thanks a lot :)

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now