clipboardformat, Xml Spreadsheet

E

EP

Can anyone help me with copying spreadsheet format to the clipboard.

I have this text

<Workbook>
<Worksheet>
<Table>
<Row>
<Cell ss:Type="String">MyData</Cell>
<Cell ss:Type="String">MyData</Cell>
</Row>
</Table>
</Worksheet>
</Workbook>

I put that into a memorystream (UTF8),
then call
DataObject ob = new DataObject();
ob.SetData("XML Spreadsheet", ob);
Clipboard.SetDataObject(ob, true)

When I try to paste this into excel it complains that it can't paste the
data.

what am I doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using System.Xml.XmlDocument to parse an XML Excel document 1
xml parser and working with prefix, name and attributes. 3
Value 1 in excel cell show as 0.99999999999999978 once save in XMLformat 3
QueryTables.Add and XML 0
xsl to xml problem during load 0
Excel question: "Problems during load" -> Table 1
Newline in Xml text content (Excel) 1
Generating Excel XML with embedded char(10)s 1

Top