Gegprifti Add In for Excel

From Software Infocard Wiki
Jump to: navigation, search
Infocard

Target Platform: Windows
Version: 1.0
Release Date: March 1, 2015
License: Shareware
Price: USD 2.99
Publisher: Gegprifti
Product Web Site: [External Link]
Match tables, get file names from folder.
2.20 Mb

Description by the Publisher

It is an Excel Add-in that consists of two modules. The 'Join tables' module is specific in querying tables and performing results like in a database environment. This functionality is usually performed by the vlookup function in Excel. The 'Join tables' module enhances the work on querying tables by presenting an intuitive graphic user interface which makes it an easier process. With no need for writing functions or SQL codes, you can get query results in just a few seconds. The query results you can generate are like:
- All rows from both tables as long as there is a match between the columns in both tables.
- All rows from the left table, with the matching rows in the right table. The result is NULL in the right side when there is no match.
- All rows from the right table, with the matching rows in the left table. The result is NULL in the left side when there is no match.
The 'Get filenames from folder' module will help you write filenames in Excel cells. One can write up to 1,048,575 + 1 filenames from the specific folder and/or subfolders into Excel cells. Also you can get extra information along with the filename, such as full path filename, full path directory name, parent directory name, etc.

Limitations in the Downloadable Version

Can export up to 100 query result rows

Product Identity

Unique Product ID: PID-170011D1A698

Unique Publisher ID: BID-D6009146F598

[Gegprifti Add In for Excel PAD XML File]

Category