static void Main(string[] args)
{
libExcel_epp l = new libExcel_epp();
l.Excel_Create("Sheet1", 01, 02, "Test1", "www.google.com");
//l.Excel_Create("Sheet1", 02, 03, "Test2", "www.google.com");
//l.Excel_Create("Sheet1", 04, 05, "Test3", "www.google.com");
l.Excel_Mod(4, 1, "Hello");
l.Excel_Mod(3, 10, 10, "10", "www.google.com");
//l.Excel_Get();
//ExcelPackage package = new ExcelPackage(new FileInfo(@"D:\New2.xlsx"));
//ExcelWorksheet workSheet = package.Workbook.Worksheets.FirstOrDefault();
//IEnumerable<libExcel_epp> records = QuerysRecord(workSheet, true);
//Console.WriteLine("Records count: " + records.Count());
//Console.ReadLine();
}
static void Main(string[] args)
{
libExcel_epp objectoExcel = new libExcel_epp();
//libExcel_epp objeto_2 = new libExcel_epp("Worksheet1");
//libExcel_epp objeto_3 = new libExcel_epp("Worksheet2","Sheet 3");
//objectoExcel.WorkbookCreate("Workbook3");
//objectoExcel.WorkbookCreate(@"E:\","WorkbookPrueba","Sheet 40");
objectoExcel.WorkbookCreate("Workbook", "Sheet 1");
//objectoExcel.WorkbookDelete("Workbook2");
//objectoExcel.WorkbookDelete(@"E:\","WorkbookPrueba");
//libExcel_epp objeto_4 = new libExcel_epp(@"E:\trabajo\", "Workbook50", "Worksheet100" );
//objectoExcel.WorkbookOverwrite("WorkbookPrueba")
Console.WriteLine("El archivo creado se encuentra en: " + objectoExcel.m_fileInfo.DirectoryName);
Console.ReadKey();
/**
* objectoExcel.WorksheetCreate("Jola");
* objectoExcel.WorksheetStyling("Jola",14,"Times New Roman");
* objectoExcel.WorksheetCreate("Hoja 3");
* objectoExcel.WorksheetStyling(@"E:\","WorkbookPrueba","Hoja 3",14,"Times New Roman");
* objectoExcel.WorksheetStyling("WorkbookPrueba","Sheet 40",14,"Times New Roman"); //Si le doy un workbook diferente con el objeto que tengo ya creado, entonces lo sobreescribe y ya
*/
//objectoExcel.WorkbookDelete(@"E:\","WorkbookPrueba");
//Console.WriteLine(objectoExcel.m_fileInfo.ToString());
//Console.ReadKey();
objectoExcel.Excel_Create("Sheet1", 01, 02, "Test1", "www.google.com");
objectoExcel.Excel_Mod(6, 1, "Hola");
objectoExcel.Excel_Mod(3, 10, 10, "10", "www.google.com");
objectoExcel.Excel_Mod(4, 11, 11, "11", "www.google.com");
objectoExcel.Excel_Mod(5, 12, 12, "12", "www.google.com");
ExcelPackage package = new ExcelPackage(new FileInfo(@"D:\FinalTest.xlsx"));
ExcelWorksheet workSheet = package.Workbook.Worksheets.FirstOrDefault();
IEnumerable <libExcel_epp> records = QuerysRecord(workSheet, true);
Console.WriteLine("Records count: " + records.Count());
Console.ReadLine();
}