cellreference3d.cs

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

using System;

using Microsoft.Fawvw.Components.NExcel.Biff;

namespace Microsoft.Fawvw.Components.NExcel.Biff.Formula
{
	
	/// <summary> A 3d cell reference in a formula</summary>
	class CellReference3d:Operand, ParsedThing
	{
		/// <summary> Accessor for the column
		/// 
		/// </summary>
		/// <returns> the column number
		/// </returns>
		virtual public int Column
		{
			get
			{
				return column;
			}
			
		}
		/// <summary> Accessor for the row
		/// 
		/// </summary>
		/// <returns> the row number
		/// </returns>
		virtual public int Row
		{
			get
			{
				return row;
			}
			
		}
		/// <summary> Gets the token representation of this item in RPN
		/// 
		/// </summary>
		/// <returns> the bytes applicable to this formula
		/// </returns>
		override internal sbyte[] Bytes
		{
			get
			{
				sbyte[] data = new sbyte[7];
				data[0] = Token.REF3D.Code;
				
				IntegerHelper.getTwoBytes(sheet, data, 1);
				IntegerHelper.getTwoBytes(row, data, 3);
				
				int grcol = column;
				
				// Set the row/column relative bits if applicable
				if (rowRelative)
				{
					grcol |= 0x8000;
				}
				
				if (columnRelative)
				{
					grcol |= 0x4000;
				}
				
				IntegerHelper.getTwoBytes(grcol, data, 5);
				
				return data;
			}
			
		}
		/// <summary> Indicates whether the column reference is relative or absolute</summary>
		private bool columnRelative;
		
		/// <summary> Indicates whether the row reference is relative or absolute</summary>
		private bool rowRelative;
		
		/// <summary> The column reference</summary>
		private int column;
		
		/// <summary> The row reference</summary>
		private int row;
		
		/// <summary> The cell containing the formula.  Stored in order to determine
		/// relative cell values
		/// </summary>
		private Cell relativeTo;
		
		/// <summary> The sheet which the reference is present on</summary>
		private int sheet;
		
		/// <summary> A handle to the container of the external sheets ie. the workbook</summary>
		private ExternalSheet workbook;
		
		/// <summary> Constructor
		/// 
		/// </summary>
		/// <param name="the">cell containing the formula
		/// </param>
		/// <param name="the">list of external sheets
		/// </param>
		public CellReference3d(Cell rt, ExternalSheet w)
		{
			relativeTo = rt;
			workbook = w;
		}
		
		/// <summary> Constructs this object from a string
		/// 
		/// </summary>
		/// <param name="s">the string
		/// </param>
		/// <param name="w">the external sheet
		/// </param>
		/// <exception cref=""> FormulaException
		/// </exception>
		public CellReference3d(string s, ExternalSheet w)
		{
			workbook = w;
			columnRelative = true;
			rowRelative = true;
			
			// Get the cell details
			int sep = s.IndexOf((System.Char) '!');
			string cellString = s.Substring(sep + 1);
			column = CellReferenceHelper.getColumn(cellString);
			row = CellReferenceHelper.getRow(cellString);
			
			// Get the sheet index
			string sheetName = s.Substring(0, (sep) - (0));
			
			// Remove single quotes, if they exist
			if (sheetName[0] == '\'' && sheetName[sheetName.Length - 1] == '\'')
			{
				sheetName = sheetName.Substring(1, (sheetName.Length - 1) - (1));
			}
			sheet = w.getExternalSheetIndex(sheetName);
			
			if (sheet < 0)
			{
				throw new FormulaException(FormulaException.sheetRefNotFound, sheetName);
			}
		}
		
		/// <summary> Reads the ptg data from the array starting at the specified position
		/// 
		/// </summary>
		/// <param name="data">the RPN array
		/// </param>
		/// <param name="pos">the current position in the array, excluding the ptg identifier
		/// </param>
		/// <returns> the number of bytes read
		/// </returns>
		public virtual int read(sbyte[] data, int pos)
		{
			sheet = IntegerHelper.getInt(data[pos], data[pos + 1]);
			row = IntegerHelper.getInt(data[pos + 2], data[pos + 3]);
			int columnMask = IntegerHelper.getInt(data[pos + 4], data[pos + 5]);
			column = columnMask & 0x00ff;
			columnRelative = ((columnMask & 0x4000) != 0);
			rowRelative = ((columnMask & 0x8000) != 0);
			
			return 6;
		}
		
