topic Re: How to get specific cells values from a excel sheet to databases tables? in Talend Studio

How to get specific cells values from a excel sheet to databases tables?

Anonymous — Fri, 16 Feb 2018 15:03:41 GMT

Hi, I have a project management excel spreadsheet, where some cell values go to one specific table, some other values go to others, and so on. Is there a way I can get only the specific data to input in the tables?

For instance, cell B3 will only be load into one table of my DB.

Re: How to get specific cells values from a excel sheet to databases tables?

TRF — Fri, 16 Feb 2018 15:23:38 GMT

Hi,

You should have a look at tFileExcel-Components from Talend Exchange.

Hope this helps.

Re: How to get specific cells values from a excel sheet to databases tables?

Anonymous — Fri, 16 Feb 2018 15:24:30 GMT

There are components on the exchange that might help with this. If they dont make it easy, you would need to set up a few filters to isolate each of the "special" cells (row filter to choose the row, then a tMap to chose the column)