Removed Records: Named range from /xl/workbook.xml part (Workbook)

[Theo Kusters]

Hi,

I used the vvout excel utilities to create an excel outside Valence using vvOut.download = 'F' and the vvOut_SS* utilities
The file is created nicely, but when I open the excel locally I receive the message that the files needs to be repaired with the following message:

Removed Records: Named range from /xl/workbook.xml part (Workbook)

Another excel that I created earlier and is downloaded through Valence still works fine.

Is it even possible to use this utility outside Valence?

Kind regards,
Theo

[robert.swanson]

Hi Theo,

Generally speaking, it should be possible to run vvOut_execSQLtoSS outside of a Valence CGI job. What you're describing sounds like it could stem from a bad hex character in the data being downloaded. Do you get the same result (corrupted output) if you run the exact same SQL statement through a Valence job?

[Theo Kusters]

Hi Rob,

I found that when I remove the following statements it works fine:

vvOut.ssFilterRow = 4;
vvOut.ssTitleRowF = 1;

Any idea?

Kind regards,
Theo

[Theo Kusters]

One addition:
Changing
vvOut.ssTitleRowF = 1;
to
vvOut.ssTitleRowF = 0;
also removes the error message.

But in either way the TitleRow functionality doesn't work.

[robert.swanson]

Can you confirm that this problem happens over the same exact SQL statement only when running in a non-CGI mode? The same statement works fine when running inside a Valence job?

It still sounds like a data problem to me. i.e., Excel doesn't like one of the characters inside the title row range.

[Theo Kusters]

I think we have 2 different issues here. Lets focus on the most important one:

I create the excel outside Valence and downloaded it through Valence via a document app like: https://www.youtube.com/watch?v=i5RZ4z376BA

I found that when I FTP the document from the AS400, the excel is perfect. When I download it through the App it somehow gets damaged.

With error message:
Removed Records: Named range from /xl/workbook.xml part (Workbook)

Also excel files that I downloaded earlier perfectly well from this app are now damaged. PDF files are downloaded fine.

[robert.swanson]

I'm still not sure what to make of what you're describing...

Can you replicate this corrupt Excel phenomenon using an SQL statement over a common file we both have, like DEMOCMAST, so we can observe the problem you're describing happening on our system?