I am trying to create a report, in text format from Excel.

So far I have been successful in creating an object, and put the records
line by line with WriteLine method.

In text-based reports, the common requirement is putting headers, footers,
and more importantly, setting the number of lines per page. I used a line
counter in my program.

What I need to know is:

1. How will I tell Excel to put a page break in the text file being created?

2. How will I tell Excel to make some headings bold? or Underlined?

Murthy

Plain text has no line breaks or formatting.
If you need that kind of report you'll have to use a different format, such as maybe HTML or Word.

--
Tim Williams
Palo Alto, CA


"Murthy" <(E-Mail Removed)> wrote in message news:631E90F3-97EE-4169-82D3-(E-Mail Removed)...
> I am trying to create a report, in text format from Excel.
>
> So far I have been successful in creating an object, and put the records
> line by line with WriteLine method.
>
> In text-based reports, the common requirement is putting headers, footers,
> and more importantly, setting the number of lines per page. I used a line
> counter in my program.
>
> What I need to know is:
>
> 1. How will I tell Excel to put a page break in the text file being created?
>
> 2. How will I tell Excel to make some headings bold? or Underlined?
>
> Murthy

I bet you meant that plain text files don't have page breaks.

Line breaks are pretty common in text files <bg>.

Tim Williams wrote:
>
> Plain text has no line breaks or formatting.
> If you need that kind of report you'll have to use a different format, such as maybe HTML or Word.
>
> --
> Tim Williams
> Palo Alto, CA
>
> "Murthy" <(E-Mail Removed)> wrote in message news:631E90F3-97EE-4169-82D3-(E-Mail Removed)...
> > I am trying to create a report, in text format from Excel.
> >
> > So far I have been successful in creating an object, and put the records
> > line by line with WriteLine method.
> >
> > In text-based reports, the common requirement is putting headers, footers,
> > and more importantly, setting the number of lines per page. I used a line
> > counter in my program.
> >
> > What I need to know is:
> >
> > 1. How will I tell Excel to put a page break in the text file being created?
> >
> > 2. How will I tell Excel to make some headings bold? or Underlined?
> >
> > Murthy

--

Dave Peterson

Err... yes - I did mean page breaks.
Thanks for the catch.



--
Tim Williams
Palo Alto, CA


"Dave Peterson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I bet you meant that plain text files don't have page breaks.
>
> Line breaks are pretty common in text files <bg>.
>
> Tim Williams wrote:
> >
> > Plain text has no line breaks or formatting.
> > If you need that kind of report you'll have to use a different format, such as maybe HTML or Word.
> >
> > --
> > Tim Williams
> > Palo Alto, CA
> >
> > "Murthy" <(E-Mail Removed)> wrote in message news:631E90F3-97EE-4169-82D3-(E-Mail Removed)...
> > > I am trying to create a report, in text format from Excel.
> > >
> > > So far I have been successful in creating an object, and put the records
> > > line by line with WriteLine method.
> > >
> > > In text-based reports, the common requirement is putting headers, footers,
> > > and more importantly, setting the number of lines per page. I used a line
> > > counter in my program.
> > >
> > > What I need to know is:
> > >
> > > 1. How will I tell Excel to put a page break in the text file being created?
> > >
> > > 2. How will I tell Excel to make some headings bold? or Underlined?
> > >
> > > Murthy
>
> --
>
> Dave Peterson