Пример #1
0
        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();
        }
Пример #2
0
        static void Main(string[] args)
        {
            libExcel_epp objectoExcel = new libExcel_epp();

            objectoExcel.FindElements("WorkbookDiccionario", "Sheet 1");
            //objectoExcel.GetDataTableFromExcel(@"E:\WorkbookDiccionario.xlsx", true);
            //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();
        }