Extracting data from spreadsheet



Support for MQSeries and Websphere Message Oriented Middleware communication systems for z/OS

Extracting data from spreadsheet

Postby joinshashank » Fri Sep 17, 2010 6:23 pm

Can anybody suggest a solution for following issue?

I have numbers in the spreadsheet in row 1
1.1234 2564 2654
2 1245 2654 2564
3 5564 1244 2144
4 8544 2354 2650
5 8595 2313 1484
6 7841 1844 1441
7 1547 1541 0124
8 5414 2654 4424

i want to pull the number one by one as I hit enter when i will put this this data to mainframe i should pool it as 1234 2564 2654

with next key eg F1 i should able to pull the second 1245 2654 2564 in mainframe could it be possible to link it ???
joinshashank
 
Posts: 1
Joined: Fri Sep 17, 2010 1:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Extracting data from spreadsheet

Postby Robert Sample » Fri Sep 17, 2010 8:21 pm

Why are you posting problems with a SPREADSHEET on a mainframe forum? You're not likely to find any answers here.

When I need to transfer data to / from a spreadsheet, I use the comma-delimited format and the mainframe handles them as text files just fine.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to WebSphere MQ