opt.java

一个非常有用的操作MCRSOFT EXCEL文件的工具。可以用JAVA方便的新建

/*********************************************************************
*
*      Copyright (C) 2003 Andrew Khan
*
* 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.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
***************************************************************************/

package jxl.biff.drawing;

import java.util.ArrayList;
import java.util.Iterator;

import common.Logger;

import jxl.biff.IntegerHelper;
import jxl.biff.StringHelper;

/**
 * An options record in the escher stream
 */
class Opt extends EscherAtom
{
  /**
   * The logger
   */
  private static Logger logger = Logger.getLogger(Opt.class);

  private byte[] data;
  private int numProperties;

  /**
   * The list of properties
   */
  private ArrayList properties;

  final static class Property
  {
    int id;
    boolean blipId;
    boolean complex;
    int value;
    String stringValue;
    
    public Property(int i, boolean bl, boolean co, int v)
    {
      id = i;
      blipId = bl;
      complex = co;
      value = v;
      //      logger.debug("property id:  " + id + 
      //           " blipId " + blipId + " complex " + co + " value " + v);
    }

    public Property(int i, boolean bl, boolean co, int v, String s)
    {
      id = i;
      blipId = bl;
      complex = co;
      value = v;
      stringValue = s;
    }
  }

  public Opt(EscherRecordData erd)
  {
    super(erd);
    numProperties = getInstance();
    readProperties();
  }

  private void readProperties()
  {
    properties = new ArrayList();
    int pos = 0;
    byte[] bytes = getBytes();
    
    for (int i = 0 ; i < numProperties ; i++)
    {
      int val = IntegerHelper.getInt(bytes[pos], bytes[pos+1]);
      int id = val & 0x3fff;
      int value = IntegerHelper.getInt(bytes[pos+2], bytes[pos+3], 
                                       bytes[pos+4], bytes[pos+5]);
      Property p = new Property(id, 
                                (val & 0x4000) != 0, 
                                (val & 0x8000) != 0, 
                                value);
      pos += 6;
      properties.add(p);
    }

    for (Iterator i = properties.iterator(); i.hasNext() ; )
    {
      Property p = (Property) i.next();
      if (p.complex)
      {
        p.stringValue = StringHelper.getUnicodeString(bytes, p.value/2,
                                                      pos);
        pos += p.value;
      }
    }    
  }

  public Opt()
  {
    super(EscherRecordType.OPT);
    properties = new ArrayList();
    setVersion(3);
  }

  byte[] getData()
  {
    numProperties = properties.size();
    setInstance(numProperties);

    data = new byte[numProperties * 6];
    int pos = 0;

    // Add in the root data
    for (Iterator i = properties.iterator() ; i.hasNext() ; )
    {
      Property p = (Property) i.next();
      int val = p.id & 0x3fff;
      
      if (p.blipId)
      {
        val |= 0x4000;
      }
      
      if (p.complex)
      {
        val |= 0x8000;
      }

      IntegerHelper.getTwoBytes(val, data, pos);
      IntegerHelper.getFourBytes(p.value, data, pos+2);
      pos += 6 ;
    }

    // Add in any complex data
    for (Iterator i = properties.iterator() ; i.hasNext() ; )
    {
      Property p = (Property) i.next();

      if (p.complex && p.stringValue != null)
      {
        byte[] newData = 
          new byte[data.length + p.stringValue.length() * 2];
        System.arraycopy(data, 0, newData, 0, data.length);
        StringHelper.getUnicodeBytes(p.stringValue, newData, data.length);
        data = newData;
      }
    }

    return setHeaderData(data);
  }

  void addProperty(int id, boolean blip, boolean complex, int val)
  {
    Property p = new Property(id, blip, complex, val);
    properties.add(p);
  }

  void addProperty(int id, boolean blip, boolean complex, int val, String s)
  {
    Property p = new Property(id, blip, complex, val, s);
    properties.add(p);
  }

  Property getProperty(int id)
  {
    boolean found = false;
    Property p = null;
    for (Iterator i = properties.iterator() ; i.hasNext() && !found ; )
    {
      p = (Property) i.next();
      if (p.id == id)
      {
        found = true;
      }
    }
    return found ? p : null;
  }

}