Re: .XLS, not .CSV from NETX?

On Mar 25, 3:14 pm, "Paul H" <NoSpamphobergNoS...@xxxxxxx> wrote:
Thanks, Pete, is this what you had in mind?http://user.services.openoffice.org/en/forum/viewtopic.php?f=25&p=77541 I'm
overwhelmed, but I'll play around with it.  At least it's all COBOL stuff.
I'll look up the definitions of the various invoked commands and go from
there.  Any clue of where to find a list of these things?

Paul

OpenOffice.org spread*** does a good job of importing an html table
and follows the formatting. As it is easy to write to an html template
this could work.

Actually I do a lot of templated output, including to CSV and HTML, so
it would be just a template file change to do that if you had a
templating engine.


--
"I only use COBOL... and I try to do everything."

"Pete Dashwood" <dashw...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:72t1ulFs08c7U1@xxxxxxxxxxxxxxxxxxxxx

Paul H wrote:
I create .CSV files in my Net Express programs, then my users can
open them with Excel.  But the column widths, bold, line sizes etc.
are not set.  I'd like to create a .XLS file that has these
characteristics built in.  Is this possible?  I only know COBOL, not
C or VB or etc.  TIA, Paul

The properties you describe are part of the receptacle, not the contents.

You create the contents and these are loaded into a default container.

Try setting up an Excel spread*** with the attributes you want (line/col
width, bold, etc) then save it as a template.

This should give you the .XLS you are looking for.

Alternatively, you can use Automation (Excel as a COM componenet) to access
Excel directly from your program and set the attributes you want , then load
the data directly (without needing the .CSV) or run a macro to load it, all
under program control. There are many ways to do what you are trying to do.

If you want the users to initiate the Excel stuff, and you want it to look
as you intended, then provide a template for them to use.

HTH,

Pete.

--
"I used to write COBOL...now I can do anything."

.

Quantcast