externalsheet.cs

Excel的操作,其中可以读取及写入Excel 文件

using System;

using Microsoft.Fawvw.Components.NExcel.Read.Biff;

namespace Microsoft.Fawvw.Components.NExcel.Biff.Formula
{
	
	/// <summary> Interface which exposes the methods needed by formulas 
	/// to access external sheet records
	/// </summary>
	public interface ExternalSheet
		{
			/// <summary> Parsing of formulas is only supported for a subset of the available
			/// biff version, so we need to test to see if this version is acceptable
			/// 
			/// </summary>
			/// <returns> the BOF record, which 
			/// </returns>
			BOFRecord WorkbookBof
			{
				get;
				
			}
			/// <summary> Gets the name of the external sheet specified by the index
			/// 
			/// </summary>
			/// <param name="index">the external sheet index
			/// </param>
			/// <returns> the name of the external sheet
			/// </returns>
			string getExternalSheetName(int index);
			
			/// <summary> Gets the index of the first external sheet for the name
			/// 
			/// </summary>
			/// <param name="sheetName">the name of the external sheet
			/// </param>
			/// <returns>  the index of the external sheet with the specified name
			/// </returns>
			int getExternalSheetIndex(string sheetName);
			
			/// <summary> Gets the index of the first external sheet for the name
			/// 
			/// </summary>
			/// <param name="index">the external sheet index
			/// </param>
			/// <returns> the sheet index of the external sheet index
			/// </returns>
			int getExternalSheetIndex(int index);
			
			/// <summary> Gets the index of the last external sheet for the name
			/// 
			/// </summary>
			/// <param name="sheetName">the name of the external sheet
			/// </param>
			/// <returns>  the index of the external sheet with the specified name
			/// </returns>
			int getLastExternalSheetIndex(string sheetName);
			
			/// <summary> Gets the index of the first external sheet for the name
			/// 
			/// </summary>
			/// <param name="index">the external sheet index
			/// </param>
			/// <returns> the sheet index of the external sheet index
			/// </returns>
			int getLastExternalSheetIndex(int index);
		}
}