Hello,

Does anyone have a basic example of an excel template 2007 and how I access it with Dev studio using the Car file?

I am on dev version 8005.

I had created a basic .fex using an older example I found but I"m getting the error "(FOC3289) TEMPLATE FILE: Error Opening File. (FOC3317) Failed to unzip EXL07 template file.

Thanks for your help

This message has been edited. Last edited by: <Kathryn Henning>,

Below is sample code. You have to use a template with 'xlsm' extension. In the example mytemplate.xlsm.

  

SET BYDISPLAY = ON
SET PAGE = NOLEAD
FILEDEF TEMPMHT1 DISK tempmht1.mht
FILEDEF TEMPMHT2 DISK tempmht2.mht
TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE HOLD AS TEMPMHT1 FORMAT EXL2K TEMPLATE MYTEMPLATE SHEETNUMBER 2
ON TABLE SET STYLE *
  SIZE=9, $
ENDSTYLE
END
 TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE HOLD AS TEMPMHT2 FORMAT EXL2K TEMPLATE TEMPMHT1 SHEETNUMBER 3
ON TABLE SET STYLE *
  SIZE=9, $
ENDSTYLE
END
 TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE PCHOLD AS FINALXLS FORMAT EXL2K TEMPLATE TEMPMHT2 SHEETNUMBER 4
ON TABLE SET STYLE *
  SIZE=9, $
ENDSTYLE
END
-RUN

Thanks Cyril,

where do I save the MYTEMPLATE.xlsm? On the server?

I saved it on the server and tried running what you gave me. I received the following error:

(FOC3289) Template File: Error Opening File
(FOC009) Incomplete request statement
BYPASSING TO END OF COMMAND

Yes, Save it in the same folder where you have the fex.

Also save the file as mytemplate.xlsm (All small case)

Thanks Cyril,

i'm still unable to get it to open the spreadsheet. It is giving me the same error.

I have the mytemplate.xlsm in the smae folder.

SET BYDISPLAY = ON
SET PAGE = NOLEAD
FILEDEF TEMPMHT1 DISK tempmht1.mht
FILEDEF TEMPMHT2 DISK tempmht2.mht
TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE HOLD AS TEMPMHT1 FORMAT EXL2K TEMPLATE MYTEMPLATE SHEETNUMBER 2
ON TABLE SET STYLE *
SIZE=9, $
ENDSTYLE
END
TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE HOLD AS TEMPMHT2 FORMAT EXL2K TEMPLATE TEMPMHT1 SHEETNUMBER 3
ON TABLE SET STYLE *
SIZE=9, $
ENDSTYLE
END
TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE PCHOLD AS FINALXLS FORMAT EXL2K TEMPLATE TEMPMHT2 SHEETNUMBER 4
ON TABLE SET STYLE *
SIZE=9, $
ENDSTYLE
END
-RUN

Hope you have three sheets in the saved template.

For the above example, 4 sheets in template.

If you are using EXL07, try adding the following to the beginning of your fex:

 
SET EXCELSERVURL = '' 

Hi KellyT,

It works for me. I got MS Office 2013.

 FILEDEF CARTEST DISK hello.xltx
-RUN
TABLE FILE CAR
PRINT MODEL
BY CAR
ON TABLE PCHOLD AS CARTEST FORMAT EXL07/XLSX TEMPLATE hello SHEETNUMBER 1
END 

When you're uploading templates to the server, atleast one of the sheets must contain a cell with a valid value (blank or any other value).

Created a template(zzzz.xltx) with 4 sheets and saved it to the server.

TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE HOLD AS temp1 FORMAT EXL07 TEMPLATE zzzz SHEETNUMBER 1
ON TABLE SET STYLE *
  SIZE=9, $
ENDSTYLE

END
-RUN

TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE HOLD AS temp2 FORMAT EXL07 TEMPLATE temp1.xlsx SHEETNUMBER 2
ON TABLE SET STYLE *
  SIZE=9, $
ENDSTYLE
END
-RUN

TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL
ON TABLE HOLD AS temp3 FORMAT EXL07 TEMPLATE temp2.xlsx SHEETNUMBER 3
ON TABLE SET STYLE *
  SIZE=9, $
ENDSTYLE
END
-RUN

TABLE FILE MOVIES
PRINT *
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD AS FINAL FORMAT EXL07 TEMPLATE temp3.xlsx SHEETNUMBER 4
END
? FILEDEF
-EXIT

Note, here, I'm referring to the workbook(.xlsx) not the templates(.xltx) and it works. But, if i refer as .xltx & there is an issue in opening.

Is that the correct behaviour in EXL07?

The replies did help for me to find my solution.