?
Solved

HTML to Excel Export need to have no color

Posted on 2011-04-29
8
Medium Priority
?
424 Views
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?
0
Comment
Question by:cwells83
  • 4
  • 2
7 Comments
 
LVL 5

Expert Comment

by:wellous
ID: 35497422
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.
http://www.coolutils.com/online-html-converter.php

(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 ..
http://www.mvps.org/dmcritchie/excel/xl2html.htm
http://designdetector.com/archives/05/07/HTMLToExcelTheEasyWay.php


Hope it helps,
let me know.

 html2XL.doc
0
 

Author Comment

by:cwells83
ID: 35499143
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.

Thanks
0
 
LVL 5

Assisted Solution

by:wellous
wellous earned 2000 total points
ID: 35500612
Cwells,
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.

Brgds
Wellous
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Accepted Solution

by:
cwells83 earned 0 total points
ID: 35506450
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 :)
0
 
LVL 5

Expert Comment

by:wellous
ID: 35508921
Objection,
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.
Brgds
Wellous
0
 

Expert Comment

by:_alias99
ID: 35714893
wellous,

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.

_alias99
Community Support Moderator
0
 
LVL 5

Expert Comment

by:wellous
ID: 35715654
Thanks a lot :)
Wellous
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

809 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