Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Converting UTF-8 format to text/ASCII format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PL/I & Assembler
View previous topic :: :: View next topic  
Author Message
Revathy Mourouguessane

New User


Joined: 25 Jul 2012
Posts: 5
Location: INDIA

PostPosted: Fri Sep 14, 2012 1:43 pm    Post subject: Converting UTF-8 format to text/ASCII format
Reply with quote

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
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri Sep 14, 2012 2:15 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Revathy Mourouguessane

New User


Joined: 25 Jul 2012
Posts: 5
Location: INDIA

PostPosted: Fri Sep 14, 2012 2:29 pm    Post subject: Reply to: Converting UTF-8 format to text/ASCII format
Reply with quote

Hi,

There's an internal tool that gets the .xlsx file into host and the format is in binary.

Thank you!
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Fri Sep 14, 2012 2:51 pm    Post subject: Reply to: Converting UTF-8 format to text/ASCII format
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PL/I & Assembler All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm
No new posts Sorting on text - but in non-alphabet... Roy Ware SYNCSORT 5 Wed Aug 23, 2017 9:15 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us