		/// <summary> Gets the string version of this cell reference
		/// 
		/// </summary>
		/// <param name="buf">the buffer to append to
		/// </param>
		public override void  getString(System.Text.StringBuilder buf)
		{
			CellReferenceHelper.getCellReference(sheet, column, !columnRelative, row, !rowRelative, workbook, buf);
		}
		
		/// <summary> Adjusts all the relative cell references in this formula by the
		/// amount specified.  Used when copying formulas
		/// 
		/// </summary>
		/// <param name="colAdjust">the amount to add on to each relative cell reference
		/// </param>
		/// <param name="rowAdjust">the amount to add on to each relative row reference
		/// </param>
		public override void  adjustRelativeCellReferences(int colAdjust, int rowAdjust)
		{
			if (columnRelative)
			{
				column += colAdjust;
			}
			
			if (rowRelative)
			{
				row += rowAdjust;
			}
		}
		
		/// <summary> Called when a column is inserted on the specified sheet.  Tells
		/// the formula  parser to update all of its cell references beyond this
		/// column
		/// 
		/// </summary>
		/// <param name="sheetIndex">the sheet on which the column was inserted
		/// </param>
		/// <param name="col">the column number which was inserted
		/// </param>
		/// <param name="currentSheet">TRUE if this formula is on the sheet in which the
		/// column was inserted, FALSE otherwise
		/// </param>
		public override void  columnInserted(int sheetIndex, int col, bool currentSheet)
		{
			if (sheetIndex != sheet)
			{
				return ;
			}
			
			if (column >= col)
			{
				column++;
			}
		}
		
		
		/// <summary> Called when a column is inserted on the specified sheet.  Tells
		/// the formula  parser to update all of its cell references beyond this
		/// column
		/// 
		/// </summary>
		/// <param name="sheetIndex">the sheet on which the column was removed
		/// </param>
		/// <param name="col">the column number which was removed
		/// </param>
		/// <param name="currentSheet">TRUE if this formula is on the sheet in which the
		/// column was inserted, FALSE otherwise
		/// </param>
		internal override void  columnRemoved(int sheetIndex, int col, bool currentSheet)
		{
			if (sheetIndex != sheet)
			{
				return ;
			}
			
			if (column >= col)
			{
				column--;
			}
		}
		
		/// <summary> Called when a column is inserted on the specified sheet.  Tells
		/// the formula  parser to update all of its cell references beyond this
		/// column
		/// 
		/// </summary>
		/// <param name="sheetIndex">the sheet on which the row was inserted
		/// </param>
		/// <param name="row">the row number which was inserted
		/// </param>
		/// <param name="currentSheet">TRUE if this formula is on the sheet in which the
		/// column was inserted, FALSE otherwise
		/// </param>
		internal override void  rowInserted(int sheetIndex, int r, bool currentSheet)
		{
			if (sheetIndex != sheet)
			{
				return ;
			}
			
			if (row >= r)
			{
				row++;
			}
		}
		
		/// <summary> Called when a column is inserted on the specified sheet.  Tells
		/// the formula  parser to update all of its cell references beyond this
		/// column
		/// 
		/// </summary>
		/// <param name="sheetIndex">the sheet on which the row was removed
		/// </param>
		/// <param name="row">the row number which was removed
		/// </param>
		/// <param name="currentSheet">TRUE if this formula is on the sheet in which the
		/// column was inserted, FALSE otherwise
		/// </param>
		internal override void  rowRemoved(int sheetIndex, int r, bool currentSheet)
		{
			if (sheetIndex != sheet)
			{
				return ;
			}
			
			if (row >= r)
			{
				row--;
			}
		}
	}
}