I have some XML doc loaded in a C# Web Service.
XmlDocument doc = new XmlDocument();
Code Missing to manipulate header (I would like to replace or manupulate all
Any idea on how to access and manipulate data within the doc header?
> I have some XML doc loaded in a C# Web Service.
> XmlDocument doc = new XmlDocument();
> Code Missing to manipulate header ...Read XHTML into XML
I need to read/parse XHTML aspx pages and look for certain tokens and
content. How can I use a XmlTextReader for this? If not, any other ideas?
Thanks in advance,
Jose Antonio Reyes wrote:
> I need to read/parse XHTML aspx pages and look for certain tokens and
> content. How can I use a XmlTextReader for this? If not, any other ideas?
If the pages are well-formed XHTML then it is possible to use XmlReader
(in .NET 2.0/3.0) or XmlTextReader (in .NET 1.x) to parse the XHTML
documents. You can also use the other XML APIs .NET provides so using
XPathNavigator and/o...How to invoke the xml editor?
I installed vs2005 on a new xp pro machine, and installed everything
except C++. When I click on a file with a ".xml" extension it is
opened with IE. When I click file/Edit with XML Editor, it opens it
with Notepad. If I click File/Open With and select XML Editor, it
opens it with IE. So, where is the xml editor?
Can it be invoked from withing VS? Where?
* firstname.lastname@example.org wrote in microsoft.public.dotnet.xml:
>I installed vs2005 on a new xp pro machine, and installed everything
>except C++. When I click on a file with a ".xml" extension it is
>opened ...Conditional Formatting #94
I have a range of cells that contain formulas, but I also need to give the
user the option to manually overwrite the result of any of these formulas.
Where the formula is overwritten I want the cell shading to turn yellow. I
can't see a way of doing using the Conditional Formatting tool.
Is there something else I could try ??
Are you using Conditional Formatting to begin with ?
If so they answer is no, because C.F. overrides normal cell formatting..
Unless you are talking about a constant replacing what is normally a
formula in a column. You have to be able to identify w...SUMIF with two conditions ?
:cool: OK I have tried just about everything and can not find the righ
combination for seems like a simple problem:
IF N79:N83 >=1 AND
IF N79:N83 <=7
THEN SUM K79:N8
Calvin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=590
View this thread: http://www.excelforum.com/showthread.php?threadid=26341
"Calvin" <Calvin.email@example.com> wrote in message...show XML schema and values
I have an XML document that looks like the following:
What I'm aiming to do is to show the data in a report as in the following
The "Field1-3"-elements can have any name, so I'm trying to get a table that
has in one result column the element name, and in the second colum...conditional format of data tables in charts
I've created a chart that is based on a data set where the cells have
conditional formatting (if value a > value b then colour the cell red)
I have the data table displayed with the chart (in chart options, 'show
data table' is ticked), but the condtional formatting is not displayed
in this table, i.e cells that are red in my original data set are not
coloured in the chart table.
Is there any way to apply the conditional format on the table displayed
within the chart?
Unfortunately you can't apply conditional formating to data tables.
However, yo...Delete Macro with OR/ELSE condition
I am a beginner a writing Macros in Excel. I have a Macro that deletes any
record that does not equal "Server/Midrange Software" in column M. I need to
expand this to include other criteria. Such as,
if column M does not equal "Server/Midrange Software" or does not equal
"Data Telecom" then delete the record.
The Macro I have currently is.....
'Deletes rows where the value in column M are not equal to Server/Midrange
Dim RowMdx As Long
Dim LastRow As Long
LastRow = Cells(Rows.Count, "M").End(xlUp).Row
Fo...Offline synch using XML web-services
This is a bit long-winded. Can somebody read thru these 2 use cases, and
tell me if it is feasible ? :-
Use Case : Replication before Offline Synch
Scenario 1 : Oracle Server , MSDE client
1. User clicks on 'Go Offline'. System creates a MSDE SQL database in
laptop (client), gets the schemas of the tables in Oracle, creates
corresponding tables in client's MSDE SQL (mapping Oracle datatypes to SQL
2. Offline replication program reads in the tables of the server into a
typed datasets, converts the typed datasets into XML, and stores the XML in
the client. (XML serial...XML Serialization ... how to truncate <?xml...
While xml serializing object how can I truncate <?xml ...?> this line alone?
I need to send the serialized xml data to a web method ... since SOAP
already have <?xml tag there was some confusion
Any help would be greatly appreciated
> While xml serializing object how can I truncate <?xml ...?> this line alone?
Serialize to an XmlWriter created with XmlWriterSettings where you set
OmitXmlDeclaration to true.
Martin Honnen --- MVP XML
...Custom Autonumber Conditional Formatting
The EXPERTS, ( Access Dept.)
I am New to access but have managed to make a database for my patients
records , my trouble is the Registration Number of the Patient,( a cloumn in
my database). i want it to generate the unique ID just llike AUTONUMBER, with
the format i need that should be like YYMMnn( YY= present year,MM= present
month and nn = numbers 01 to 99, with reset to 01 at the start of the next
month)the event to trigger the event is SAVE Form button. please can anybody
help? Thanking you in advance
Thanks for your Promt help... I will try to put this into use i...String to xml document
I was hoping someone can help me with a little problem I can't seem to find
any answers to.
I've got a form wich will be posted. On receiving the post I would like to
parse a formvar to a xml document.
The contents of this formvar (string) will be a valid xhtml document.
Can someone give me a startertip (or more :-)) on how to achieve this?
tnx in advance,
James van der Veen
> I was hoping someone can help me with a little problem I can't seem to find
> any answers to.
> I've got a form wich will be posted. On receiving the p...Beginner of XML
I am a beginner of XML.
I want to group some files together with a xml file. (it includes a text
file, and an image file and a video file)
Can someone show me some guidelines?
Ive got a set of sales figures next that relate to specific stores we are
selling our products in.
Ive managed to conditionally format cells where no stock has been sold, but
I want to highlight the name of the store that has not sold any stock. How do
I do this? Please help me Im going out of my mind!!
you may provide some more details about your data layout. e.g., some
"ANDREW_B" <ANDREWB@discussions.microsoft.com> schrieb im Newsbeitrag
...Valid xml to read from an xml file?
I'm using vb.net, i get an error at the reader line saying the remote
server can't be found. Is the below even valid?
dim reader as XmlTextReader
reader = new XmlTextReader ("http://www.mysite.com/my.xml")
do while (reader.Read())
'do some action here
XmlTextReader uses System.Net.WebRequest under the covers -- see if you can
figure out how to create a connection that way. Usually there's some proxy
server information missing that you can enable if you use WebRequest
directly, and then pass the result of GetResponse()...Example eConnect XML documents
MSDN says the following:
Installing eConnect schema
When you include the schemas component of the eConnect install, the
installer places schema files in a schemas folder on your computer.
The following schema resources are available:
The install places the .xsd schema files in the directory c:\Program
Files\Microsoft Great Plains\eConnect9\XML Schema\Incoming XSD
Individual Schemas. The files in the directory contain the schema for
each eConnect XML document.
The install places a file named eConnect.xsd that contains the schema
definition for all eConnect XML documents. The install typicall...Saving DataSet as XML in ADO format using VB.NET
I am trying to convert a lot of web reports from ASP/VB to
ASP.NET/VB.NET. I would like to save my dataset in XML and then use
XSLT to transform the XML. The catch is I would like to have the XML
in the format that ADO uses versus the default format in which ADO.NET
uses. Currently, I am using ADO within .NET, but I am concerned about
the performance and it might improve if I used the native data
providers for .NET. I am not sure if I am missing something but how do
I save the .NET DataSet to XML in the OLD ADO format?
Thanks for you help in advance and it is most appreciated.
In the ...How do you get a conditional output to show in color
I need to have dates that have past show in red on my spread sheet. Can I do
that with an IF statement?
Have a look at Conditional Formatting in Help, its all there and it will do
that with no problems,
"Luke" <Luke@discussions.microsoft.com> wrote in message
>I need to have dates that have past show in red on my spread sheet. Can I
> that with an IF statement?
...XML variable for description on receipt?
Hi, I would like to add a description (actually all of those 3 extended
descriptions) to display on the printed receipt under the main description.
What is the variable to do that?
"Zorian" <Zorian@discussions.microsoft.com> wrote in message
> Hi, I would like to add a description (actually all of those 3 extended
> descriptions) to display on the printed receipt un...Ferrero's Conditional Bar Chart Qs
I've discovered Ed Ferrero's Conditional Bar Chart code and downloaded
the sample workbook, as I think it could be very useful in my work.
You can find it here:
However, I need to make some modifications and am having a very hard
time following the coding .... so, I can't make the necessary
modifications! In theory, it should be fairly easy ... my situation
** User makes a selection in cell A7 (via Validation)
** this value if fed (via direct link) to A97 ... B97:AN97 contain an
HLOOKUP based on A97
** ...xml to SQL
Hey we have a project in which a company produces a XML page in reply to
actions on it's site.
I see that SQL 2000 works well with XML so Can someone point me in the right
I would like to take the XML from thier SQL and have it "post" to own sql
server (add,create, data, modifity and delete data on the fly).
I was looking at doing XML to HTML and then passing to some a ASP but if we
can grab from the responsetext then we could save time and headaches.
Now I really know next to nothing about XML but I am reading all the
newsgroups and pulled now TONS of xml / sql stuff ...Conditional Formatting 11-13-07
I have a continuous form that lists members of a
class. The database includes two classifying T/F
flags indicating if a member is missing or deceased.
The RecordSource query is normally filtered such
that these two classes are excluded. However, I
have a command button that turns off the filter via
event code such that all members are listed. The
name fields have conditional formatting, with the
missing members shown in red and the deceased
show in blue.
It seems that all of a sudden the deceased members
lost their conditional formatting:
Expression is --- [Deceased]=True show in Blue
Expr...new xml file is larger than the original
i'm working on a windows application that will edit and create xml files from
another application. the original file is 83k, the one created by my vb.net
program is 153k but all i add is a new xmlelement when i use the other
program and add a xmlelement is only increased the file to 85k. how come my
application increased 70k in size and also added the <?xml version="1.0"?>
when i didn't tell it to.
how do i duplicated a xml file and only add the xml element that i want to
insert. where did the extra 70k come from.
here is my code:
Dim newEvtEnr...xml data in excel
I have designed an excel template with tabular format (row by row input) for
user input. I have to make the validation for those input. My question is
that is it possible to use XML schema as the input format template and use
it for the data validation like normal XML validation. Could anyone suggest
me how to do that??
...XSLT, XML to XML
I would like to transform this;
<?xml version="1.0" encoding="utf-8" ?>
<?xml version="1.0" encoding="utf-8" ?>
Basically I am hoping to use XslTransform and an XSLT stylesheet to change
the format of some input XML so i...