![Inline image 7](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDBZeYJ0Ch2dqUqvsLbxsUOgG6_Z3ph14m2Phlf9ecX8enSQ9Nzdh2gr8Np66sKjMx0Zd5u-2zV-gaR4QEDtrw-3CMrBrHYM2-aQl9XqZkKReJrmAJnL_X-30OYmg0-pnHSXPqUjznAsQZ/s640/VBA_Header_Andre_Luiz_Bernardes_013.png)
Este add-in serve para o Excel 2010 e o Excel 2013 e pode ser baixado aqui.
O Data Explorer abrirá uma nova opção no Menu e através dela poderemos importar e transformar uma ampla variedade de dados de fontes distintas. Além das fontes de dados padrão como o Microsoft Access, SQL Server e Arquivos de Texto.
O Data Explorer permitirá a importação de fontes tais como o Active Directory, Azure, OData e Hadoop.
Através deste post veremos mais um exemplo de com usar o Data Explorer.
2º Exemplo - Manipulating Data Feeds
Data Explorer has a mechanism to allow you to search for random web data that may be out there.
For example, suppose I wanted to know how many radio stations in Maryland are sports stations? I can find that information using Data Explorer.
.
I click on the Online Search command and put in my search term "radio stations maryland".
I immediately see a list of approximate matches. Clicking on one lets me see the data on my spreadsheet.
.
I like what I see so I call up the query window.
Here, I can choose to hide all but the Format column.
.
Next, I can Remove Duplicates.
.
Finally, I'll add a "Count of Rows" column to the table by using the Group By feature.
.
After confirming my changes, I get a data table that answers my question. There are 9 radio stations in Maryland that are sports stations.
This is unbelievably good stuff. With a few clicks, I searched the internet, found some base data, and manipulated it to suite my needs.
.
Tags: VBA, Data, Tip, Excel, Add-in, Data Explorer, Active Directory, Azure, OData, Hadoop,
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhU0rFC0g1bEoAXTFqfQcLlu3NssmweFvXr9nZVB5CqjnLz4spJfZvmBdI_IpeVlnnVLPnZQz0zD_jKNDRmfV2HHg3YKLg2eVAnRTYyfXncYlX0rU6Lv4qycd2tLaUO-RAWWaaA-98AvbmY/s640/VBA_Signature_Andre_Luiz_Bernardes_032b-722457.png)
Nenhum comentário:
Postar um comentário