miércoles, 25 de abril de 2012

Merge Tables Wizard for Excel


Say, you need to compare two Excel spreadsheets, find the updates or new columns and get them to your main table for further analysis. The problem is it's too time-consuming and doesn’t guarantee that all the important data are included.

MergeTables Wizard for Microsoft Excel is a handy alternative to Excel Lookup and Vlookup functions that will automatically compare 2 sheets you specify as master and lookup, uncover matching rows and update your first table. All it takes is five steps and less than a minute.
In addition, you can use one or several columns as matching criteria, add new columns to the main table or update the existing ones, highlight or filter the modified entries.  

How Merge Tables Wizard works

Forget about manual checking of two Excel tables for matching data!

  •        You just select the Master Table - the one that you want to update.
  •        Choose the Lookup Table where the add-in will look for the new data.
  •        Pick matching columns or those with common index fields in both spreadsheets.
  •        Choose the columns to be updated or added to the main table. 
  •        Adjust the merge results using additional options on the last step.

Finishing touch to the merge results

There are some additional options that you may find useful. For matching rows this tool will set the background color of updated cells, update only empty cells in your main table or update only if cells from the lookup table contain data.
Also you can tweak the following options for non-matching rows: Clear background colors of Non-updated cells or Add non-matching rows to the end of the Master Table.
You can also mark the merged data by adding a status column to the master table that will indicate rows as: Updated, Non-updated or New row. Take the advantage of this option if you want to have this information at hand even after sorting the rows or changing the layout of your worksheet.

Use Merge Tables Wizard to join data from different sources, find and merge matching data from two Excel tables in seconds.

viernes, 20 de abril de 2012

Add-in Express for Microsoft Office and .net

Add-in Express for Microsoft Office and .net is the all-in-one platform for developing any types of Microsoft Office extensibility projects with minimal coding


Add-in Express allows developers to easily create professional extensions for Microsoft Office such as COM add-ins, smart tags, real-time data servers, Excel Automation add-ins and XLL add-ins. It provides special components for integrating applied code with all applications from the Microsoft Office family including Outlook, Word, Excel, Visio, Access, PowerPoint, MapPoint, FrontPage, InfoPath, Project and Publisher.


Add-in Express equips you with a strong solution architecture and coherent programming model complemented by a combination of .net components, designers and deployment tools that will free you from a nightmare of tedious coding and ensure a quick and perfect result.


Using Add-in Express visual designers, wizards, modules and components you can create version-neutral, secure, isolated, deployable and automatically updatable Office extensions with your own toolbars, menus, ribbons, form regions, task panes and keyboard shortcuts in minutes. All available Office versions from 2000 to 2010 and Office suites from Student to Enterprise are supported.


Key Benefits

  •  Visual designers instead of coding. You use visual designers to customize Office menus, toolbars, ribbons, task panes, forms, windows, regions, option and property pages, to add custom and customize built-in toolbars, main and context menus for all Microsoft Office applications. 
  • Version-neutrality. You develop one extension for all available Office versions (2000 - 2010) and Office suites (Student, Home, Standard, Professional, Professional Plus, Ultimate, Enterprise). No need to create different projects for different Office versions since Add-in Express supplies you with a version-neutral core and Office primary interop assemblies (PIAs). 
  • Effective project architecture. Add-in Express provides you with ready-to-use solution templates that accumulate our long-term experience in development and deployment of Office solutions. The Add-in Express architecture makes your Office solutions secure, isolated, managed, deployable and updatable with your minimal efforts. 
  • Advanced Outlook customization offers a unique GUI for your Outlook plug-ins. Use Advanced Outlook Forms and Views Regions to embed custom .NET forms into Outlook views and forms. Populate Outlook windows with any built-in or third-party controls, including e-mail, task and appointment windows, Reading pane, Navigation pane, To-Do bar, etc. Completely replace Outlook views with your .NET forms (as Outlook Today), add you own property pages to Outlook folders, build your own Outlook Navigation Pane shortcuts and do lots of other things to extend the Outlook GUI. As a result, you get full-featured Outlook plug-ins that work on all Outlook versions, across 2000 through 2010. 
  • Special features for extending the Excel GUI. You can build your own real-time data servers and new worksheet functions for Excel 2000 – 2010. Add-in Express supports two ways of creating custom worksheet functions, using Automation add-ins and XLL add-ins. 
  •  Advanced Office task panes for Microsoft Office 2000 - 2010. Being more flexible than native Office task panes, the Advanced Task Panes let you customize the main Excel, Word and PowerPoint windows with native .NET forms that can be resizable, hidden, minimized (like the Outlook To-Do Bar) and dragged between task pane docks. 
  • Easy deployment. With Add-in Express the deployment of your Office extensions is so easy that you forget about it. Each Add-in Express solution contains a setup project with all necessary prerequisites. Several technologies and installation types to deploy and redeploy your solutions are supported: Windows Installer projects, ClickOnce publishing and MSI based web-deployment. 
  • True RAD - you write applied code only. Add-in Express is completely based on the Rapid Application Development approach and reduces the time you used to spend on Office extensions development at least by half. You write applied code only, Add-in Express does everything else. 


Main Features
  • Add-in Express is fully founded on the Office extensibility technology and extends it with unique features which make Office development fast, easy and effective. You use visual designers and special components to:
  • Add custom and customize built-in toolbars, main and context menus with your controls, items and sub-menus for all Microsoft Office 2000 – 2003 applications. 
  • Add new or customize existing tabs for Office 2007 and Office 2010 Ribbon UI. 
  • Build the Quick Access Toolbar and the Office Menu for Microsoft Office 2007. 
  • Build the Backstage View for Microsoft Office 2010. 
  • Add any .NET controls onto Office toolbars. On all versions of Outlook, Word, Excel and PowerPoint, you can place any built-in or third-party controls on Office toolbars. Your own toolbars can be populated with grids, tree views, list views, user controls, forms, etc. 
  • Develop in one project smart tag libraries with multiple, shared or dynamically created recognizers. 
  • Program Excel real-time data servers and tree-viewed real-time data topics. 
  • Develop new Excel worksheet functions (UDF). 
  • Create Excel Automation add-ins and XLL add-ins. 
  • Access any Office objects, their properties and methods, handle their events.
Supported IDEs
  • Visual Studio 2005, 2008 and 2010
  • Visual Basic Express 2005, 2008 and 2010
  • Visual C# Express 2005, 2008 and 2010
Related Links