| /******************************************************************************* | |
| * You may amend and distribute as you like, but don't remove this header! | |
| * | |
| * EPPlus provides server-side generation of Excel 2007/2010 spreadsheets. | |
| * See http://www.codeplex.com/EPPlus for details. | |
| * | |
| * Copyright (C) 2011 Jan Källman | |
| * | |
| * This library is free software; you can redistribute it and/or | |
| * modify it under the terms of the GNU Lesser General Public | |
| * License as published by the Free Software Foundation; either | |
| * version 2.1 of the License, or (at your option) any later version. | |
| * This library is distributed in the hope that it will be useful, | |
| * but WITHOUT ANY WARRANTY; without even the implied warranty of | |
| * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | |
| * See the GNU Lesser General Public License for more details. | |
| * | |
| * The GNU Lesser General Public License can be viewed at http://www.opensource.org/licenses/lgpl-license.php | |
| * If you unfamiliar with this license or have questions about it, here is an http://www.gnu.org/licenses/gpl-faq.html | |
| * | |
| * All code and executables are provided "as is" with no warranty either express or implied. | |
| * The author accepts no liability for any damage or loss of business that this product may cause. | |
| * | |
| * Code change notes: | |
| * | |
| * Author Change Date | |
| * ****************************************************************************** | |
| * Mats Alm Added 2015-12-28 | |
| *******************************************************************************/ | |
| using OfficeOpenXml.FormulaParsing.LexicalAnalysis.TokenSeparatorHandlers; | |
| using System.Text.RegularExpressions; | |
| namespace OfficeOpenXml.FormulaParsing.LexicalAnalysis | |
| { | |
| public class TokenHandler : ITokenIndexProvider | |
| { | |
| public TokenHandler(TokenizerContext context, ITokenFactory tokenFactory, ITokenSeparatorProvider tokenProvider) | |
| { | |
| _context = context; | |
| _tokenFactory = tokenFactory; | |
| _tokenProvider = tokenProvider; | |
| } | |
| private readonly TokenizerContext _context; | |
| private readonly ITokenSeparatorProvider _tokenProvider; | |
| private readonly ITokenFactory _tokenFactory; | |
| private int _tokenIndex = -1; | |
| public string Worksheet { get; set; } | |
| public bool HasMore() | |
| { | |
| return _tokenIndex < (_context.FormulaChars.Length - 1); | |
| } | |
| public void Next() | |
| { | |
| _tokenIndex++; | |
| Handle(); | |
| } | |
| private void Handle() | |
| { | |
| var c = _context.FormulaChars[_tokenIndex]; | |
| Token tokenSeparator; | |
| if (CharIsTokenSeparator(c, out tokenSeparator)) | |
| { | |
| if (TokenSeparatorHandler.Handle(c, tokenSeparator, _context, this)) | |
| { | |
| return; | |
| } | |
| if (_context.CurrentTokenHasValue) | |
| { | |
| if (Regex.IsMatch(_context.CurrentToken, "^\"*$")) | |
| { | |
| _context.AddToken(_tokenFactory.Create(_context.CurrentToken, TokenType.StringContent)); | |
| } | |
| else | |
| { | |
| _context.AddToken(CreateToken(_context, Worksheet)); | |
| } | |
| //If the a next token is an opening parantheses and the previous token is interpeted as an address or name, then the currenct token is a function | |
| if (tokenSeparator.TokenType == TokenType.OpeningParenthesis && (_context.LastToken.TokenType == TokenType.ExcelAddress || _context.LastToken.TokenType == TokenType.NameValue)) | |
| { | |
| _context.LastToken.TokenType = TokenType.Function; | |
| } | |
| } | |
| if (tokenSeparator.Value == "-") | |
| { | |
| if (TokenIsNegator(_context)) | |
| { | |
| _context.AddToken(new Token("-", TokenType.Negator)); | |
| return; | |
| } | |
| } | |
| _context.AddToken(tokenSeparator); | |
| _context.NewToken(); | |
| return; | |
| } | |
| _context.AppendToCurrentToken(c); | |
| } | |
| private bool CharIsTokenSeparator(char c, out Token token) | |
| { | |
| var result = _tokenProvider.Tokens.ContainsKey(c.ToString()); | |
| token = result ? token = _tokenProvider.Tokens[c.ToString()] : null; | |
| return result; | |
| } | |
| private static bool TokenIsNegator(TokenizerContext context) | |
| { | |
| return TokenIsNegator(context.LastToken); | |
| } | |
| private static bool TokenIsNegator(Token t) | |
| { | |
| return t == null | |
| || | |
| t.TokenType == TokenType.Operator | |
| || | |
| t.TokenType == TokenType.OpeningParenthesis | |
| || | |
| t.TokenType == TokenType.Comma | |
| || | |
| t.TokenType == TokenType.SemiColon | |
| || | |
| t.TokenType == TokenType.OpeningEnumerable; | |
| } | |
| private Token CreateToken(TokenizerContext context, string worksheet) | |
| { | |
| if (context.CurrentToken == "-") | |
| { | |
| if (context.LastToken == null && context.LastToken.TokenType == TokenType.Operator) | |
| { | |
| return new Token("-", TokenType.Negator); | |
| } | |
| } | |
| return _tokenFactory.Create(context.Result, context.CurrentToken, worksheet); | |
| } | |
| int ITokenIndexProvider.Index | |
| { | |
| get { return _tokenIndex; } | |
| } | |
| void ITokenIndexProvider.MoveIndexPointerForward() | |
| { | |
| _tokenIndex++; | |
| } | |
| } | |
| } |