Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
AutoPIPE
  • Product Communities
AutoPIPE
AutoPIPE Wiki "Unable to Import the Excel File..." Messages displayed in AutoPIPE
    • Sign In
    • -Pipe and Vessel Stress Analysis - Wiki
      • +ADL PIPE
      • -Bentley AutoPIPE
        • +- General Information about AutoPIPE
        • +- NEW User Guide for AutoPIPE
        • +- Technical Support - AutoPIPE
        • +Batch Processing, ITS, and ATS using AutoPIPE
        • AutoPIPE QA&R program
        • +Download - Install - Release Notes - AutoPIPE
        • +File / Model Management using AutoPIPE
        • +General - AutoPIPE
        • +Graphics - AutoPIPE
        • +Grids (Input & Results) - AutoPIPE
        • +Import and Export - AutoPIPE
        • +Known Issues in AutoPIPE (Enhancements, defects, etc..)
        • +Libraries - AutoPIPE
        • +License AutoPIPE -
        • +Loads and Load Sets - AutoPIPE
        • +Localization (Non-English Language) - AutoPIPE
        • +Modeling Approaches in AutoPIPE
        • +Modules (i.e. Flange Analysis, Spring Hanger Selection, Rotating Equip, TTA) in AutoPIPE
        • +Piping codes - AutoPIPE
        • +Post Processing - AutoPIPE
        • +Printing - AutoPIPE
        • +Reports - AutoPIPE
        • Security
        • +Settings - AutoPIPE
        • +Stress Isometrics - AutoPIPE
        • +Technology Productivity Capabilities
        • -Warnings, Errors, Crashed, Confirm, etc.. messages in AutoPIPE
          • "1 Interrupted Action" messages displayed while coping AutoPIPE file, why?
          • +"Alert" Messages displayed in AutoPIPE
          • +"AutoPIPE Licensing" Messages displayed in AutoPIPE
          • +"Autopipe.exe" Messages displayed in AutoPIPE
          • +"Beam Section" Messages displayed in AutoPIPE
          • +"Bentley AutoPIPE" Messages displayed in AutoPIPE
          • +"Bentley Systems, Inc" Messages displayed in AutoPIPE
          • "Bentley.lictransmit for Windows has stopped working" message appears when using AutoPIPE program, why?
          • +"Blank" Messages displayed in AutoPIPE
          • +"Bolts*" Messages displayed in AutoPIPE
          • +"Confirm" Messages displayed in AutoPIPE
          • +"Error" messages displayed in AutoPIPE
          • +"Flange*" Messages displayed in AutoPIPE
          • +"Incorrect Data" messages displayed in AutoPIPE
          • +"Intel(r) Visual Fortran run-time error" messages displayed in AutoPIPE
          • +"Invalid Format" messages displayed in AutoPIPE
          • +"License Management Tool" Messages displayed in AutoPIPE
          • "Message from SofTrack" Messages displayed in AutoPIPE
          • +"Microsoft .NET Framework".. messages displayed in AutoPIPE
          • "Microsoft Visual C++ Runtime Library" message appears in AutoPIPE
          • "New Case Failed" Messages displayed in AutoPIPE
          • +"Note" Messages in AutoPIPE
          • +"PCFin" Messages displayed in AutoPIPE
          • +"Report Generator Error" Messages displayed in AutoPIPE
          • +"Reverse Segment" Messages displayed in AutoPIPE
          • +"SACS Export Error" messages displayed in AutoPIPE
          • +"Script Error" messages displayed in AutoPIPE
          • +"Text Node Editor" Messages displayed in when using OPIM from within AutoPIPE
          • "Unable to Import the Excel File..." Messages displayed in AutoPIPE
          • +"Warnings" Messages displayed in AutoPIPE
          • +Application Crashed or Freezes - AutoPIPE
          • AutoPIPE Report Viewer has stopped working
          • +Blank Messages displayed in AutoPIPE
          • +Issues that occur when exporting files from AutoPIPE
          • +Issues that occur when generating Reports from AutoPIPE
          • +Issues that occur when importing PXF files into AutoPIPE
          • +Known errors that occur when Installing / Uninstalling AutoPIPE
      • +Bentley AutoPIPE Nozzle (WinNOZL)
      • +Bentley AutoPIPE Vessel (powered by Microprotol)
      • +Bentley PlantFLOW
      • +Bentley PULS
    • Multi-lingual announcement from BENTLEY TECHNICAL SUPPORT.
    • Working at Home with AutoPIPE
    • +AutoPIPE Brand Learning Resources
    • +Attend a live meeting with an AutoPIPE Analyst

     
     Questions about this article, topic, or product? Click here. 

    "Unable to Import the Excel File..." Messages displayed in AutoPIPE

    Applies To
    Product(s): AutoPIPE
    Version(s): ALL;
    Environment: N/A
    Area: Import
    Original Author: Bentley Technical Support Group
    Date Logged
    & Current Version
    Nov. 2016
    10.01.00.09

    Problem:

    The following is displayed when using AutoPIPE

    ---------------------------
    Unable to Import the Excel File
    ---------------------------
    Excel Imposed Support Displacement data could not be inserted into the model. For details View the error log.
    ---------------------------
    OK
    ---------------------------

    Why does it appear and What should i do now to avoid it?

    Solution:

    This message is displayed when a problem occurs during importing of a specially formatted Excel file using " Import Imposed Displacements" command

    There are a number of reasons why the import may fail but one or more of the following listed items may resolve the issue. This is an iterative process. 

    a. Be sure that MS Excel is installed on the computer. Suggest v.2007

    b. Save Excel file back to "Excel 97-2003 Workbook (*.xls)" format

    c. The imported Excel file cannot have any blank Translation or Rotational values. If the value is Zero enter a Zero number in the blank spot.  

    Now try and import the Excel file, the message above should not appear. 

    See Also

    Warnings, Errors, Crashed, Confirm Messages in AutoPIPE

    Bentley AutoPIPE

    • Excel
    • Unable to Import the Excel File
    • AutoPIPE
    • message
    • Impose Support Displacement
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Tue, Nov 29 2016 2:01 PM
    • Mike Dattilio Last revision by Bentley Colleague Mike Dattilio
    • When: Tue, Nov 15 2022 1:10 AM
    • Revisions: 5
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies