BookmarkSubscribeRSS Feed
SAS_Doctor
Calcite | Level 5
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
1 REPLY 1
Cynthia_sas
SAS Super FREQ
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 652 views
  • 0 likes
  • 2 in conversation