一套非常优秀的基于C#+Excel+Xml实现的Excel2Xml类库源程序代码

<?xml version="1.0"?> <doc> <assembly> <name>Yogesh.ExcelXml</name> </assembly> <members> <member name="T:Yogesh.ExcelXml.CellIndexInfo"> <summary> Cell Index Information </summary> </member> <member name="P:Yogesh.ExcelXml.CellIndexInfo.RowIndex"> <summary> Row index starting from 0 </summary> </member> <member name="P:Yogesh.ExcelXml.CellIndexInfo.ColumnIndex"> <summary> Column index starting from 0 </summary> </member> <member name="P:Yogesh.ExcelXml.CellIndexInfo.ExcelColumnIndex"> <summary> Index in excel format, eg. A1 </summary> </member> <member name="T:Yogesh.ExcelXml.Cell"> <summary> Cell class represents a single cell in a worksheet </summary> <remarks> Cell class represents a single cell in a worksheet. <para>You cannot directly declare a instance of a cell from your code by using <c>new</c> keyword. The only way to access a cell is to retrieve it from a worksheet or a row.</para> </remarks> </member> <member name="T:Yogesh.ExcelXml.Styles"> <summary> Style class for cells, rows and worksheets </summary> </member> <member name="T:Yogesh.ExcelXml.CellSettingsApplier"> <summary> Gets and sets various cell and range properties </summary> </member> <member name="T:Yogesh.ExcelXml.IStyle"> <summary> Style settings container </summary> </member> <member name="P:Yogesh.ExcelXml.IStyle.Font"> <summary> Font options </summary> </member> <member name="P:Yogesh.ExcelXml.IStyle.Alignment"> <summary> Alignment options </summary> </member> <member name="P:Yogesh.ExcelXml.IStyle.Interior"> <summary> Cell fill options </summary> </member> <member name="P:Yogesh.ExcelXml.IStyle.Border"> <summary> Cell border options </summary> </member> <member name="P:Yogesh.ExcelXml.IStyle.DisplayFormat"> <summary> Cell display format </summary> </member> <member name="P:Yogesh.ExcelXml.IStyle.CustomFormatString"> <summary> Custom display format string </summary> </member> <member name="P:Yogesh.ExcelXml.Styles.Font"> <summary> Gets or sets the font options </summary> </member> <member name="P:Yogesh.ExcelXml.Styles.Alignment"> <summary> Gets or sets cell alignment options </summary> </member> <member name="P:Yogesh.ExcelXml.Styles.Interior"> <summary> Gets or sets interior options </summary> </member> <member name="P:Yogesh.ExcelXml.Styles.Border"> <summary> Gets or sets border settings </summary> </member> <member name="P:Yogesh.ExcelXml.Styles.DisplayFormat"> <summary> Gets or sets the cell display format </summary> </member> <member name="P:Yogesh.ExcelXml.Styles.CustomFormatString"> <summary> Gets or sets custom dispkay format string </summary> </member> <member name="P:Yogesh.ExcelXml.Styles.Style"> <summary> Returns the <see cref="T:Yogesh.ExcelXml.XmlStyle"/> reference of the cell </summary> </member> <member name="M:Yogesh.ExcelXml.Cell.GetValue``1"> <summary> Gets the value of a cell converted to a system type </summary> <typeparam name="T">Type to convert to</typeparam> <returns>Cell value converted to system type</returns> </member> <member name="M:Yogesh.ExcelXml.Cell.IsEmpty"> <summary> Checks whether the cell has no content and no comment </summary> <returns>true if empty, false otherwise</returns> </member> <member name="M:Yogesh.ExcelXml.Cell.Empty"> <summary> Empties the content of a cell </summary> </member> <member name="M:Yogesh.ExcelXml.Cell.Unmerge"> <summary> Unmerges a cell </summary> </member> <member name="M:Yogesh.ExcelXml.Cell.Delete"> <summary> Deletes a cell from the parent row </summary> </member> <member name="P:Yogesh.ExcelXml.Cell.ContentType"> <summary> Returns the cell content type </summary> </member> <member name="P:Yogesh.ExcelXml.Cell.Index"> <summary> Index information of the cell </summary> </member> <member name="P:Yogesh.ExcelXml.Cell.Comment"> <summary> Gets or sets the comment for the cell </summary> <remarks>Comment is in raw html format which means you can insert bold and italics markers just like regular html</remarks> </member> <member name="P:Yogesh.ExcelXml.Cell.ColumnSpan"> <summary> Gets the number of columns merged together, starting with this cell </summary> </member> <member name="P:Yogesh.ExcelXml.Cell.RowSpan"> <summary> Gets the number of rows merged together, starting with this cell </summary> </member> <member name="P:Yogesh.ExcelXml.Cell.HRef"> <summary> Gets or sets the a external reference as a link </summary> <remarks>The value of HRef is not verified.</remarks> </member> <member name="P:Yogesh.ExcelXml.Cell.Value"> <summary> Gets or sets the value of the cell </summary> <remarks> Value returns a boxed <see cref="T:System.String"/> value of the cell or sets the value of the cell to... <list type="number"> <item> <term><see cref="T:System.String"/></term><description></description> </item> <item> <term><see cref="T:System.Boolean"/></term><description></description> </item> <item> <term><see cref="T:System.Byte"/></term><description></description> </item> <item> <term><see cref="T:System.Int16"/></term><description></description> </item> <item> <term><see cref="T:System.Int32"/></term><description></description> </item> <item> <term><see cref="T:System.Int64"/></term><description></description> </item> <item> <term><see cref="T:System.Double"/></term><description></description> </item> <item> <term><see cref="T:System.Decimal"/></term><description></description> </item> <item> <term><see cref="T:System.DateTime"/></term><description></description> </item> <item> <term><see cref="T:Yogesh.ExcelXml.Cell"/></term><description></description> </item> <item>