Extracting data from Excel files

Spreadsheets are a ubiquitous business tool in the modern world, and there is a vast amount of critical data that resides in these common desktop files. As the tools are so commonplace and easy to use, spreadsheets are often the tool of choice for storing and manipulating all kinds of data. In this section, we'll look at a couple of ways to pull data from a spreadsheet. One of the most-used features of spreadsheets is the sheets functionality, which is the ability to add another page within the spreadsheet file. Sheets within a file may be closely related (for example, each sheet represents sales data for a given month) or may be less closely related (for example, a customers spreadsheet may contain customer data, ...

Get Getting Started with Talend Open Studio for Data Integration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.