January 18, 2018 1
MicroStation Workflow Using Axiom Microsoft Office Importer
Table of Contents
MicroStation Workflow Using Axiom Microsoft Office Importer ................................................................. 1
Introduction: ............................................................................................................................................. 1
Copying Data from Excel or Word: ........................................................................................................... 1
Setup .INI Settings Files: ............................................................................................................................ 3
Pasting the Data into MicroStation: ......................................................................................................... 3
Updating the MicroStation data: .............................................................................................................. 6
Introduction:
Axiom Microsoft Office Importer can import data from Microsoft Excel spreadsheets or Word
documents, for example: seeding schedules, girder schedules, storm water ID markers or general notes.
Changes made in Excel or Word can be updated very quickly in MicroStation.
Copying Data from Excel or Word:
There are templates available for various types of tables.
When the Excel or Word file has been formatted by the designer, confirm that the fonts and text sizes
are correct. The fonts and text sizes are:
Title of table – Lucida Sans Unicode – 12 point
Data subtitles – Lucida Sans Unicode (may be italic) – 10 point
Data input – Lucida Sans Unicode Italic – 10 point
The Excel spreadsheet templates have been set up to accommodate the height and width for the rows
and columns after font conversion in MicroStation. Adjustments to the column widths and row height in
the Excel file can be made if needed.
Add a “hard” return at the end of Word documents. New lines of text must be inserted above the
return. Text added after the return will not be “seen” by Axiom and the text must be re-pasted.