Desktop productivity for business analysts and programmers

error creating a 2007 excel spreadsheet with tagset.tableeditor

Reply
Contributor
Posts: 38

error creating a 2007 excel spreadsheet with tagset.tableeditor

I am trying to create a 2007 excel spreadsheet using tagset.tableeditor and I am getting the following error:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; .NET4.0C; .NET4.0E)
Timestamp: Fri, 9 Jul 2010 18:42:54 UTC


Message: Automation server can't create object
Line: 1400
Char: 2
Code: 0
URI: http://fl-sas03.sscincorporated.com:8080/SASStoredProcess/do?_program=/SSC Analytics/STM Reports1A_detail&Report_scenario=8&state_prompt=AZ&prcs_period_prompt=01MAY2010:00:00:00
SAS Super FREQ
Posts: 8,814

Re: error creating a 2007 excel spreadsheet with tagset.tableeditor

Hi:
I'm not sure what you mean by "2007 excel spreadsheet" -- do you mean an .XLSX file???? The truth is that TAGSETS.TABLEEDITOR creates an HTML file, as it describes here:
http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/index.html
beginquote
Tableeditor.tpl is a custom tagset that is created by the TEMPLATE procedure. The tableeditor tagset uses HTML, CSS, JavaScript, and the Markup language. You can download the tableeditor.tpl file and examples as a ZIP file

The tableeditor tagset enables you to create HTML output with the same kind of functionality that you would get from Visual Basic .Net (VB.NET). You can easily export the output to Excel or other filetypes. Note, currently, the tagset supports Internet Explorer only.
endquote


Also on the above web site, is the topic on Exporting Data, where it says that:
beginquote
The EXCEL_SAVE_FILE= option saves the file as native a XLS, CSV, XML, TXT, DOC, or SLK file. Specify the appropriate extension of the file with the FILE_FORMAT= option. You can also specify whether you want Excel to open this file or save it in the background. To save this file in the background without opening Excel, use the OPEN_EXCEL="NO" option. There is also the EXCEL_SAVE_PROMPT= option, which prompts the user for a file to save. The EXCEL_SAVE_DIALOG= option opens a dialog box to save the file.
endquote


The documentation here does not imply that you could save the file as an .XLSX file (which is the "new" Office Open XML format). As far as I am aware, the only way to create .XLSX files is to use PROC EXPORT or the Excel LIBNAME engine with SAS 9.2 Phase 2, as described here: http://support.sas.com/kb/32/455.html

For more help with this issue, you might want to open a track with Tech Support. they could tell you definitively whether is is possible to create an XLSX file using TAGSETS.TABLEEDITOR.

To open a track with Tech Support, go to:
http://support.sas.com/ctx/supportform/createForm

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 143 views
  • 0 likes
  • 2 in conversation