public class CExcel
{
private Application m_App = null;
private Worksheet m_current_sheet = null;
private Workbook m_work_book = null;
public Range Border(int top, int left, int bottom, int right)
{
try
{
if (this.m_current_sheet == null)
{
return null;
}
Worksheet worksheet = this.m_current_sheet;
Range range = worksheet.get_Range(worksheet.Cells[top, left], worksheet.Cells[bottom, right]);
range.Borders.LineStyle = 1;
return range;
}
catch
{
return null;
}
}
public void Close()
{
try
{
this.m_App.Quit();
this.m_App = null;
}
catch
{
}
}
public bool Create()
{
try
{
if (this.m_App != null)
{
this.Close();
}
this.m_App = new ApplicationClass();
if (this.m_App == null)
{
return false;
}
}
catch
{
return false;
}
return true;
}
public Workbook CreateWorkBook()
{
Workbooks workbooks = this.m_App.Workbooks;
if (workbooks == null)
{
this.m_App = null;
return null;
}
Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
if (workbook == null)
{
this.m_App = null;
return null;
}
this.m_work_book = workbook;
this.m_current_sheet = (Worksheet)workbook.Worksheets.get_Item(1);
return workbook;
}
public string GetCellText(object row, object column)
{
try
{
if (this.m_current_sheet == null)
{
return "";
}
Range range = (Range)this.m_current_sheet.Cells.get_Item(row, column);
if (range != null)
{
return (string)range.Text;
}
}
catch
{
return null;
}
return null;
}
public Range GetRange(int top, int left, int bottom, int right)
{
try
{
if (this.m_current_sheet == null)
{
return null;
}
Worksheet worksheet = this.m_current_sheet;
return worksheet.Cells.get_Range(worksheet.Cells[top, left], worksheet.Cells[bottom, right]);
}
catch
{
return null;
}
}
public Range Merge(int top, int left, int bottom, int right)
{
try
{
if (this.m_current_sheet == null)
{
return null;
}
Worksheet worksheet = this.m_current_sheet;
Range range = this.m_current_sheet.Cells.get_Range(worksheet.Cells[top, left], worksheet.Cells[bottom, right]);
range.Merge(Missing.Value);
return range;
}
catch
{
return null;
}
}
public bool Open(string file)
{
try
{
if (this.m_App != null)
{
this.Close();
}
this.m_App = new ApplicationClass();
if (this.m_App == null)
{
return false;
}
Workbooks workbooks = this.m_App.Workbooks;
if (workbooks == null)
{
this.m_App = null;
return false;
}
Workbook workbook = workbooks.Add(file);
if (workbook == null)
{
this.m_App = null;
return false;
}
this.m_work_book = workbook;
this.m_current_sheet = (Worksheet)workbook.Worksheets.get_Item(1);
}
catch
{
return false;
}
return true;
}
public bool SetCellData(int row, int column, object data)
{
try
{
if (this.m_current_sheet == null)
{
return false;
}
this.m_current_sheet.Cells[row, column] = data;
return true;
}
catch
{
return false;
}
}
public bool SetCellColor(int row, int column, object color)
{
try
{
if (this.m_current_sheet == null)
{
return false;
}
this.m_current_sheet.get_Range(this.m_current_sheet.Cells[row, column], this.m_current_sheet.Cells[row, column]).Interior.Color = color;
return true;
}
catch
{
return false;
}
}
public Range SetCellText(int row, int column, string text)
{
try
{
if (this.m_current_sheet == null)
{
return null;
}
Range range = (Range)this.m_current_sheet.Cells.get_Item(row, column);
range.NumberFormatLocal = "@";
this.m_current_sheet.Cells[row, column] = text;
return range;
}
catch
{
return null;
}
}
public Range SetColumnWidth(int column, double width)
{
try
{
if (this.m_current_sheet == null)
{
return null;
}
Range range = (Range)this.m_current_sheet.Cells.get_Item(1, column);
range.ColumnWidth = width;
return range;
}
catch
{
return null;
}
}
public void SetCurrentSheet(Worksheet sheet)
{
if (sheet != null)
{
this.m_current_sheet = sheet;
}
}
public Range SetRowHeight(int row, double height)
{
try
{
if (this.m_current_sheet == null)
{
return null;
}
Range range = (Range)this.m_current_sheet.Cells.get_Item(row, 1);
range.RowHeight = height;
range.Font.Name = "宋体";
range.Font.Size = 9;
return range;
}
catch
{
return null;
}
}
public void Show()
{
try
{
if (this.m_App != null)
{
this.m_App.Visible = true;
}
}
catch
{
}
}
public Application app
{
get
{
return this.m_App;
}
}
public Worksheet sheet
{
get
{
return this.m_current_sheet;
}
}
public Workbook work_book
{
get
{
return this.m_work_book;
}
}
}
