API Documentation
Public Member Functions 
  Wrapper () 
  Default constructor. 
 
bool  Create (bool visible) 
  Create a new excel document. 
 
bool  Open (string path, bool visible) 
  Open an exisiting excel Document. 
 
void  Close () 
  Close Excel without saving changes. 
 
void  Save () 
  Saves the current excel document. 
 
void  AddWorksheet (string name) 
  Add a new worksheet. 
 
void  DeleteWorksheet (int index) 
  Delete a worksheet by index. index start from 1 not 0. 
 
void  DeleteWorksheet (string name) 
  Delete a worksheet by name. 
 
void  SetCurrentWorksheet (string name) 
  Set the current worksheet by name. 
 
void  SetCurrentWorksheet (int index) 
  Set the current worksheet by index. 
 
void  SaveAs2007 (string fullPath) 
  Saves as excel 2007 format. 
 
void  SaveAs2003 (string fullPath) 
  Saves as excel 2003 format. 
 
void  SetRange (string from, string to) 
  Set the column ranges e.g A1 B30 or A1 A1 if you want. 
 
void  SetRangeValue (string value) 
  Set the value of the range
 
void  FormatRangeFont (string from, string to, bool bold, bool italic, bool underline, double?fontSize, Color?fontColor, string fontName) 
  Formats the font in a cell, bold italic and underline take a bool as a value. Fontsize font color and font type are all nullable so you can write null if you dont want to specify. 
 
string  GetCellValue (string location) 
  Get the value of a cell e.g A1. 
 
void  SetCellValue (string location, string value) 
  Set the value of a cell e.g A1. 
 
void  FormatCellFont (string location, bool bold, bool italic, bool underline, double?fontsize, Color?fontcolor, string fontname) 
  Formats the font in a cell, bold italic and underline take a bool as a value. Fontsize font color and font type are all nullable so you can write null if you dont want to specify. 
 
Properties 
string  GetRangeAddress [get] 
  Get the address of current range you are working with. 
 
int  WorksheetCount [get] 
  Get the current number of worksheets. 
 
List< string >  WorksheetNames [get] 
  Return a list of the current worksheet names. 
 
string  CurrentWorksheet [get] 
  Get the current worksheet you are working with 

Last edited Mar 9, 2010 at 12:02 AM by AdeinTokyo, version 5

Comments

No comments yet.