Is there any way to update a spreadsheet

ramya k · New User Joined: 02 Jun 2008 Posts: 1 Location: India

I have a spreadsheet in a common folder. I need to update it daily referring to some mainframe files.

dbzTHEdinosauer · Posted: Mon Jun 02, 2008 9:35 pm Post subject:

well, you have to design/implement and run some type of data retrieval from the mainframe and get it to the pc.

then you have to determine how you are going to process that data and get it into a spreadsheet.

depending upon availablilty of pc languages (any of the microsoft JAVA, C#, VB will directly communicate with an exell spreadsheet).

you could also use rexx.

or, if you are clever and create the data on the mainframe in such a manner that when downloaded to the pc, a simple exell macro will process the data and update your spreadsheet.