Reading HTML with Excel (was: SQL2JXL) -- PCTECH

Subject: Reading HTML with Excel (was: SQL2JXL)
From: John Yeung <gallium.arsenide@xxxxxxxxx>
Date: Wed, 2 Jul 2014 18:36:38 -0400
List-archive: <http://archive.midrange.com/pctech/>
List-help: <mailto:pctech-request@midrange.com?subject=help>
List-id: "PC Technical Discussion for IBM i \(AS/400 and iSeries\) Users" <pctech.midrange.com>
List-post: <mailto:pctech@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/pctech>, <mailto:pctech-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/pctech>, <mailto:pctech-request@midrange.com?subject=unsubscribe>

Copying to PCTECH list; if this thread continues further, it should
probably move completely to PCTECH, lest we incur David's wrath. ;)

On Wed, Jul 2, 2014 at 5:51 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

Has anyone tried getting Excel to read HTML? I'm too occupied with other
work to test this. I seem to recall that Excel can generate HTML. Can it
consume it?

Yes, it can both generate and open HTML files.

Depending on the "Excel-friendliness" of the HTML file, it will open
right up using the standard Open dialog. (For example, if the HTML
file was one that was written by Excel in the first place, then it
should open up just fine with no hassle.)

Do you have more specific questions or requirements?

John Y.

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.