A
Anand Nichkaode
Hi all,
We are using Excel for reporting in our organization. Basically there is a
Java web application which instantiates Excel 2007 with an XLAM. This XLAM
opens a Report Template(an .xls, .xlsm/.xlsx file). The Template has a sheet
where there would be multiple ranges and the Reportsheet which shows the
final report based on the data from the Datasheet. The Reportsheet contains
formulae to show the final output. It could contain Charts/Graphs also. The
data is fetched from SQL server and is pasted on the Ranges. And finally when
all the data is pasted and User macro (a Macro from the template) is run the
Template is saved as a Final Report somewhere on the Report Server. The final
report could be a Excel 97-2003 workbook, Excel 2007 workbook or a PDF. The
Excel runs in the background in all this process. There could be multiple
instances of Excel running on the same box. The instances run under separate
WindowStations.
The reports are generated on the Excel instance in succession without
closing it. The excel instance is only closed in case there are any error and
excel stops responding.
In one of the templates used by the end user had a user macro which is
basically into deleting, formatting, autofitting the rows in the ReportSheet.
It would select rows by the range names, defined already, and format them.
The Template happens to have a set of ranges having names like Add_Info_1,
Add_Info_2, Add_Info_3,......Add_Info_10.
When the reports are generated as PDF (with Microsoft Office PDF addin) the
first report processed on an Excel instance gets generated without any
error. But when it comes to processing next reports, the user macro errors
out. The reason for the user macro to error is that the ranges mentioned
above are not available. The same ranges are avaialble for the first report.
It was observed that if the reports are genereated in Non-PDF format then
the same user macro is able to load the mentioned ranges without any error
and completes succesffuly for each report.
It was also observed, after doing some tests, that if the range names are
like "Add_Info_And" or "Add_Info_Andan" i.e. if the range names has more than
two characters attached to "Add_Info_" then user macro can load them without
any problem. The problem is only with ranges which has two or less characters
attached to "Add_Info_"
Is there any connection with the PDF Add-in and the ranges named
"Add_Info_**"?
If anybody have any idea please let me know as it is a blocking issue in our
process.
Any help appreciated.
Thanks in advance.
We are using Excel for reporting in our organization. Basically there is a
Java web application which instantiates Excel 2007 with an XLAM. This XLAM
opens a Report Template(an .xls, .xlsm/.xlsx file). The Template has a sheet
where there would be multiple ranges and the Reportsheet which shows the
final report based on the data from the Datasheet. The Reportsheet contains
formulae to show the final output. It could contain Charts/Graphs also. The
data is fetched from SQL server and is pasted on the Ranges. And finally when
all the data is pasted and User macro (a Macro from the template) is run the
Template is saved as a Final Report somewhere on the Report Server. The final
report could be a Excel 97-2003 workbook, Excel 2007 workbook or a PDF. The
Excel runs in the background in all this process. There could be multiple
instances of Excel running on the same box. The instances run under separate
WindowStations.
The reports are generated on the Excel instance in succession without
closing it. The excel instance is only closed in case there are any error and
excel stops responding.
In one of the templates used by the end user had a user macro which is
basically into deleting, formatting, autofitting the rows in the ReportSheet.
It would select rows by the range names, defined already, and format them.
The Template happens to have a set of ranges having names like Add_Info_1,
Add_Info_2, Add_Info_3,......Add_Info_10.
When the reports are generated as PDF (with Microsoft Office PDF addin) the
first report processed on an Excel instance gets generated without any
error. But when it comes to processing next reports, the user macro errors
out. The reason for the user macro to error is that the ranges mentioned
above are not available. The same ranges are avaialble for the first report.
It was observed that if the reports are genereated in Non-PDF format then
the same user macro is able to load the mentioned ranges without any error
and completes succesffuly for each report.
It was also observed, after doing some tests, that if the range names are
like "Add_Info_And" or "Add_Info_Andan" i.e. if the range names has more than
two characters attached to "Add_Info_" then user macro can load them without
any problem. The problem is only with ranges which has two or less characters
attached to "Add_Info_"
Is there any connection with the PDF Add-in and the ranges named
"Add_Info_**"?
If anybody have any idea please let me know as it is a blocking issue in our
process.
Any help appreciated.
Thanks in advance.