How to read xls file format and inside a content is html format.

Anonymous — Sat, 16 Nov 2024 03:44:20 GMT

Hi,
Iam currently facing a problem while reading data from .xls(Excel) file. The actual problem is, I am getting the .xls source from downloading from a report and it is saving the file in .xls format but the document content are in HTML format, once I open and Save as the same file without changing it in the same format, do change nothing. Am able to read the same file, I want to read the file without resaving it at the first time, how do I read the .xls file having HTML content from Talend tool, Thanks in advance, please help me to out from this.

Re: How to read xls file format and inside a content is html format.

Anonymous — Mon, 13 Jan 2020 06:15:37 GMT

Hi
You can take a look at the tHttpTableInput component and try it, this Component extracts HTML-Tables from a given URL. I am not sure if it could fit you need.
It is a custom component shared by community user on Talend Exchange.
https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F128&pi=marketplace%252F1%252Fproducts%252F128%252Fitems%252F163

Regards
Shong

topic How to read xls file format and inside a content is html format. in Talend Studio

How to read xls file format and inside a content is html format.

Re: How to read xls file format and inside a content is html format.