Editing Tables in Excel are not putting the data in Columns.

Editing Tables in Excel are not putting the data in Columns.

Editing Tables with Excel and not column mapping correctly

If we take the Materials.qlt located in the \Table\ folder. And drag it and drop it into Excel for editing with the advanced filter methods.

When we drag the file into Excel and get this result:



This is a result of the Materials.qlt being in UniCode format (which is specific to Chinese language characters because they are in UniCode not ASCii) Most customers will find it easier to be in ASCii format instead, and editing with Excel will be more seamless.

NOTE: 



Or in the registry like this:



Now to change this you need to be able to open the Table again in the Old Table Editor*, which is located in CabMaster in the \Utils\ Folder.

Once you have then opened the table with the Old TableEdit.exe* you can edit the Comment section to remove the strange looking characters (* can also be known as “TableEditV9.exe”)



So now once you have removed the strange looking characters which are required to let the table understand that it is in UniCode format, it will default back to ASCii format, which should also be changed in the registry.

Now if you drag this file into Excel you will see the column layout easier.


TIP: Click the attachment to download this HowTo to our desktop as a .pdf

TableEditV9 is not currently included in newer releases

    • Related Articles

    • Custom Machining Tables Explained

      Custom Tables: Rows & Columns Custom Tables are very useful additions to the capability of CabMaster, allowing you to develop your own custom machining and apply it to various parts of cabinets. Where can I find my custom table folder? From within ...

    • Drawer Runners - Creating and Editing

      This Knowledgebase article explains the use of drawer runners and their associated tables.  See the attached PDF document. In this document: How to create a new drawer runner. How to modify existing drawer runners. Understanding all options related ...

    • Importing Data into CabMaster Software

      Attached is a simple Excel file that could be used to try this. Importing Data into CabMaster Products CabMaster and its associated products have the ability to import a wide variety data directly to the program, in this document we will outline how ...

    • Customising a cabinet in CabMaster Software

      Customise a Cabinet Cabinets can be customised before or after they are placed on the drawing. For comprehensive discussions see also the following: CabMasterPro Help topics [F1] : Topic Discusses Cabinet Properties Different ways to select cabinets ...

    • How to use Customized Shaker Doors Tables

      How to Use Customized Shaker Doors Tables Step 1: Firstly you will need to make sure your customized Shaker tables are located in the correct location for CabMaster to read the System Tables, this will be found in the CabMaster folders ...