No announcements
Found 3511843 threads
-
1 VotesCannot parse using OPENXML with namespace
To use namespaces with OPENXML / sp_xml_preparedocument simply pass the namespaces as the third argument to sp_xml_preparedocument, eg: EXEC ...Answered | 5 Replies | 26056 Views | Created by Dustin007 - Friday, February 5, 2010 10:48 AM | Last reply by Bulldog61 - Thursday, June 10, 2010 9:57 PM
-
1 Votes
Problem in Parsing AMAZON XML Using Openxml
You can use both OPENXML and xml xquery to achieve this: DECLARE @xmlData XML; set @xmlData = 'Answered | 4 Replies | 7933 Views | Created by Ehsanul Haque - Sunday, November 22, 2009 7:11 AM | Last reply by Ehsanul Haque - Wednesday, November 25, 2009 6:54 PM -
0 Votes
OpenXML
ADO.NET can used to manipulate data in Excel document using System.OleDb namespace.Answered | 5 Replies | 3788 Views | Created by Sruthi M - Tuesday, April 20, 2010 7:04 AM | Last reply by Ramesh Swaminathan - Tuesday, April 20, 2010 8:36 AM -
3 Votes
OpenXML not parsing data SQL Server 2008 R2
Hi, in my demo, I'm showing how to use the XML datatype, OR OPENXML.Answered | 9 Replies | 7306 Views | Created by Phil Deibel - Wednesday, November 14, 2012 1:55 PM | Last reply by wBob - Thursday, November 15, 2012 4:52 PM -
0 Votes
xml node parse getting error while using openxml method
i'm working on importing xml data into sql using openxml method is working fine .but the data below is getting error while parse because of the single Quote or some other ...Answered | 1 Replies | 9948 Views | Created by Sudhesh.G - Thursday, March 10, 2011 12:41 PM | Last reply by Russ Loski - Thursday, March 10, 2011 3:05 PM -
1 Votes
How to 'parse' raw HTML text to Word format using OpenXML?
> Is there a recommended way of parsing HTML back to Open XML?Answered | 2 Replies | 5150 Views | Created by OCS.New - Sunday, August 23, 2015 11:00 AM | Last reply by Cindy Meister MVP - Monday, August 24, 2015 2:13 PM -
0 Votes
How to protect document with password using C# and openxml
In my option, you could not protect an Excel file with openxml.Answered | 2 Replies | 12179 Views | Created by Karan Gupta - Monday, June 8, 2015 6:46 AM | Last reply by Karan Gupta - Thursday, June 11, 2015 6:02 AM -
1 Votes
Unable to Parse XML using Sp_XML_Prepare document when namespaces are present
Hello, You can use the WITH XMLNAMESPACES (Transact-SQL) command to add namespaces to your xQuery, see Add Namespaces to Queries with ...Answered | 3 Replies | 625 Views | Created by Hardil1026 - Tuesday, July 5, 2016 11:10 AM | Last reply by Olaf Helper - Tuesday, July 5, 2016 11:55 AM -
2 Votes
Cannot use System.XML namespace in vb.net
When I try to import it, I get the following error: Namespace or type specified in the Imports 'System.xml' doesn't contain ...Answered | 4 Replies | 3551 Views | Created by Christan - Tuesday, August 28, 2012 6:11 PM | Last reply by Devon_Nullman - Friday, August 31, 2012 3:45 PM -
1 Votes
default xmlns declartion breaks OPENXML ?
hi, check the below ...Answered | 3 Replies | 10336 Views | Created by cmon_stoke - Wednesday, May 5, 2010 7:25 AM | Last reply by KiranKumar.Y - Wednesday, May 5, 2010 9:35 AM -
0 Votes
Read excel 2003 using openxml
No, you can't use OpenXML SDK to read any kind of Excel 2003 Data.Answered | 1 Replies | 8699 Views | Created by frdotnet - Tuesday, March 22, 2011 12:37 AM | Last reply by Anton Staykov - Tuesday, March 22, 2011 9:59 PM -
1 Votes
XML parsing and xml namespaces
Since you weren't using XPath, there is no need for adding any namespace manager.Answered | 7 Replies | 8082 Views | Created by Vincent Rich - Monday, September 17, 2012 11:22 AM | Last reply by ziman01 - Friday, September 21, 2012 5:46 AM -
1 Votes
OpenXML
Found the forum here, http://social.msdn.microsoft.com/Forums/en-US/oxmlsdk/threadsAnswered | 1 Replies | 4111 Views | Created by ResidentX10 - Thursday, June 7, 2012 4:53 PM | Last reply by ResidentX10 - Thursday, June 7, 2012 5:44 PM -
0 Votes
using OPENXML inside transaction and try/catch block - best practices
Re OPENXML v XML datatype in SQL Server, anecdotally, some people say OPENXML is "faster" than the XML datatype and methods but it really depends on ...Answered | 4 Replies | 1905 Views | Created by Pakojones - Tuesday, September 30, 2014 1:52 PM | Last reply by wBob - Wednesday, October 1, 2014 5:12 PM -
0 Votes
Alternative to OpenXML
>>Is there any alternative to programming the OpenXML API?Answered | 1 Replies | 1740 Views | Created by JBDevoArch - Monday, August 31, 2015 2:49 PM | Last reply by David_JunFeng - Wednesday, September 2, 2015 8:54 AM -
0 Votes
Watermarking Office documents using OpenXML
Hello Lesley, I hope the discussion thread in the past will help you, ...Answered | 3 Replies | 6198 Views | Created by Lesley Fernandez - Monday, August 6, 2012 11:54 AM | Last reply by Kazunori Matsuura (Microsoft ex-FTE) - Tuesday, August 7, 2012 7:24 AM -
0 Votes
Using OpenXML SDK for Universal Apps?
https://social.msdn.microsoft.com/Forums/office/en-US/4850a45f-5fe5-4aee-b6a3-987a95bded0d/when-support-windows-runtime-?Answered | 1 Replies | 4546 Views | Created by WardH - Monday, June 1, 2015 8:52 AM | Last reply by Cindy Meister MVP - Monday, June 1, 2015 5:46 PM -
0 Votes
Parsing XML with Namespaces C#
= null) { val = b.Value; } In essence you are parsing based on those names, and ignoring namespaces.Answered | 2 Replies | 17491 Views | Created by exdox77 - Wednesday, October 24, 2012 12:00 AM | Last reply by DDarwin - Wednesday, October 24, 2012 8:43 PM -
0 Votes
How to delete Content Control in Word document using OpenXML Format SDK?
> How to delete Content Control in Word document using OpenXML Format SDK?Answered | 1 Replies | 1726 Views | Created by Selvam S - Thursday, October 8, 2015 11:40 AM | Last reply by Edward8520 - Friday, October 9, 2015 2:54 AM -
0 Votes
Read data from XML using OpenXML
" Microsoft official documentation:Answered | 9 Replies | 1126 Views | Created by Sudip_inn - Friday, April 3, 2020 10:09 AM | Last reply by Yitzhak Khabinsky - Tuesday, April 7, 2020 4:31 PM - Items 1 to 20 of 3511843 Next ›
No announcements
