Date: Wed, 25 Jan 2006 08:20:13 -0800
Reply-To: Sarav <sarav.sas@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sarav <sarav.sas@GMAIL.COM>
Subject: Double quotation marks problem with XML, EXCEL XP Tagset
Content-Type: text/plain; charset="iso-8859-1"
I am using EXCEL XP tagset to create multi-tabbed EXCEL workbooks. I
use the tagset to also create formulas for me in the EXCEL workbook,
which the tagset creates using XML in EXCEL. In cases where the EXCEL
formula contains double qoutes, the tagset is unable to resolve them
and I get an error while trying to open the output sheet.
For Example: When I mention the formula as "=IF(R[-2]C=R[-1]C,"
","ERROR")", SAS is unable to resolve the space between the first
double qoute and the ERROR between the second double qoute.
I will be glad if I can get any help regarding this.