pivotcache.java

将Excel和Word的类型库都转换过来了

/**
 * JacobGen generated file --- do not edit
 *
 * (http://www.bigatti.it/projects/jacobgen)
 */
package org.nethawker.excel11;

import com.jacob.com.*;

public class PivotCache extends Dispatch {

	public static final String componentName = "Excel.PivotCache";

	public PivotCache() {
		super(componentName);
	}

	/**
	* This constructor is used instead of a case operation to
	* turn a Dispatch object into a wider object - it must exist
	* in every wrapper class whose instances may be returned from
	* method calls wrapped in VT_DISPATCH Variants.
	*/
	public PivotCache(Dispatch d) {
		// take over the IDispatch pointer
		m_pDispatch = d.m_pDispatch;
		// null out the input's pointer
		d.m_pDispatch = 0;
	}

	public PivotCache(String compName) {
		super(compName);
	}

	public Application getApplication() {
		return new Application(Dispatch.get(this, "Application").toDispatch());
	}

	public int getCreator() {
		return Dispatch.get(this, "Creator").toInt();
	}

	public Dispatch getParent() {
		return Dispatch.get(this, "Parent").toDispatch();
	}

	public boolean getBackgroundQuery() {
		return Dispatch.get(this, "BackgroundQuery").toBoolean();
	}

	public void setBackgroundQuery(boolean lastParam) {
		Dispatch.put(this, "BackgroundQuery", new Variant(lastParam));
	}

	public Variant getConnection() {
		return Dispatch.get(this, "Connection");
	}

	public void setConnection(Variant lastParam) {
		Dispatch.put(this, "Connection", lastParam);
	}

	public boolean getEnableRefresh() {
		return Dispatch.get(this, "EnableRefresh").toBoolean();
	}

	public void setEnableRefresh(boolean lastParam) {
		Dispatch.put(this, "EnableRefresh", new Variant(lastParam));
	}

	public int getIndex() {
		return Dispatch.get(this, "Index").toInt();
	}

	public int getMemoryUsed() {
		return Dispatch.get(this, "MemoryUsed").toInt();
	}

	public boolean getOptimizeCache() {
		return Dispatch.get(this, "OptimizeCache").toBoolean();
	}

	public void setOptimizeCache(boolean lastParam) {
		Dispatch.put(this, "OptimizeCache", new Variant(lastParam));
	}

	public int getRecordCount() {
		return Dispatch.get(this, "RecordCount").toInt();
	}

	public void refresh() {
		Dispatch.call(this, "Refresh");
	}

	public java.util.Date getRefreshDate() {
		return comDateToJavaDate(Dispatch.get(this, "RefreshDate").toDate());
	}

	public String getRefreshName() {
		return Dispatch.get(this, "RefreshName").toString();
	}

	public boolean getRefreshOnFileOpen() {
		return Dispatch.get(this, "RefreshOnFileOpen").toBoolean();
	}

	public void setRefreshOnFileOpen(boolean lastParam) {
		Dispatch.put(this, "RefreshOnFileOpen", new Variant(lastParam));
	}

	public Variant getSql() {
		return Dispatch.get(this, "Sql");
	}

	public void setSql(Variant lastParam) {
		Dispatch.put(this, "Sql", lastParam);
	}

	public boolean getSavePassword() {
		return Dispatch.get(this, "SavePassword").toBoolean();
	}

	public void setSavePassword(boolean lastParam) {
		Dispatch.put(this, "SavePassword", new Variant(lastParam));
	}

	public Variant getSourceData() {
		return Dispatch.get(this, "SourceData");
	}

	public void setSourceData(Variant lastParam) {
		Dispatch.put(this, "SourceData", lastParam);
	}

	static long zoneOffset	= java.util.Calendar.getInstance().get(java.util.Calendar.ZONE_OFFSET);

	static java.util.Date comDateToJavaDate(double comDate) {
		comDate = comDate - 25569D;
		long millis = Math.round(86400000L * comDate) - zoneOffset;

		java.util.Calendar cal = java.util.Calendar.getInstance();
		cal.setTime(new java.util.Date(millis));
		millis -= cal.get(cal.DST_OFFSET);

		return new java.util.Date(millis);
	}

	static double javaDateToComDate(java.util.Date javaDate) {

		java.util.Calendar cal = java.util.Calendar.getInstance();
		cal.setTime(javaDate);
		long gmtOffset = (cal.get(cal.ZONE_OFFSET) + cal.get(cal.DST_OFFSET));

		long millis = javaDate.getTime() + gmtOffset;
		return 25569D+millis/86400000D;
	}

}