This command will Import an existing Excel® XML Spreadsheet into a SpecsIntact Formatted Table.  

 

Icon Indicating StopBefore attempting to Import an Excel® Spreadsheet verify the file extension is XML not XLS.  SpecsIntact can only import XML files.  If the file is an XLS Workbook, it must be saved as an Excel® XML Spreadsheet or Excel® XML Spreadsheet 2003 before continuing.

 

Icon Indicating Important Information To NoteIt is important to understand the format of the Excel® XML Spreadsheet will determine how well the Table imports into SpecsIntact.  Make sure the spreadsheet is meticulously organized and formatted.  Illustrated below is an example of a spreadsheet that can be a potential formatting problem when imported into a SpecsIntact Table.

 

Example:  Formatting that can cause adverse results when imported.

 

 

Example: Suggested format changes after Unmerging Rows and Deleting Unused Columns as illustrated above.

 

 

Icon Indicating Important Information To NoteSpecsIntact v4.3.0.835 will import spreadsheets containing up to 25 columns and 200 rows. With later versions the number of rows were increased to 400 rows.  It is best practice to setup the Table with the exact amount of columns and rows prior to importing the new table.

 

Icon Indicating StopTables containing 25 columns will be extremely small and difficult to read as it must fit the SI Editor's margin settings, which only provides approximately 6 1/2 inches of workable space.

 

  How To Import An Existing Excel XML Spreadsheet Into A SpecsIntact Section:

 

 

The data contained within this file has now been imported into the SpecsIntact Formatted Table.

 

Icon Indicating Important Information To NoteSome minor adjustments to the format, column width and row height may need to be done once the Excel® XML Spreadsheet has been imported into the SI Editor.  

 

Icon Indicating Helpful HintSpecsIntact tables have similar characteristics to Microsoft Worksheets. Table Editing tips can be found on the Table | Insert | Table topic.

 

Icon Indicating StopExcel uses Floating Point Arithmetic which causes unexpected results when saved to XML and imported into SpecsIntact (illustrated below).   In order to correct this, you can use the SI Editor's Search and Replace feature to search on a particular value and replace it with the correct one.