Hi Every one,
i want to copy data from open office excel and paste it into listview in windows application.i know how to do it int microsoft excel but i am not able to do it in open office can any one tell me please.
How copy data from open office excel and paste in listview
#piccshare_pic_options, #piccshare_pic_options > *, #piccshare_tint, #piccshare_logo { border-radius: 0; -moz-border-radius: 0; border: none; margin: 0; padding: 0; }
Dhirendra MisraPosted Jan 6, 2014, 1:14 AM
Open Office Document formats is just simple Zip file containing XML files. Xml contains schema as well as data and reading them is pretty simple.
If you just want to extract text out of them, then its easier, otherwise you can use System.Xml.Linq to read xml files to extract the data.
To test, you can take any open office document, rename it as from something.ods to something.zip and extract and study its contents. You can use ISharpZip library to unzip in C# and use Linq to read data from xml file.
Thanks
http://social.msdn.microsoft.com/Forums/en-US/32f49c89-fd07-43da-828d-4693db4b4dbb/how-to-zip-and-unzip-files-using-sharpziplib?forum=csharplanguage