• 홈
• Cedar
• Framework
• Common
• BaseClasses
• ExcelHelper

C# 클래스 Cedar.Framework.Common.BaseClasses.ExcelHelper

파일 보기 프로젝트 열기: Chinaccn/surfboard

공개 메소드들

메소드	설명
ReadExcelToDataSet ( string excelPath ) : DataSet	将Excel转成DataSet
ReadExcelToDataSet ( string excelPath, bool existheader, int top = null ) : DataSet	将Excel转成DataSet
WriteExcel ( DataSet set, bool addheader ) : void	导出Excel
WriteExcel ( DataSet set, string title, bool addheader, string extInfo = "", bool addPic = false ) : void	写入Excel
WriteExcel ( string json, bool addheader = true, string sheetName = "" ) : void	生成Excel
WriteExcel ( string json, string title, bool addheader, string extInfo = "", bool addPic = false, string alignJson = "", string sheetName = "table1", string alignName = "table2" ) : void	Json保存成Excel
WriteExcel ( string datalocation, string json, string title, string headerJson, string extInfo = "", bool addPic = false, string alignJson = "", string sheetName = "table1", string alignName = "table2" ) : void	Json保存成Excel
WriteSpecialExcel ( string datalocation, DataSet set, string title, string headerJson, string extInfo = "", bool addPic = false ) : void	写入Excel

비공개 메소드들

메소드	설명
AddDataTable ( OfficeOpenXml.ExcelWorksheet worksheet ) : DataTable	根据sheet名称生成DataTable
AddExtInfo ( OfficeOpenXml.ExcelWorksheet worksheet, string info ) : void	添加时间
AddPic ( OfficeOpenXml.ExcelWorksheet worksheet ) : void	添加图片到Excel
AddRow ( OfficeOpenXml.ExcelWorksheet worksheet, DataTable dt, bool existheader, int top ) : void	添加数据行
AddSheet ( ExcelPackage package, string name ) : OfficeOpenXml.ExcelWorksheet	添加Sheet
AddTitle ( OfficeOpenXml.ExcelWorksheet worksheet, string title ) : void	添加表头
ReadXlsx ( string path, bool header, int top ) : DataSet	读取Excel2007
SetWorksheetBorder ( System.Drawing.ColorConverter wcc, OfficeOpenXml.ExcelRange rangeArea ) : void	生成图文excel报表 设置边框

메소드 상세