C# 读取操作excel文件

excel操作实例源码

using System;
using System.IO;
using System.Collections.Generic;
using System.Text;
using System.xml;
using System.xml.Serialization;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;

namespace QiHe.CodeLib
{
    /// 

    /// xmlFile load and save object from and to xml file;
    /// 
	
    public class xmlData
    {
        public static DataType Load（string xmlfile）
        {
            DataType data;
            Type datatype = typeof（DataType）;
            xmlSerializer mySerializer = new xmlSerializer（datatype）;
            if （File.Exists（xmlfile））
            {
                using （xmlTextReader reader = new xmlTextReader（xmlfile））
                {
                    data = （DataType）m

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     文件        1319  2006-05-19 10:53  CodeLib\Encoder\Bin2Hex.cs
     文件       10552  2006-08-24 18:00  CodeLib\FileIO.cs
     文件        3296  2006-12-02 20:27  CodeLib\FileSelector.cs
     文件        1389  2006-10-21 20:29  CodeLib\Pair.cs
     文件        2952  2006-10-25 10:59  CodeLib\StreamHelper.cs
     文件       11574  2006-11-01 10:19  Office\CompoundDocumentFormat\CompoundDocument.cs
     文件        1092  2006-05-18 13:17  Office\CompoundDocumentFormat\CompoundFileHeader.cs
     文件        5664  2006-05-26 16:09  Office\CompoundDocumentFormat\DirectoryEntry.cs
     文件         326  2006-05-18 11:54  Office\CompoundDocumentFormat\Endianness.cs
     文件         410  2006-05-19 10:03  Office\CompoundDocumentFormat\EntryType.cs
     文件        3378  2006-05-18 13:17  Office\CompoundDocumentFormat\FileHeader.cs
     文件         247  2006-05-19 10:04  Office\CompoundDocumentFormat\NodeColor.cs
     文件         778  2006-05-18 12:06  Office\CompoundDocumentFormat\SID.cs
     文件         853  2006-05-26 10:35  Office\Excel\CellCollection.cs
     文件        1777  2006-05-26 15:59  Office\Excel\ColorPalette.cs
     文件         248  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBlip.cs
     文件         262  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBlipBitmapPS.cs
     文件        3581  2007-05-26 16:32  Office\Excel\EscherRecords\EscherRecord.cs
     文件         258  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtAlignRule.cs
     文件         252  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtAnchor.cs
     文件         254  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtArcRule.cs
     文件         264  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBlipBitmapDIB.cs
     文件         266  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBlipBitmapJPEG.cs
     文件         264  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBlipBitmapPNG.cs
     文件         252  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBlipEnd.cs
     文件         256  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBlipStart.cs
     文件        1216  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBSE.cs
     文件         273  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtBstoreContainer.cs
     文件         262  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtCalloutRule.cs
     文件         262  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtChildAnchor.cs
     文件        1070  2007-05-26 16:32  Office\Excel\EscherRecords\MsofbtClientAnchor.cs
............此处省略99个文件信息