• Skip to main content
  • Skip to search
  • Skip to footer
Cadence Home
  • This search text may be transcribed, used, stored, or accessed by our third-party service providers per our Cookie Policy and Privacy Policy.

  1. Community Forums
  2. AWR Design Environment
  3. Importing excel file into AWR

Stats

  • State Verified Answer
  • Replies 2
  • Subscribers 18
  • Views 2527
  • Members are here 0

Importing excel file into AWR

MTalha
MTalha 10 months ago

I have some data in Excel file that I want to import in AWR to plot it. 

I save the file as .csv file and after importing it into AWR, the following error apears

" 0 Column heading expected, must be in name(type,units) format: Line 1 in file: new"

  • Sign in to reply
  • Cancel
  • OscPn
    +1 OscPn 10 months ago

    I guess this is coming due to column heading format. The column headings section, if present, provides additional information about the data columns of the file. If this section is present, you must specify a column heading for each data column. A column heading has the following format:

    [name]([type][,units])

    where [name] is the name of the column, [type] is the type of data and [units] is the units for the data. Each of the parts is optional, although the "(,)" and "," punctuation are required.

    To know more check the help page:

    AWR Design Environment User Guide > Data Files > Data File Formats

    • Cancel
    • Vote Up +1 Vote Down
    • Sign in to reply
    • Reject Answer
    • Cancel
  • MTalha
    +1 MTalha 10 months ago in reply to OscPn

    Thanks, this gives me the cause of the error.

    The format must be checked inside AWR and the heading must be exactly like this

    Excel usually adds (" ") for each word which AWR doesn't understand or adds unnecessary , between each value.

    • Cancel
    • Vote Up +1 Vote Down
    • Sign in to reply
    • Reject Answer
    • Cancel

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.

© 2025 Cadence Design Systems, Inc. All Rights Reserved.

  • Terms of Use
  • Privacy
  • Cookie Policy
  • US Trademarks
  • Do Not Sell or Share My Personal Information