Stats

  • Locked Locked
  • Replies 4
  • Subscribers 144
  • Views 16473
  • Members are here 0
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to open and read excel.xlsx file in virtuoso using SKILL

Miguel V

Hello,

I'm trying to open an excel xlsx file in Virtuoso using SKILL.  I have found several "axl" functions that are supposed to help accomplish this such as axlHttp() but all of these function return the error that they are not found. For example:

axlHttp("sample.xlsx")
*Error* eval: undefined function - axlHttp
>

axlDMFileBrowse("sample.xlsx")
*Error* eval: undefined function - axlDMFileBrowse
>

Is there an add on that I need or what else could I be missing, or are there other function that I can use?  infile() seems to work but I need to look at specific worksheets within the excel file.

Thanks,

Miguel

Parents

  • Hi Andrew,

    I thought so since I couldn't find anything in the Virtuoso documentation.  I was trying to take a list of pcells in a spreadsheet and automatically generate a layout with the given cells based on the x,y location specified and the listed parameters.  I got it to work by saving the excel spreadsheet as a CSV file and then just used the infile() function to open and read it and seems to be doing just fine.  I was hoping I could do this like in Allegro because there can be multiple sheets in one excel file.  Converting the .xlsx file to CSV means that I have to convert every single worksheet to CSV and then iterating through all of them.  

    Miguel

Reply

  • Hi Andrew,

    I thought so since I couldn't find anything in the Virtuoso documentation.  I was trying to take a list of pcells in a spreadsheet and automatically generate a layout with the given cells based on the x,y location specified and the listed parameters.  I got it to work by saving the excel spreadsheet as a CSV file and then just used the infile() function to open and read it and seems to be doing just fine.  I was hoping I could do this like in Allegro because there can be multiple sheets in one excel file.  Converting the .xlsx file to CSV means that I have to convert every single worksheet to CSV and then iterating through all of them.  

    Miguel

Children
No Data

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.