Well, there is one thing I haven't been able to do with the current
method. If it can be done with the XLXS version of CGIDEV (if there be
such a thing), then it would probably warrant my levering myself out
of my newly comfortable xls zone.
The instructions I have for the xls method explicitly state that there
can be only one sheet in the workbook, named the same as the file.
If the scenario is that two separate companies, let's call them
Paymore Plastics and Consolidated Solids, are hosted on the same
machine under the same ERP programs, but each with its own database
(identical file structures), then it would be useful to be able to
write two sheets when generating a report: one for "Paymore" and one
for "Consolidated".
Some people who work for the holding company have oversight over both
companies. At present their requirements are met either by running the
same program twice, once over each database, and emailing them two
files with the company name in the subject (.csv files, but .xls going
forward) and letting them stitch them together, or by combining the
data in the program, having one sheet and putting a new column at the
start to identify the company.
The data is always distinct - no summing or merging is done across
companies (at least not by me).
So, if there's a way to keep the workbook open and write first one
sheet then the next, or if there's a way to close it after the first
company then re-open it and create a new sheet without losing the
existing one, then that would be interesting to me.
On 10/25/20, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:
If you have a version of Excel that is that out of date you might be better
off using Libre Office or one of the other OS Office alternatives. With
this version you're going to find out some day in the not too distant future
that you can't read other people's spreadsheets and they can't read yours.
Just saying' - It is not like it will cost you anything.
midrange.com
