EDN Admin
Well-known member
<div style="overflow:auto;background-color:white;line-height:100% ! important;font-family:Courier New;font-size:11px <table style="border-width:0px;margin:2px 0px;width:99%;border-collapse:collapse;background-color:rgb(255, 255, 255)" cellpadding=0 cellspacing=0><col style="font-family:Courier New;font-size:11px;padding-left:10px;white-space:nowrap <tbody><tr><td><font style="font-size:11px IDataObject </font><font style="color:red dataObject</font><font style="font-size:11px = </font><font style="color:blue Clipboard</font><font style="font-size:11px .GetDataObject(); </font></td></tr><tr><td style="background-color:rgb(247, 247, 247) MemoryStream <font style="color:red obj</font><font style="font-size:11px = (MemoryStream)dataObject.GetData("Xml Spreadsheet"); </font></td></tr><tr><td>DataSet <font style="color:red dataset</font><font style="font-size:11px = </font><font style="color:blue new</font><font style="font-size:11px DataSet(); </font></td></tr><tr><td style="background-color:rgb(247, 247, 247) dataset.ReadXml(obj); // errormsg: "., hexadecimal value 0x00, //is an invalid character. Line 18, position 45."
</td></tr></tbody></table> Hi
I am having trouble importing data from an xml spreadsheet that is placed on the clipboard.
It seems that excel formats the spreadsheet differently based on the range from which I am copying data.
When I copy cells from the columns a..z it all seems to work ok, and I can use datatable.Load(memoryStream)
When I copy cells beyond that range, e.g. cell AA1, excel apparently formats the xml spreadsheet on the clipboard
with some hexadecimal values.
After a lot of testing and clicking back and forth, and it seems that the problem is related to the spreadsheets I am copying from, but I cant figure out why.
Is there any way around this problem?
View the full article
</td></tr></tbody></table> Hi
I am having trouble importing data from an xml spreadsheet that is placed on the clipboard.
It seems that excel formats the spreadsheet differently based on the range from which I am copying data.
When I copy cells from the columns a..z it all seems to work ok, and I can use datatable.Load(memoryStream)
When I copy cells beyond that range, e.g. cell AA1, excel apparently formats the xml spreadsheet on the clipboard
with some hexadecimal values.
After a lot of testing and clicking back and forth, and it seems that the problem is related to the spreadsheets I am copying from, but I cant figure out why.
Is there any way around this problem?
View the full article