Stats

  • Replies 5
  • Subscribers 161
  • Views 15423
  • Members are here 0
More Content

Excel File Reading Question

thewill2live

Hey Guys,

I'm trying to read in an excel file to get some data and display it on a GUI. I have been trying the following:

file = axlDMFileBrowse("MISC" nil)
print(file) ;DEBUG
if( axlSpreadsheetRead(file)
then
println("Successfully Read spreadsheet!") ;DEBUG
println(axlSpreadsheetGetCell(1,1)) ;DEBUG
)

with test.xlsx file and get this error:

E- (SPMHWB-110): Error importing XML file An exception occurred! Type:UTFDataFormatException, Message:invalid byte 1 (‚) of a 1-byte sequence..

I'm guessing this means that Allegro doesn't like .xlsx files, so I tried the same with a test2.xls file and got pretty much the same error:

E- (SPMHWB-110): Error importing XML file An exception occurred! Type:UTFDataFormatException, Message:invalid byte 2 (Ï) of a 2-byte sequence..
E- (SPMHWB-110): Error importing XML file .

Both times it dies on the axlSpreadsheetRead command. My temporary work around is to use .csv files and change to the axlSpreadsheetReadDelimited command which is working fine but I'd like to know what I'm doing wrong on the excel side as I would like to be able to support all 3 file types (xlsx, xls, and csv). Anyone have an idea where I went wrong?

Bonus question: Does SKILL have an exception handling method? I attempted to follow a tutorial for LISP exception handling using the "Condition" system but Allegro didn't like that when I attempted to run it. I'm hoping there something along the lines of the python try/except/else statement that will allow me to put some exception handling abilities into my program. Does this exist?

Parents

  • It is my understanding that .xlsx was the microsoft open XML-based spreadsheet (as opposed to .xls which is the older non-xml version). So if this is not true, can you give me an example of what file type IS supported by the axlSpreadsheet commands (aside from the .csv file)? 

    For the exception handling, thanks I'll take a look at that function.

Reply

  • It is my understanding that .xlsx was the microsoft open XML-based spreadsheet (as opposed to .xls which is the older non-xml version). So if this is not true, can you give me an example of what file type IS supported by the axlSpreadsheet commands (aside from the .csv file)? 

    For the exception handling, thanks I'll take a look at that function.

Children
No Data
Cadence Guidelines

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.