public static void ExcelTemplatePrint(bool bool_0, object object_0, string string_0, string string_1, int int_0,
int int_1)
{
int i;
DataTable object0 = null;
if (object_0 is DataTable)
{
object0 = object_0 as DataTable;
}
else if (object_0 is DataSet)
{
object0 = (object_0 as DataSet).Tables[0];
}
if (object0 != null)
{
ExcelAccess excelAccess = new ExcelAccess();
excelAccess.Open(string_0);
excelAccess.IsVisibledExcel = true;
excelAccess.FormCaption = string_1;
int int0 = int_0 + int_1;
for (i = 0; i < object0.Rows.Count; i++)
{
excelAccess.InsertRow(int_0, int_0);
excelAccess.SetRowHeight(int_0, 14.25f);
}
for (i = 0; i < object0.Rows.Count; i++)
{
for (int j = 0; j < object0.Columns.Count; j++)
{
excelAccess.SetCellText(int0 + i, j + 1, object0.Rows[i][j].ToString());
}
}
excelAccess.SetBordersEdge(int0, 1, int0 + object0.Rows.Count - 1, object0.Columns.Count, false);
for (i = int_1; i > 0; i--)
{
excelAccess.DeleteRow(int_0 + i - 1);
}
if (!bool_0)
{
excelAccess.ShowExcel();
}
else
{
excelAccess.PrintPreview();
excelAccess.Close();
}
}
}
public static void ExportExcel(bool bool_0, string string_0, object object_0, string string_1)
{
DataTable object0 = null;
if (object_0 is DataTable)
{
object0 = object_0 as DataTable;
}
else if (object_0 is DataSet)
{
object0 = (object_0 as DataSet).Tables[0];
}
if (object0 != null)
{
Font font = new Font("黑体", 21f, FontStyle.Bold);
ExcelAccess excelAccess = new ExcelAccess();
excelAccess.Open();
excelAccess.FormCaption = string_1;
int num = 1;
if ((string_0 == null ? false : string_0.Trim() != ""))
{
num = 3;
excelAccess.MergeCells(1, 1, 1, object0.Columns.Count);
excelAccess.SetFont(1, 1, 1, object0.Columns.Count, font);
excelAccess.SetCellText(1, 1, 1, object0.Columns.Count, string_0);
}
excelAccess.SetCellText(object0, num, 1, true, true);
if (!bool_0)
{
excelAccess.ShowExcel();
}
else
{
excelAccess.PrintPreview();
excelAccess.Close();
}
font.Dispose();
}
}
public void ImportExcelMethodHandler(object object_0, ImportExcelArgs importExcelArgs_0)
{
ExcelAccess excelAccess = new ExcelAccess();
excelAccess.Open();
excelAccess.MergeCells(1, 1, 1, this.body_0.Cols);
excelAccess.SetFont(1, 1, 1, this.body_0.Cols, this.title_0.Font);
excelAccess.SetCellText(1, 1, 1, this.body_0.Cols, this.title_0.Text);
excelAccess.SetCellText((DataTable)this.DataSource, 3, 1, true);
System.Windows.Forms.FileDialog fileDialog = new System.Windows.Forms.SaveFileDialog();
fileDialog.AddExtension = true;
fileDialog.DefaultExt = ".xls";
fileDialog.Title = "保存到Excel文件";
fileDialog.Filter = "Microsoft Office Excel 工作簿(*.xls)|*.xls|模板(*.xlt)|*.xlt";
if (fileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK &&
excelAccess.SaveAs(fileDialog.FileName, true))
{
System.Windows.Forms.MessageBox.Show("数据成功保存到Excel文件！", "JLK.Utility.Excel",
System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Asterisk);
}
fileDialog.Dispose();
excelAccess.Close();
}
