/    Sign up×
Community /Pin to ProfileBookmark

Taming HTML files generated by Excel

Hi!
I want to add horizontal row highlighting to the html table generated by Excel. I wonder if this is possible in the KNOWN UNIVERSE of human knowledge?? Sometimes I think we have reached the edge with the Excel output). Please take a look and let me know if it is possible to replicate the highlighting shown on the good.html file – BUT PRESERVING THE ORIGINAL LAYOUT OF EXCEL GENERATED HTML.
Dave

here is the more or less good one: jsfiddle.net/1q7yqbdc
and here is the originally exported html file from excel: jsfiddle.net/h5e6kjwa/1

to post a comment
HTML

2 Comments(s)

Copy linkTweet thisAlerts:
@Douglas_WilliamFeb 17.2017 — Hi daverich777,

Format Your "Excel" appropriate Cells"/"Columns" to the desired and then "Save as ..." [i](*.html)[/i]

Excel ... is an priority-environmental animal [coded] unto about-it[MicroSoft]self ... Every[thing] has its benefit in some form or fashion. The coding(s) that mimic in a WYSIWYG Application/Program Generated HTML should code-to the presentation on the display screen of the "Excel". In uSoft Excel one should/would expect the "Save as .." Function to allow for the [i]saving[/i] to be able to "Save as ..." "Type": [url=]]Web Page (*.htm, *.html)[/url].

Once created, now, just appropriately incorporate the [i]saved[/i] (new) WYSIWYG Codings into the document(s) you wish applicature to occur.

If your web is based on other uSoft tendencies you may desire to open your Word up and incorporate the Excel into the [I'm assuming your base web page is of uSoft Origin as well here] Word document (That I'm assuming your web page is created [from]in) and, then, once situated in the Word presentation, "Turn The Word" document into your HTML Web Page that now contains the Excel as WYSIWYG Word's HTML Generation should have the adaptive fit in publication display.

If you don't have the Master "Excel" file you would have to create a CSS "Class" or "ID" in the webpage's "head" section (preferable creating the [i]In-Page[/i] CSS Styling just before the [i]Closing Tag[/i] of the "head" section). In this [i]CSS Styling[/i] section place the appropriate "alt" class/id for appropriate high-lighting scheme(s). Once, then, that occurs one needs to go throughout the code to identifiy individually all the desired to be highlight and place a
<i>
</i>...
&lt;style&gt;
.altred{
color:red;
}
.altwht{
color:white;
}
.altblue{
color:blue;
}
&lt;/style&gt;
&lt;/head&gt;

<i> </i>&lt;body&gt;

"altred" where appropriate highlighting is desired. An example below (accomplished) with the use of
<i>
</i> &lt;span class="altred"&gt;35&lt;/span&gt;


Hope this helps you out.

- Douglas
Copy linkTweet thisAlerts:
@NogDogFeb 21.2017 — Or save it as a CSV file, then use the the programming language you prefer to read it and output it the way you want, instead of the way Excel wants. ?
×

Success!

Help @daverich777 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 4.26,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...