Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- C# - EXPORT DATATABLE TO NEW EXCEL XLSX - USE EPPLUS
- public string[] EXPORT_DATATABLE_TO_EXCEL_XLSX_NEW_FILE_USE_EPPLUS(DataTable DATA_TABLE, string SHEET_NAME, string FILE_EXCEL_XLSX_NEW, bool EXPORT_HEADER = true, int ROW_BEGIN = 1, int COLUMN_BEGIN = 1)
- {
- /* PLEASE NOTE FOR USE
- -------------------
- STEP 1 - DOWNLOAD EPPLUS FROM EPPLUS.CODEPLEX.COM
- STEP 2 - ADD REFERENCE EPPLUS.DLL TO VISUAL STUDIO
- STEP 3 - SET COPY LOCAL = TRUE
- -------------------
- EXAMPLE FOR USE
- ---------------
- using System.Data;
- DataTable DATA_TABLE = new DataTable();
- DATA_TABLE.Columns.Add("ID", typeof(string));
- DATA_TABLE.Columns.Add("NAME", typeof(string));
- DATA_TABLE.Rows.Add("1", "A");
- DATA_TABLE.Rows.Add("2", "B");
- DATA_TABLE.Rows.Add("3", "C");
- DATA_TABLE.Rows.Add("4", "D");
- DATA_TABLE.Rows.Add("5", "E");
- DATA_TABLE.Rows.Add("6", "F");
- string FILE_EXCEL_XLSX_NEW = @"D:\FILE_EXCEL_XLSX_NEW.xlsx";
- string[] STATUS = EXPORT_DATATABLE_TO_EXCEL_XLSX_NEW_FILE_USE_EPPLUS(DATA_TABLE, "SHEET1", FILE_EXCEL_XLSX_NEW, true, 2, 3);
- if (STATUS[0] == "ERROR") { MessageBox.Show(STATUS[1], "ERROR"); }
- if (STATUS[0] == "OK") { System.Diagnostics.Process.Start(FILE_EXCEL_XLSX_NEW); }
- ---------------
- */
- string[] KQ = { "OK", "" };
- if (ROW_BEGIN <= 0 || COLUMN_BEGIN <= 0)
- {
- KQ[0] = "ERROR";
- KQ[1] = "REQUIRE ROW_BEGIN AND COLUMN_BEGIN GREATER THAN 0";
- return KQ;
- }
- if (SHEET_NAME.Trim() == "" || FILE_EXCEL_XLSX_NEW.Trim() == "")
- {
- KQ[0] = "ERROR";
- KQ[1] = "REQUIRE SHEET_NAME, FILE_EXCEL_XLSX_NEW NOT BLANK";
- return KQ;
- }
- try
- {
- System.IO.FileStream FILE_XLSX_NEW = new System.IO.FileStream(FILE_EXCEL_XLSX_NEW.Trim(), System.IO.FileMode.Create, System.IO.FileAccess.Write);
- using (OfficeOpenXml.ExcelPackage ExPCK = new OfficeOpenXml.ExcelPackage(FILE_XLSX_NEW))
- {
- OfficeOpenXml.ExcelWorksheet ExWS = ExPCK.Workbook.Worksheets.Add(SHEET_NAME.Trim());
- ExWS.Cells[ROW_BEGIN, COLUMN_BEGIN].LoadFromDataTable(DATA_TABLE, EXPORT_HEADER);
- ExPCK.Save();
- }
- FILE_XLSX_NEW.Close();
- }
- catch (Exception ex)
- {
- KQ[0] = "ERROR";
- KQ[1] = ex.ToString();
- }
- return KQ;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement