PC Review


Reply
Thread Tools Rate Thread

Complex Question - XML Validation in Spreadsheet Web Component

 
 
=?Utf-8?B?UGVyaWNv?=
Guest
Posts: n/a
 
      19th Aug 2007
Please refer to my posted question 8/16/07 to which I did not receive any
response. This is in follow-up.

When I search the Object Browser, key word and Library "OWC11", which is the
Spreadsheet Web component, I see the XMLMAP and XMLMAPS classes and their
members appear to be available with that component. Would that mean I could
use XML related properties, methods and events with the Spreadsheet
component, or would the fact VB Script may not yet support* such XML
properties and methods preclude me from doing so?

My goal is to have users enter data into the component on the Web but
enforce validation just as you would with a non-web based Excel spreadsheet
using XML validation for data entry into Lists.

If it were possible to use the component with XML methods, properties, etc,
and I wanted an external schema establishing some of the validation rules,
such as governing formatting for fields and so forth, would that entail using
the Schema File as an Include File on the Web Server?

* I need to further research VBS to see if such support is available.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?UGVyaWNv?=
Guest
Posts: n/a
 
      31st Aug 2007
FYI, I've been posting these XML and web component questions to the wrong
group. Will post to the Office Components group.

"Perico" wrote:

> Please refer to my posted question 8/16/07 to which I did not receive any
> response. This is in follow-up.
>
> When I search the Object Browser, key word and Library "OWC11", which is the
> Spreadsheet Web component, I see the XMLMAP and XMLMAPS classes and their
> members appear to be available with that component. Would that mean I could
> use XML related properties, methods and events with the Spreadsheet
> component, or would the fact VB Script may not yet support* such XML
> properties and methods preclude me from doing so?
>
> My goal is to have users enter data into the component on the Web but
> enforce validation just as you would with a non-web based Excel spreadsheet
> using XML validation for data entry into Lists.
>
> If it were possible to use the component with XML methods, properties, etc,
> and I wanted an external schema establishing some of the validation rules,
> such as governing formatting for fields and so forth, would that entail using
> the Schema File as an Include File on the Web Server?
>
> * I need to further research VBS to see if such support is available.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
complex data validation nycdon Microsoft Access VBA Modules 0 16th Oct 2008 05:28 PM
Complex Data Validation =?Utf-8?B?U2Vhbg==?= Microsoft Excel Misc 1 21st Mar 2007 08:01 AM
Re: complex data validation Bob Phillips Microsoft Excel Misc 0 28th Dec 2006 04:48 PM
OWC10 spreadsheet component question xargon Microsoft Excel Misc 1 28th Jan 2004 07:05 AM
Export method question -- Spreadsheet ActiveX component on user form PatFinegan Microsoft Excel Programming 1 8th Jan 2004 02:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:17 PM.