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: 6970
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: 10396
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 Sum the fields in particular format f... sharana64 DFSORT/ICETOOL 9 Fri Jan 05, 2018 1:11 am
No new posts Can EDCICONV convert EBCDIC to ASCII... natt.sut IBM Tools 3 Fri Nov 17, 2017 8:46 pm
No new posts Format Last Record differently from r... Learncoholic DFSORT/ICETOOL 5 Tue Oct 24, 2017 12:01 pm
No new posts Format issues using XMITIP MSGDD ssdjp1 CLIST & REXX 5 Mon Oct 23, 2017 8:47 pm
No new posts Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm

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