Has anyone output mulitple sheets in one Excel template?
And in the template file i defined three sheet .
The first and second sheet is the output data from the procedure,
The third sheet show the graph by sheet1 and sheet2's data.

The code I'm using is like this:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'sample' SHEETNUMBER 1
ON TABLE SET STYLE *
TYPE=REPORT, $
END
-RUN

TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'sample' SHEETNUMBER 2
ON TABLE SET STYLE *
TYPE=REPORT, $
END
-RUN

when i run the procedure , it is only output the data to the sheet1.
so i use compound command as follows , but it prompt error.

SET COMPOUND = OPEN
-RUN

TABLE FILE CAR
....
-RUN

SET COMPOUND = CLOSE
-RUN

TABLE FILE CAR
....
-RUN

Anyone can give me some tips? thanks!

This question has been asked so many times and there are many good answers already out there.

Try using the "search tech document" link above right and search the WebFOCUS forum for EXCEL TEMPLATE.

try this prior forum - hope it helps.
https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/5881058331

Ira

wf 538 aix 533

Ira:
Thanks for your help, but that doesn't solve my problem.

Tony:
Before I post this question, I searched the answers all the forum . And find out a lot of sample for it. But when I tried them ,always prompt error for me like this (Agent on reporting server EDASERVE may have crashed. Please investigate reporting server log.)

Today I tried it again , fortunately I find out the reason for that crash error.
I open the excel file with notepad, and I find out a strange line as this.

quote:

MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related; boundary="----=_NextPart_01C87261.C169F500"

This document is a Web archive file. If you are seeing this message, this means your browser or editor doesn't support Web archive files. For more information on the Web archive format, go to http://officeupdate.microsoft.com/office/webarchive.htm

I delete this italicize line and run the procedure, Then everthing is OK!

------------------------------------------------
This is my code with webfocus car. The template file "abc.mht" is made by excel2003 which has 3 sheet.

FILEDEF FRED DISK C:\ibi\apps\jrsnsl\fred.mht
-RUN

TABLE FILE CAR
PRINT DCOST
ON TABLE HOLD AS FRED FORMAT EXL2K TEMPLATE 'abc' SHEETNUMBER 1
END

TABLE FILE CAR
PRINT MODEL
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'fred' SHEETNUMBER 2
END

But i still don't know why this line can make webfocus crash ? and how to save template file without that message?

Thanks!

Best Regards

lepoard

This message has been edited. Last edited by: lepoard,

Mmmm, weird indeed.
I have two windows xp-systems (well, I have more, but that's beside the point).
One is a local language machine, the other is plain us-english.
On both machines I have excel 2003 installed.
If I save an excel sheet as a template (mht file) on the localized machine, I get the same as you get in my mht file.
If I save it on my plain good old US_English machine, the mht file looks completely different, and lacks this message.
On the localised machine, if I first save the file as an xlt (excel template) file, call it up again and then save it as mht, I get the same result as on my us-english machine.
The version that is producing the message in the mht is 11.8146.8132 SP2.
The version that produces no message is 11.6560.6568 SP2.
But, if I try to use it in my request, I get error message stating that the file must be in "single file web page" format (which I really, very very sure, choose for saving)....
Confused? I am....

Lepoard,

I would possibly suspect the mht file, as I can run your exact code against a template file without error.

Just to be sure, open Excel and ensure that you have at least two worksheets in it.
Enter a space in the cell A1 in each sheet and then "Save As" a "Single File Web Page".
Point your fex at this template and try again. It shouldn't crash the agent. If it does then you'd best raise a case with IB support.

T

GamP,

You are right, Because my work, The machine that I using is japanese xp system, The header strange section line is translated from the japanese. So I think it is the problem of Microsoft. After search that message on the web I can't get any useful point for that problem . Thanks for your information.

Tony A

Thanks again for your interesting and helping .By the way, I don't know how to raise this case to IB supporter.Can they solve that problem in the next version? Whatever, I finished my work. Thank you..

Best Regards

Lepoard

This message has been edited. Last edited by: lepoard,