|
converting excel files into clean web pages
Sun, 5 Mar 2006 11:06:16 -0000
soc.genealogy.computing
previous
Jill...
|
I am collecting ! a number of excel files of census transcriptions, BMD data
etc which I would like to include on to a website about the area
Does anyone know a clean way of doing this that does not involve hundreds of
| | | etc
Or that inserts the tags automatically?
I am looking for simple clean pages of information - preferably searchable
Joe Makowiec...
|
The short answer is that Excel will export HTML. I don't have a copy
here to check, but I seem to recall that there are two HTML export
options - one includes all kinds of cruft that Excel would need to
recreate the file as a spreadsheet; the other exports fairly clean
HTML. Be careful with this one; Excel's proprietary HTML is awful.
Jill...
|
that is what I found -- hence my question :~)))
|
Other options:
- Some HTML editors will import a CSV file, which Excel can also
export, as a table. I use DreamWeaver (although I'm a web developer by
profession, and DW isn't cheap). I've heard 1stPage recommended; it's
free:
Jill...
|
I use Homesite - I will look
|
As is Composer, which comes with Mozilla:
If your hosting supports databases, that's also an option, though it
requires some programming.
Jill...
|
by web-search
singhals...
|
No matter who generates, there will be hundreds of | |
| in there if you want columns.
I've simply created extra columns in the right place, typed the
| | stuff on the first row, then copied it to the
end of the column. Save. Print-to-file.txt rename file to .htm and
away we go. Letting Excel do it puts in all those nasty font-calls for
Jill...
|
Now that is blooming cunning
singhals...
|
If there's an easy way to do it, I find it. (g)
Note that | can go in ONE column and so can |
Robert G. Eldridge...
|
I actually use the method you described to maintain the Members
I do however skip the save as text step by directly copying the data
from Excel and pasting between | and in the existing
.html file, after deleting the existing content that I'm updating.
Then it's just a matter of doing a search/replace in the text editor
to replace all the tabs, added by the copy from Excel, with nothing.
I use UltraEdit but any decent text editor will do.
Note I use content so that the headings are at the top of each
page when printed from modern Web browsers (as distinct from operating
system components that are not proper Web browsers such as IE).
Whilst talking about editing .html files does anyone know if there is
some setting or otherwise in Word so that it will open a .html file as
text instead of rendering it as Web content. Surely there must be some
other option to changing the file name to .txt and then back to .html
for people who want to use Word as a text editor.
Joe Makowiec...
|
My first reaction, and I'm not trying to be wise, is why would anybody
want to use Word as a text editor?
Robert G. Eldridge...
|
The situation arose when I created a web page for my partners
genealogy where the content is done using formatted text.
I thought she could use Word, as she was used to using it, for
maintaining the content, especially as Word has a show/hide
spaces facility which is handy when using preformatted text with a
fixed pitch font.
|
If it's for search/replace capacity, there are a number of vi(m) ports
for Windows; if they're done right, they allow for search/replace using
regular expressions. Some will even do code highlighting.
Robert G. Eldridge...
|
As I know as use UltraEdit myself.
I was just surprised that Word didn't open what is essentially a text
file as text but, as is the want of a lot of Gatesware, tries to be
too clever by half and opened the file as a Web page.
singhals...
|
You'd be surprised how many people actually like that. I'm not among
'em, but an awful lot of folks wanted that so they could do WYSIWYGs.
Steve Hayes...
|
Well it is useful if you want tom save an HTML file as a word processing
documennt.
|
|
|
Denis Beauregard...
|
There are much more Word users than vi users :o)
And I think emacs is less ported but easier to use.
For multi-file editing and to work on many html files at the time,
I prefer to use brief which is an old DOS text editor with
regular expressions. I presume when I will switch 100% to linux,
I will use emacs to replace brief.
Leif B. Kristensen...
|
For the vi/emacs-challenged Linux users, there's a wonderful editor in
KDE called Kate (KDE Advanced Text Editor). Former Windows users will
feel immediately at home here.
When I'm forced to do editing in Windows, I'm using Edit Plus
Dale DePriest...
|
There is a perfectly good emacs for windows. I use it a lot.
Leif B. Kristensen...
|
Then you're probably not among the emacs-challenged of us ;-)
For my part, I became fed up with the Ctrl-Shift-Twiddlestick command
paradigm way back when I moved from WordStar to WordPerfect, and had to
relearn everything about how to edit a document. I've tried emacs
several times since around 1990, and every time I've went away with the
feeling that life is too short to learn how to handle this beast.
Dale DePriest...
|
You no longer have to do that if you don't want to. Emacs for windows
now has drop down menus and all the other bells and whistles.
|
|
|
. For 30 bucks, it's a very capable editor.
|
|
|
|
each cell. :(
next
|