yylex.java

java直接操作execl文件,读写建立新文件

		/* 49 */ YY_NOT_ACCEPT,
		/* 50 */ YY_NOT_ACCEPT,
		/* 51 */ YY_NOT_ACCEPT,
		/* 52 */ YY_NOT_ACCEPT,
		/* 53 */ YY_NOT_ACCEPT,
		/* 54 */ YY_NOT_ACCEPT,
		/* 55 */ YY_NOT_ACCEPT,
		/* 56 */ YY_NOT_ACCEPT,
		/* 57 */ YY_NOT_ACCEPT,
		/* 58 */ YY_NOT_ACCEPT,
		/* 59 */ YY_NOT_ACCEPT,
		/* 60 */ YY_NOT_ACCEPT,
		/* 61 */ YY_NOT_ACCEPT,
		/* 62 */ YY_NOT_ACCEPT,
		/* 63 */ YY_NOT_ACCEPT,
		/* 64 */ YY_NOT_ACCEPT,
		/* 65 */ YY_NOT_ACCEPT,
		/* 66 */ YY_NOT_ACCEPT,
		/* 67 */ YY_NOT_ACCEPT,
		/* 68 */ YY_NOT_ACCEPT,
		/* 69 */ YY_NOT_ACCEPT,
		/* 70 */ YY_NO_ANCHOR,
		/* 71 */ YY_NOT_ACCEPT,
		/* 72 */ YY_NO_ANCHOR,
		/* 73 */ YY_NOT_ACCEPT,
		/* 74 */ YY_NOT_ACCEPT,
		/* 75 */ YY_NO_ANCHOR,
		/* 76 */ YY_NOT_ACCEPT
	};
	private int yy_cmap[] = unpackFromString(1,65538,
"29:8,14:3,29:21,14,16,28,15,11,15:2,13,26,27,3,1,8,2,10,4,9:10,17,15,7,6,5," +
"15:2,23,12:3,21,22,12:5,24,12:5,19,25,18,20,12:5,15:5,29,12:26,29,15,29,15," +
"29:65409,0:2")[0];

	private int yy_rmap[] = unpackFromString(1,77,
"0,1,2,1,2:2,3,2,4,2,5,2:2,1:3,2:3,6,7,1,8,9,10,11,10,12,13,1,14,15,10,16,17" +
",18,19,20,21,22,23,24,8,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41," +
"11,42,43,44,45,46,47,12,48,17,49,50,51,2,52,53,54")[0];

	private int yy_nxt[][] = unpackFromString(55,30,
"1,2,3,4,5,6,7,8,9,10,30,36,30,38,11,73:2,12,71,30:3,76,30:3,13,14,15,-1:32," +
"73,-1,73:10,40,73:2,74,73:9,-1:5,73,-1,73:3,16,73:6,40,73:2,74,73:9,-1:5,73" +
",-1,73:2,17,18,73:6,40,73:2,74,73:9,-1:5,73,-1,73:6,10,42,73:2,40,73:2,74,7" +
"3:9,-1:5,73,-1,73:6,19,73:3,40,73:2,74,48,73:8,-1:5,73,-1,73:6,31,32,43,32," +
"40,73:2,74,73,32:8,21,-1:4,73,-1,73:6,22,73:3,40,73:2,74,73:9,-1:5,73,-1,73" +
":6,23,73:3,40,73:2,74,58,73:8,-1:5,73,-1,73:6,39,32,73,32,40,73:2,74,73,32:" +
"8,21,-1:4,73,-1,73:6,25,73:3,40,73:2,74,73:9,-1:5,73,-1,73:6,27,73:3,40,73:" +
"2,74,73:9,-1:4,1,35:27,29,35,-1,73,-1,73:6,19,20,43,20,40,73:2,74,73,20:8,2" +
"1,-1:4,73,-1,73:6,31,39,73,39,40,73:2,74,48,39:8,-1:13,33,-1:7,61,-1:21,34," +
"-1:21,35:27,-1,35,-1,73,-1,73:7,44,73,44,40,73:2,74,73,44:8,-1:5,73,-1,73:6" +
",39,32,73,32,40,73:2,74,73,32:3,24,32:4,21,-1:4,73,-1,73:10,-1,73:12,-1:5,7" +
"3,-1,73:6,39:2,73,39,40,73:2,74,73,39:8,-1:20,45,-1:14,73,-1,73:6,39,32,73," +
"32,40,73:2,74,73,32:3,26,32:4,21,-1:4,73,-1,73:6,19,73:3,40,73:2,74,73:9,-1" +
":5,73,-1,73:6,19,49,43,49,40,73:2,74,73,49:8,-1:14,50,51,50,-1:5,50:8,-1:5," +
"73,-1,73:6,23,52,53,52,40,73:2,74,73,52:8,-1:5,73,-1,73:7,46,73,46,40,73:2," +
"74,73,46:8,-1:5,73,-1,73:7,54,55,54,40,73:2,74,73,54:8,-1:5,73,-1,73:6,19,7" +
"3,43,73,40,73:2,74,73:9,-1:13,33,56,57,56,-1:5,56:8,-1:14,50,-1,50,-1:5,50:" +
"8,-1:5,73,-1,73:6,23,73,53,73,40,73:2,74,73:9,-1:5,73,-1,73:6,23,73:3,40,73" +
":2,74,73:9,-1:5,73,-1,73:6,25,59,60,59,40,73:2,74,73,59:8,-1:5,73,-1,73:7,5" +
"4,73,54,40,73:2,74,73,54:8,-1:13,33,-1,57,-1:27,33,-1:21,73,-1,73:7,62,63,6" +
"2,40,73:2,74,73,62:8,-1:5,73,-1,73:6,25,73,60,73,40,73:2,74,73:9,-1:14,64,6" +
"5,64,-1:5,64:8,-1:5,73,-1,73:6,27,66,67,66,40,73:2,74,73,66:8,-1:5,73,-1,73" +
":7,62,73,62,40,73:2,74,73,62:8,-1:13,34,68,69,68,-1:5,68:8,-1:14,64,-1,64,-" +
"1:5,64:8,-1:5,73,-1,73:6,27,73,67,73,40,73:2,74,73:9,-1:13,34,-1,69,-1:19,7" +
"3,-1,73:6,31,32,43,32,40,73:2,74,73,32:2,37,32:5,21,-1:4,73,-1,73:6,19,20,4" +
"3,20,40,73:2,74,73,20,70,20:6,21,-1:4,73,-1,73:6,39,32,73,32,40,73:2,74,73," +
"32:7,41,21,-1:4,73,-1,73:7,46,47,46,40,73:2,74,73,46:8,-1:5,73,-1,73:6,31,3" +
"2,43,32,40,73:2,74,73,32:6,72,32,21,-1:4,73,-1,73:6,19,20,43,20,40,73:2,74," +
"73,20:5,75,20:2,21,-1:3");

	public ParseItem yylex ()
		throws java.io.IOException, 
 jxl.biff.formula.FormulaException

		{
		int yy_lookahead;
		int yy_anchor = YY_NO_ANCHOR;
		int yy_state = yy_state_dtrans[yy_lexical_state];
		int yy_next_state = YY_NO_STATE;
		int yy_last_accept_state = YY_NO_STATE;
		boolean yy_initial = true;
		int yy_this_accept;

		yy_mark_start();
		yy_this_accept = yy_acpt[yy_state];
		if (YY_NOT_ACCEPT != yy_this_accept) {
			yy_last_accept_state = yy_state;
			yy_mark_end();
		}
		while (true) {
			if (yy_initial && yy_at_bol) yy_lookahead = YY_BOL;
			else yy_lookahead = yy_advance();
			yy_next_state = YY_F;
			yy_next_state = yy_nxt[yy_rmap[yy_state]][yy_cmap[yy_lookahead]];
			if (YY_EOF == yy_lookahead && true == yy_initial) {
				return null;
			}
			if (YY_F != yy_next_state) {
				yy_state = yy_next_state;
				yy_initial = false;
				yy_this_accept = yy_acpt[yy_state];
				if (YY_NOT_ACCEPT != yy_this_accept) {
					yy_last_accept_state = yy_state;
					yy_mark_end();
				}
			}
			else {
				if (YY_NO_STATE == yy_last_accept_state) {
					throw (new Error("Lexical Error: Unmatched Input."));
				}
				else {
					yy_anchor = yy_acpt[yy_last_accept_state];
					if (0 != (YY_END & yy_anchor)) {
						yy_move_end();
					}
					yy_to_mark();
					switch (yy_last_accept_state) {
					case 1:
						
					case -2:
						break;
					case 2:
						{ return new Plus() ;}
					case -3:
						break;
					case 3:
						{ return new Minus() ; }
					case -4:
						break;
					case 4:
						{ return new Multiply() ; }
					case -5:
						break;
					case 5:
						{ return new Divide() ; }
					case -6:
						break;
					case 6:
						{ return new GreaterThan() ; }
					case -7:
						break;
					case 7:
						{ return new Equal() ; }
					case -8:
						break;
					case 8:
						{ return new LessThan() ; }
					case -9:
						break;
					case 9:
						{ return new ArgumentSeparator() ; }
					case -10:
						break;
					case 10:
						{ return new IntegerValue(yytext()) ; }
					case -11:
						break;
					case 11:
						{}
					case -12:
						break;
					case 12:
						{ return new RangeSeparator(); }
					case -13:
						break;
					case 13:
						{ return new OpenParentheses() ;}
					case -14:
						break;
					case 14:
						{ return new CloseParentheses() ;}
					case -15:
						break;
					case 15:
						{emptyString = true; yybegin(YYSTRING);}
					case -16:
						break;
					case 16:
						{ return new GreaterEqual() ; }
					case -17:
						break;
					case 17:
						{ return new NotEqual() ; }
					case -18:
						break;
					case 18:
						{ return new LessEqual() ; }
					case -19:
						break;
					case 19:
						{ return new CellReference(yytext()) ; }
					case -20:
						break;
					case 20:
						{return new NameRange(yytext(), nameTable); }
					case -21:
						break;
					case 21:
						{ return new StringFunction(yytext()) ; }
					case -22:
						break;
					case 22:
						{ return new DoubleValue(yytext()) ; }
					case -23:
						break;
					case 23:
						{ return new CellReference3d(yytext(),externalSheet) ; }
					case -24:
						break;
					case 24:
						{return new BooleanValue(yytext());}
					case -25:
						break;
					case 25:
						{ return new Area(yytext()) ; }
					case -26:
						break;
					case 26:
						{return new BooleanValue(yytext());}
					case -27:
						break;
					case 27:
						{ return new Area3d(yytext(),externalSheet) ; }
					case -28:
						break;
					case 28:
						{emptyString = false; return new StringValue(yytext()) ; }
					case -29:
						break;
					case 29:
						{yybegin(YYINITIAL); if (emptyString) return new StringValue("");}
					case -30:
						break;
					case 31:
						{ return new CellReference(yytext()) ; }
					case -31:
						break;
					case 32:
						{return new NameRange(yytext(), nameTable); }
					case -32:
						break;
					case 33:
						{ return new CellReference3d(yytext(),externalSheet) ; }
					case -33:
						break;
					case 34:
						{ return new Area3d(yytext(),externalSheet) ; }
					case -34:
						break;
					case 35:
						{emptyString = false; return new StringValue(yytext()) ; }
					case -35:
						break;
					case 37:
						{return new NameRange(yytext(), nameTable); }
					case -36:
						break;
					case 39:
						{return new NameRange(yytext(), nameTable); }
					case -37:
						break;
					case 41:
						{return new NameRange(yytext(), nameTable); }
					case -38:
						break;
					case 70:
						{return new NameRange(yytext(), nameTable); }
					case -39:
						break;
					case 72:
						{return new NameRange(yytext(), nameTable); }
					case -40:
						break;
					case 75:
						{return new NameRange(yytext(), nameTable); }
					case -41:
						break;
					default:
						yy_error(YY_E_INTERNAL,false);
					case -1:
					}
					yy_initial = true;
					yy_state = yy_state_dtrans[yy_lexical_state];
					yy_next_state = YY_NO_STATE;
					yy_last_accept_state = YY_NO_STATE;
					yy_mark_start();
					yy_this_accept = yy_acpt[yy_state];
					if (YY_NOT_ACCEPT != yy_this_accept) {
						yy_last_accept_state = yy_state;
						yy_mark_end();
					}
				}
			}
		}
	}
}