Importing Files from external sources. How to create ...

[Leonardo Z.]

I'm working with big databases systems in IBM mainframe
environment.

Part of my Job is to create smart statistis, predictive
analysis, data analysis, etc. For this purpose I choice
EXCEL.

I developed standard COBOL programs that reads ours
databases and creates text files in an "excel" format.
These flat files includes a lot of excel cell formulas.
The quantity of rows and columns (Cell Formulas included)
is not fix and dinamically changes depending the amount of
data analyzed.

The next step is file transfer the file from IBM mainframe
to PC, and load it in a preformatted Excel worksheet.

The problem:
because I can't know the number of rows and columns, I
can't preformat the excel worksheet. For instance, a
Percentage column can be the BA column or the BD or the CA
or the QA, depends the amount or the quality of the data
analyzed in the IBM mainframe.

The Question:
Can I create in the same flat file or in other, Format
information like Number-Percentage, color, font, size, etc.

If yes, how ???

Thanks a lot

Leonardo

PD: Sorry for my english