how to convert Excel sheet into mainframe file

[Vinod M]

Hi,

Please guide me on, how to convert Excel sheet into mainframe file?

[Robert Sample]

Does the Excel sheet have more than one worksheet? If so, you most likely will have to treat each worksheet as a separate mainframe data set. If it has one worksheet (or for each worksheet of a multi-worksheet file), convert the worksheet into a comma-delimited file on the PC, transfer the .csv file to the mainframe, and process it as a text data set. You lose a lot of the Excel formatting with a .csv but that formatting would usually not exist on the mainframe anyway.

If you are asking how to use an Excel sheet on the mainframe as an Excel sheet, this typically is not done. There are products that can handle Excel files on a mainframe (SAS comes to mind)but they tend to be expensive (as in hundreds of thousands of US dollars).