View previous topic :: View next topic
|
Author |
Message |
Revathy Mourouguessane
New User
Joined: 25 Jul 2012 Posts: 5 Location: INDIA
|
|
|
|
Hi Team,
I have a requirement to read .xlsx file in a PL/I program. I was successful in getting the .xlsx but when I try to read the content it is in unreadable form. Could anybody help me to convert the file into readable form. I don't have any knowledge in assembler but I would be happy if I get any help even as an assembler code.
The file encoding is in UTF-8 format, type - text/plain and as an dime attachment.
Please let me know if you need any details.
Thank you |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
isn't an .xlsx file, a Microsoft proprietary Excell Worksheet format?
how did you transfer the file to the mainframe?
binary? any conversion? |
|
Back to top |
|
|
Revathy Mourouguessane
New User
Joined: 25 Jul 2012 Posts: 5 Location: INDIA
|
|
|
|
Hi,
There's an internal tool that gets the .xlsx file into host and the format is in binary.
Thank you! |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
There's an internal tool that gets the .xlsx file into host and the format is in binary. |
work with the people who designed the tool
googling for xlsx returned quite a few hits dealing with its conversion to other formats
a simpler approach might be to convert the excel sheets to CSV on the PC
and upload the CSV file to the MF in text format.
after that everything might be easier!
do not expect too much help here trying to decode the XLSX format! |
|
Back to top |
|
|
|