📄 excelworksheet.java
字号:
// 廋惓棜楌
// #01 2000-08-04 A.Watanabe main()傪攑巭
package jp.ne.so_net.ga2.no_ji.jcom.excel8;
import jp.ne.so_net.ga2.no_ji.jcom.*;
public class ExcelWorksheet extends IDispatch {
public ExcelWorksheet(IDispatch jcom) { super(jcom); }
public ExcelApplication Application() throws JComException { return new ExcelApplication((IDispatch)get("Application")); }
// LPDISPATCH _Worksheet::GetApplication()
// {
// LPDISPATCH result;
// InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
// return result;
// }
public int Creator() throws JComException { return ((Integer)get("Creator")).intValue(); }
// long _Worksheet::GetCreator()
// {
// long result;
// InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
// return result;
// }
// LPDISPATCH _Worksheet::GetParent()
// {
// LPDISPATCH result;
// InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
// return result;
// }
public void Activate() throws JComException { method("Activate", null); }
// void _Worksheet::Activate()
// {
// InvokeHelper(0x130, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
// }
public void Copy(ExcelWorksheet before, ExcelWorksheet after) throws JComException {
method("Copy", new Object[] { before, after });
}
// void _Worksheet::Copy(const VARIANT& Before, const VARIANT& After)
// {
// static BYTE parms[] =
// VTS_VARIANT VTS_VARIANT;
// InvokeHelper(0x227, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// &Before, &After);
// }
public void Delete() throws JComException { method("Delete",null); }
// void _Worksheet::Delete()
// {
// InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
// }
public String CodeName() throws JComException { return (String)get("CodeName"); }
// CString _Worksheet::GetCodeName()
// {
// CString result;
// InvokeHelper(0x55d, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
// return result;
// }
//
// CString _Worksheet::Get_CodeName()
// {
// CString result;
// InvokeHelper(0x80010000, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
// return result;
// }
//
// void _Worksheet::Set_CodeName(LPCTSTR lpszNewValue)
// {
// static BYTE parms[] =
// VTS_BSTR;
// InvokeHelper(0x80010000, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
// lpszNewValue);
// }
public int Index() throws JComException { return ((Integer)get("Index")).intValue(); }
// long _Worksheet::GetIndex()
// {
// long result;
// InvokeHelper(0x1e6, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
// return result;
// }
// void _Worksheet::Move(const VARIANT& Before, const VARIANT& After)
// {
// static BYTE parms[] =
// VTS_VARIANT VTS_VARIANT;
// InvokeHelper(0x27d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// &Before, &After);
// }
public String Name() throws JComException { return (String)get("Name"); }
// CString _Worksheet::GetName()
// {
// CString result;
// InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
// return result;
// }
public void Name(String newValue) throws JComException { put("Name", newValue); }
// void _Worksheet::SetName(LPCTSTR lpszNewValue)
// {
// static BYTE parms[] =
// VTS_BSTR;
// InvokeHelper(0x6e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
// lpszNewValue);
// }
public ExcelWorksheet Next() throws JComException { return new ExcelWorksheet((IDispatch)get("Next")); }
// LPDISPATCH _Worksheet::GetNext()
// {
// LPDISPATCH result;
// InvokeHelper(0x1f6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
// return result;
// }
// LPDISPATCH _Worksheet::GetPageSetup()
// {
// LPDISPATCH result;
// InvokeHelper(0x3e6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
// return result;
// }
public ExcelWorksheet Previous() throws JComException { return new ExcelWorksheet((IDispatch)get("Previous")); }
// LPDISPATCH _Worksheet::GetPrevious()
// {
// LPDISPATCH result;
// InvokeHelper(0x1f7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
// return result;
// }
// 摦嶌妋擣嵪傒
public void PrintOut() throws JComException {
method("PrintOut", null);
}
public void PrintOut(int From, int To, int Copies, boolean Preview)
throws JComException {
Object[] arglist = new Object[4];
arglist[0] = new Integer(From);
arglist[1] = new Integer(To);
arglist[2] = new Integer(Copies);
arglist[3] = new Boolean(Preview);
method("PrintOut", arglist);
}
/* 摦嶌偟側偄
public void PrintOut(int From, int To, int Copies, boolean Preview,
String ActivePrinter, boolean PrintToFile, boolean Collate)
throws JComException {
Object[] arglist = new Object[7];
arglist[0] = new Integer(From);
arglist[1] = new Integer(To);
arglist[2] = new Integer(Copies);
arglist[3] = new Boolean(Preview);
arglist[4] = ActivePrinter;
arglist[5] = new Boolean(PrintToFile);
arglist[6] = new Boolean(Collate);
method("PrintOut", arglist);
}
*/
// void _Worksheet::PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate)
// {
// static BYTE parms[] =
// VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
// InvokeHelper(0x389, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// &From, &To, &Copies, &Preview, &ActivePrinter, &PrintToFile, &Collate);
// }
//
// void _Worksheet::PrintPreview(const VARIANT& EnableChanges)
// {
// static BYTE parms[] =
// VTS_VARIANT;
// InvokeHelper(0x119, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// &EnableChanges);
// }
//
// void _Worksheet::Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly)
// {
// static BYTE parms[] =
// VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
// InvokeHelper(0x11a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// &Password, &DrawingObjects, &Contents, &Scenarios, &UserInterfaceOnly);
// }
//
// BOOL _Worksheet::GetProtectContents()
// {
// BOOL result;
// InvokeHelper(0x124, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
// return result;
// }
//
// BOOL _Worksheet::GetProtectDrawingObjects()
// {
// BOOL result;
// InvokeHelper(0x125, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
// return result;
// }
//
// BOOL _Worksheet::GetProtectionMode()
// {
// BOOL result;
// InvokeHelper(0x487, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
// return result;
// }
//
// BOOL _Worksheet::GetProtectScenarios()
// {
// BOOL result;
// InvokeHelper(0x126, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
// return result;
// }
// FileFormat偼 XlFileFormat僋儔僗偺掕悢傪巜掕偟偰偔偩偝偄丅
// 堷悢偺悢傪尭傜偟偰偄傞丅摦嶌枹妋擣
// AccessMode偵巊梡偡傞掕悢 XlSaveAsAccessMode.xlNoChange (婛掕抣) xlShared xlExclusive
public void SaveAs(String Filename, int FileFormat, String Password, String WriteResPassword,
boolean ReadOnlyRecommended, boolean CreateBackup, boolean AddToMru) throws JComException {
Object[] arglist = new Object[7];
arglist[0] = Filename;
arglist[1] = new Integer(FileFormat);
arglist[2] = Password;
arglist[3] = WriteResPassword;
arglist[4] = new Boolean(ReadOnlyRecommended);
arglist[5] = new Boolean(CreateBackup);
arglist[6] = new Boolean(AddToMru);
method("SaveAs", arglist);
}
// void _Worksheet::SaveAs(LPCTSTR Filename, const VARIANT& FileFormat,
// const VARIANT& Password, const VARIANT& WriteResPassword,
// const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup,
// const VARIANT& AddToMru, const VARIANT& TextCodepage
// const VARIANT& TextVisualLayout)
// {
// static BYTE parms[] =
// VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
// InvokeHelper(0x11c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// Filename, &FileFormat, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup, &AddToMru, &TextCodepage, &TextVisualLayout);
// }
// void _Worksheet::Select(const VARIANT& Replace)
// {
// static BYTE parms[] =
// VTS_VARIANT;
// InvokeHelper(0xeb, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// &Replace);
// }
//
// void _Worksheet::Unprotect(const VARIANT& Password)
// {
// static BYTE parms[] =
// VTS_VARIANT;
// InvokeHelper(0x11d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// &Password);
// }
//
public boolean Visible() throws JComException { return ((Boolean)get("Visible")).booleanValue(); }
// long _Worksheet::GetVisible()
// {
// long result;
// InvokeHelper(0x22e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
// return result;
// }
//
public void Visible(boolean v) throws JComException { put("Visible", new Boolean(v)); }
// void _Worksheet::SetVisible(long nNewValue)
// {
// static BYTE parms[] =
// VTS_I4;
// InvokeHelper(0x22e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
// nNewValue);
// }
//
// LPDISPATCH _Worksheet::GetShapes()
// {
// LPDISPATCH result;
// InvokeHelper(0x561, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
// return result;
// }
//
// BOOL _Worksheet::GetTransitionExpEval()
// {
// BOOL result;
// InvokeHelper(0x191, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
// return result;
// }
//
// void _Worksheet::SetTransitionExpEval(BOOL bNewValue)
// {
// static BYTE parms[] =
// VTS_BOOL;
// InvokeHelper(0x191, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
// bNewValue);
// }
//
// BOOL _Worksheet::GetAutoFilterMode()
// {
// BOOL result;
// InvokeHelper(0x318, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
// return result;
// }
//
// void _Worksheet::SetAutoFilterMode(BOOL bNewValue)
// {
// static BYTE parms[] =
// VTS_BOOL;
// InvokeHelper(0x318, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
// bNewValue);
// }
//
// void _Worksheet::SetBackgroundPicture(LPCTSTR Filename)
// {
// static BYTE parms[] =
// VTS_BSTR;
// InvokeHelper(0x4a4, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// Filename);
// }
public void Calculate() throws JComException { method("Calculate", null); }
// void _Worksheet::Calculate()
// {
// InvokeHelper(0x117, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
// }
public boolean EnableCalculation() throws JComException { return ((Boolean)get("EnableCalculation")).booleanValue(); }
// BOOL _Worksheet::GetEnableCalculation()
// {
// BOOL result;
// InvokeHelper(0x590, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
// return result;
// }
public void EnableCalculation(boolean newValue) throws JComException { put("EnableCalculation",new Boolean(newValue)); }
// void _Worksheet::SetEnableCalculation(BOOL bNewValue)
// {
// static BYTE parms[] =
// VTS_BOOL;
// InvokeHelper(0x590, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
// bNewValue);
// }
// 偡傋偰偺Range僆僽僕僃僋僩傪曉偡丅巜掕偟偨僙儖偼丄Range.Item(RowIndex,ColumnIndex)摍傪巊偆偙偲
public ExcelRange Cells() throws JComException { return new ExcelRange((IDispatch)get("Cells")); }
// LPDISPATCH _Worksheet::GetCells()
// {
// LPDISPATCH result;
// InvokeHelper(0xee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
// return result;
// }
// LPDISPATCH _Worksheet::ChartObjects(const VARIANT& Index)
// {
// LPDISPATCH result;
// static BYTE parms[] =
// VTS_VARIANT;
// InvokeHelper(0x424, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
// &Index);
// return result;
// }
//
// void _Worksheet::CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& IgnoreInitialAlefHamza, const VARIANT& IgnoreFinalYaa, const VARIANT& SpellScript)
// {
// static BYTE parms[] =
// VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
// InvokeHelper(0x1f9, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
// &CustomDictionary, &IgnoreUppercase, &AlwaysSuggest, &IgnoreInitialAlefHamza, &IgnoreFinalYaa, &SpellScript);
// }
//
// LPDISPATCH _Worksheet::GetCircularReference()
// {
// LPDISPATCH result;
// InvokeHelper(0x42d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
// return result;
// }
//
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -