Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 6967
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: 10256
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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 11 Tue May 16, 2017 2:20 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
No new posts Format record to remove Leading zeroes Learncoholic DFSORT/ICETOOL 14 Wed Apr 05, 2017 2:43 pm
No new posts How to pick only YYMMDD from DATE1P (... atulbaviskar SYNCSORT 7 Wed Mar 22, 2017 11:39 am
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us