Hi all,

In order to copy data from one system into another "generic" system, I have a requirement to produce an Excel document that follows a strict template. The file begins with four lines of text, column descriptions, and column names from a provided template file and is followed by data from database being copied. I have pulled the data from the Excel template document into a HOLD file with 62 fields. I have extracted needed data from the database and put that into a second hold file with 62 fields. To make sure that I could concatenate the files, I used FIELD_1 ... FIELD_62 as field names for both HOLD files and forced all the columns to have the same format. So far so good.

Now I need to send the combined files to an Excel file for processing. The issue is that I cannot have the field names printed to the file. If the created file does not match the template format exactly, the data will not be read into the new system. This will become part of an automated process so opening the Excel file up each time and removing the first row is not a good solution.

I have searched here for some way to skip the first line or suppress field names.

Any suggestions would be appreciated.

Harold

This message has been edited. Last edited by: <Emily McAllister>,

I stumbled on to the answer to my own question. I printed each of the fields as '' and that created a blank line. The export to Excel was perfect.

Harold-

Is the HAL 9000 operational?

(I realize you must get this all the time, sorry. Nice that you follow up on your post. :-))

-Dave

"I'm sorry, Dave, but I cannot tell you that." Back in 2001, that year's Ebertfest featured a remastered version of "2001: A Space Odyssey". I don't mind that reference at all.

-H

WebFOCUS 8.1.0.1 M
Windows Server 2008
PDF, HTML, Excel