Writing multi sheet excel workbooks to sharepoint.

I am having trouble writing multisheet excel workbooks to sharepoint.

Here is a snipet of my syntax
If I use this in multiple sections of my fex
ON TABLE PCHOLD FORMAT EXL2K OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TITLETEXT='RCC', $
END
ON TABLE PCHOLD FORMAT EXL2K OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TITLETEXT='RCD', $
END
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TITLETEXT='PCAT', $
END

It work fine but it pops up and asks me to open or save the file. The problem is that I want to write it to a sharepoint server so I replace
ON TABLE PCHOLD FORMAT EXL2K CLOSE
with
ON TABLE SAVE FILENAME
'Z:\APPLICATION.XLS'
FORMAT EXL2K CLOSE

It writes the file but it only contains the first tab.

Thanks in advance for your help

Posts: 9 | Registered: October 07, 2003

Leah

Virtuoso

posted

Hide Post

I can't say as to the issue of saving, but I don't think you need an open on the second step just the pchold.

Leah

Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004

Ignored post by Leah posted

Show Post

Tony A

Expert

posted

Hide Post

Try filedefing the file rather that the syntax you are using and use HOLD rather than PCHOLD otherwise the output will be sent to screen only -

FILEDEF XLSOUT DISK Z:\APPLICATION.XLS
-RUN
....
ON TABLE HOLD AS XLSOUT FORMAT EXL2K OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TITLETEXT='RCC', $
ENDSTYLE
END
....
ON TABLE HOLD AS XLSOUT FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TITLETEXT='RCD', $
ENDSTYLE
END
....
ON TABLE HOLD AS XLSOUT FORMAT EXL2K CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TITLETEXT='PCAT', $
ENDSTYLE
END

As Leah states, you do not (or should not) have the OPEN on the second or middle extracts.

T