Table With Excel (TWE) 1.0

Table with Excel (TWE) can help Excel users at all levels to deal with tables in Excel. The functions TWE provides can be broken to four groups. The first group includes four functions related to merging and splitting tables. They are Split a table, Extract a table, Stack tables and Join tables. The second group includes functions related to transposition of tables, that is, conversion of horizontal tables to vertical tables and vice versa. They are Table to list, List to table, and List to counts. The third group includes a function to handle duplicates, format columns and rename worksheets in batch. The forth group includes all other functions related to open Excel files, display Excel status, open the TWE PDF help file, show TWE version and copyright information, and quit the application.

TWE is developed based on Microsoft .NET Framework v1.1. It is a standalone Windows application. TWE application icon stays in the Windows system tray once it starts. All functions will be explained in detail in this manual. Most time one or two examples will be presented to demonstrate the functionality of each function.