示例#1
0
        private void readDDPDemandByCollection(Demand demand)
        {
            excel = new ExcelUtil();

            excel.AddWorkbook();
            excel.Worksheet("Sheet1");

            String cell = null;
            String path = null;

            foreach (String cntr in demand.RowCollection)
            {
                cell = demand.DdpDemandkeywordColumn + cntr;
                path = @"='" + demand.Path + "\\[" + demand.FileName + "]" + demand.WorkSheet + "'!" + cell;
                excel.WriteCell(1, 1, path);
                String data = excel.ReadCell("A1").ToString();

                dataType = new DataType(data);
                dataType = (DataType)dataTypeSessionData.createIfNotExist(dataType);

                Area area = new Area("Luzon");
                area = (Area)areaSessionData.createIfNotExist(area);

                Regions region = new Regions(demand.Region.ToString().Replace("_", " "), area.areaId);
                region = (Regions)regionSessionData.createIfNotExist(region);

                Cooperative cooperative = new Cooperative(demand.Cooperative, demand.CooperativeAccronym, region.regionId);
                cooperative = (Cooperative)cooperativeSessionData.createIfNotExist(cooperative);

                CooperativeDataValues coopSearch = cooperativeDataValueSessionData.findDataValuesByCoopertiveId(cooperative, dataType);
                if (coopSearch != null)
                {
                    cooperativeDataContentSessionData.deleteByDataValueId(coopSearch.cooperativeDataValuesId);
                    cooperativeDataValue = coopSearch;
                }
                else
                {
                    cooperativeDataValue = new CooperativeDataValues(cooperative, dataType);
                    cooperativeDataValue = (CooperativeDataValues)cooperativeDataValueSessionData.add(cooperativeDataValue);
                }

                writeDDPDemandCoopCollection(demand, cntr);
            }

            excel.Close();
        }
示例#2
0
        private void button8_Click(object sender, EventArgs e)
        {
            excel = new ExcelUtil();
            excel.AddWorkbook();
            excel.Worksheet("Sheet1");

            List <String> lstData = new List <String>();
            StreamWriter  writer  = new StreamWriter("testCSV.csv", false);

            List <String> luzonPSASummary    = new List <String>();
            List <String> luzonDemandSummary = new List <String>();

            List <String> mindanaoPSASummary    = new List <String>();
            List <String> mindanaoDemandSummary = new List <String>();

            List <String> visayasPSASummary    = new List <String>();
            List <String> visayasDemandSummary = new List <String>();


            //testing for changes
            row = 0;
            int          areaCntr = 0;
            IList <Area> areas    = areaSessionData.getAllAreas();

            foreach (Area area in areas)
            {
                areaCntr++;
                foreach (Regions region in regionSessionData.getAllRegionsByArea(area))
                {
                    List <Cooperative> coops = cooperativeSessionData.getCooperativeByRegion(region.regionId);
                    int coopCntr             = 0;
                    foreach (Cooperative coop in coops)
                    {
                        coopCntr++;

                        row++;
                        writer.WriteLine();

                        row++;
                        writer.WriteLine(area.name + "," + region.name + "," + coop.name);

                        IList <Plant> plants = plantSessionData.getAllPlantByCoop(coop.cooperativeId);

                        //row++;
                        //writer.WriteLine(area.name + "," + region.name + ",PSA,=SUM(D" + (row + 1) + ":D" + (row + plants.Count) + ")");

                        int PSARow = row;

                        //row++;
                        int col;
                        //Console.WriteLine(plants.Count.ToString());
                        Console.WriteLine("Coop: " + coop.name + " " + ((double)coopCntr / coops.Count));
                        txtOutput.AppendText(areaCntr + " out of" + areas.Count + ": " + (((double)coopCntr / coops.Count) * 100) + "%\n");
                        loadingBar.Value = (int)(((double)coopCntr / coops.Count) * 100);

                        int           colCntr;
                        int           psaRowMarker = 0;
                        List <String> data1;
                        List <String> data2;

                        bool psaRegistered = false;


                        foreach (Plant plant in plants)
                        {
                            if (plant != null)
                            {
                                col     = 3;
                                colCntr = 1; //
                                data1   = new List <String>();
                                data2   = new List <String>();

                                String psaOutput = "";

                                foreach (DataValues dataValue in plant.dataValues)
                                {
                                    col++;
                                    List <string> tempData = null;

                                    if (colCntr == 1)
                                    {
                                        data1    = dataContentSessionData.findDataContentValueByDataValuesId(dataValue);
                                        tempData = data1;
                                    }
                                    else if (colCntr == 2)
                                    {
                                        data2    = dataContentSessionData.findDataContentValueByDataValuesId(dataValue);
                                        tempData = data2;
                                    }

                                    if (!psaRegistered)
                                    {
                                        int column = 4;

                                        foreach (String str in tempData)
                                        {
                                            psaOutput += "=SUM(" + numUtil.getLetterByNumber(column) + ("row") + ":" + numUtil.getLetterByNumber(column) + ("rows") + "),";
                                            column++;
                                        }
                                    }

                                    colCntr++;

                                    col = 4;
                                }

                                if (!psaRegistered)
                                {
                                    row++;
                                    psaRowMarker = row;

                                    if (area.name.Equals("Luzon"))
                                    {
                                        luzonPSASummary.Add(row.ToString());
                                    }
                                    else if (area.name.Equals("Mindanao"))
                                    {
                                        mindanaoPSASummary.Add(row.ToString());
                                    }
                                    else if (area.name.Equals("Visayas"))
                                    {
                                        visayasPSASummary.Add(row.ToString());
                                    }

                                    psaOutput.Remove(psaOutput.LastIndexOf(','));
                                    writer.WriteLine(area.name + "," + region.name + ",PSA," + psaOutput.Replace("rows", (row + plants.Count).ToString()).Replace("row", (row + 1).ToString()));
                                }

                                psaRegistered = true;

                                List <String> output = merge(data1, data2);
                                output.Insert(0, area.name.Replace(",", ""));
                                output.Insert(1, region.name);
                                output.Insert(2, plant.name.Replace(",", ""));

                                Console.WriteLine(String.Join(",", output));
                                row++;
                                writer.WriteLine(String.Join(",", output));
                            }
                        }

                        Console.WriteLine("-----------");


                        col = 3;

                        colCntr = 1;
                        data1   = new List <String>();
                        data2   = new List <String>();

                        foreach (CooperativeDataValues dataValue in coop.cooperativeDataValues)
                        {
                            List <string> tempData = null;
                            col++;
                            if (colCntr == 1)
                            {
                                data1    = cooperativeDataContentSessionData.findDataContentValueByDataValuesId(dataValue);
                                tempData = data1;
                            }
                            else if (colCntr == 2)
                            {
                                data2    = cooperativeDataContentSessionData.findDataContentValueByDataValuesId(dataValue);
                                tempData = data2;
                            }

                            colCntr++;
                        }

                        List <String> output2 = merge(data1, data2);

                        int resColumn = 4;
                        row++;
                        String reserveDef = "";

                        foreach (String str in output2)
                        {
                            reserveDef += "=" + (psaRowMarker == 0 ? "0" : numUtil.getLetterByNumber(resColumn) + (psaRowMarker)) + "-" + numUtil.getLetterByNumber(resColumn) + (row) + ",";
                            resColumn++;
                        }

                        output2.Insert(0, area.name.Replace(",", ""));
                        output2.Insert(1, region.name);
                        output2.Insert(2, "DEMAND");

                        if (area.name.Equals("Luzon"))
                        {
                            luzonDemandSummary.Add(row.ToString());
                        }
                        else if (area.name.Equals("Mindanao"))
                        {
                            mindanaoDemandSummary.Add(row.ToString());
                        }
                        else if (area.name.Equals("Visayas"))
                        {
                            visayasDemandSummary.Add(row.ToString());
                        }

                        row++;
                        writer.WriteLine(String.Join(",", output2));


                        if (!reserveDef.Equals(""))
                        {
                            reserveDef.Remove(reserveDef.LastIndexOf(','));
                        }

                        writer.WriteLine(area.name + "," + region.name + ",RESERVE/DEFICIT," + reserveDef);
                    }
                }
            }

            writer.Close();

            //ExcelUtil excel = new ExcelUtil();
            row++;
            row++;
            excel.Open(Application.StartupPath.ToString() + "\\testCSV.csv");
            excel.Worksheet("testCSV");

            excel.WriteCell(2, 1, "Area");
            excel.WriteCell(2, 2, "Region");

            for (int index = 0; index < luzonPSASummary.Count; index++)
            {
                excel.setBackgroundColor("A" + luzonPSASummary[index].ToString() + ":AG" + luzonPSASummary[index].ToString(), Color.Aqua);
            }

            for (int index = 0; index < luzonDemandSummary.Count; index++)
            {
                excel.setBackgroundColor("A" + luzonDemandSummary[index].ToString() + ":AG" + luzonDemandSummary[index].ToString(), Color.Wheat);
                excel.setBackgroundColor("A" + (Int32.Parse(luzonDemandSummary[index].ToString()) + 1) + ":AG" + (Int32.Parse(luzonDemandSummary[index].ToString()) + 1), Color.Gainsboro);
            }

            for (int index = 0; index < mindanaoPSASummary.Count; index++)
            {
                excel.setBackgroundColor("A" + mindanaoPSASummary[index].ToString() + ":AG" + mindanaoPSASummary[index].ToString(), Color.Aqua);
            }

            for (int index = 0; index < mindanaoDemandSummary.Count; index++)
            {
                excel.setBackgroundColor("A" + mindanaoDemandSummary[index].ToString() + ":AG" + mindanaoDemandSummary[index].ToString(), Color.Wheat);
                excel.setBackgroundColor("A" + (Int32.Parse(mindanaoDemandSummary[index].ToString()) + 1) + ":AG" + (Int32.Parse(mindanaoDemandSummary[index].ToString()) + 1), Color.Gainsboro);
            }

            for (int index = 0; index < visayasPSASummary.Count; index++)
            {
                excel.setBackgroundColor("A" + visayasPSASummary[index].ToString() + ":AG" + visayasPSASummary[index].ToString(), Color.Aqua);
            }

            for (int index = 0; index < visayasPSASummary.Count; index++)
            {
                excel.setBackgroundColor("A" + visayasPSASummary[index].ToString() + ":AG" + visayasPSASummary[index].ToString(), Color.Wheat);
                excel.setBackgroundColor("A" + (Int32.Parse(visayasPSASummary[index].ToString()) + 1) + ":AG" + (Int32.Parse(visayasPSASummary[index].ToString()) + 1), Color.Gainsboro);
            }

            int colHeader     = 4;
            int colDataHeader = 2008;

            for (int yr = 2008; yr <= 2022 + (2022 - 2008); yr++)
            {
                if (yr % 2 == 0)
                {
                    excel.WriteCell(1, colHeader, colDataHeader.ToString());
                    excel.Merge(numUtil.getLetterByNumber(colHeader) + "1", numUtil.getLetterByNumber(colHeader + 1) + "1");
                    excel.WriteCell(2, colHeader, "PSA DEMAND");
                    excel.WriteCell(2, colHeader + 1, "E. SALES");
                    colDataHeader++;
                }

                colHeader++;
            }


            excel.filter("A1", "B" + row);

            excel.WriteCell(row, 2, "Luzon");
            excel.WriteCell(row, 3, "PSA");
            excel.WriteCell(row, 4, Summary(luzonPSASummary).Replace(",", ",D"));
            excel.setBackgroundColor("D" + row, Color.Gainsboro);
            excel.copy("D" + row, "E" + row + ":AG" + row);

            row++;

            excel.WriteCell(row, 2, "Luzon");
            excel.WriteCell(row, 3, "DEMAND");
            excel.WriteCell(row, 4, Summary(luzonDemandSummary).Replace(",", ",D"));
            excel.setBackgroundColor("D" + row, Color.LightCyan);
            excel.copy("D" + row, "E" + row + ":AG" + row);

            row++;

            excel.WriteCell(row, 2, "Luzon");
            excel.WriteCell(row, 3, "RESERVE/DEFICIT");
            excel.WriteCell(row, 4, "=D" + (row - 2) + "-D" + (row - 1));
            excel.setBackgroundColor("D" + row, Color.LightCyan);
            excel.copy("D" + row, "E" + row + ":AG" + row);

            row++;
            row++;


            excel.WriteCell(row, 2, "Visayas");
            excel.WriteCell(row, 3, "PSA");
            excel.WriteCell(row, 4, Summary(visayasPSASummary).Replace(",", ",D"));
            excel.setBackgroundColor("D" + row, Color.Gainsboro);
            excel.copy("D" + row, "E" + row + ":AG" + row);

            row++;

            excel.WriteCell(row, 2, "Visayas");
            excel.WriteCell(row, 3, "DEMAND");
            excel.WriteCell(row, 4, Summary(visayasDemandSummary).Replace(",", ",D"));
            excel.setBackgroundColor("D" + row, Color.LightCyan);
            excel.copy("D" + row, "E" + row + ":AG" + row);

            row++;

            excel.WriteCell(row, 2, "Visayas");
            excel.WriteCell(row, 3, "RESERVE/DEFICIT");
            excel.WriteCell(row, 4, "=D" + (row - 2) + "-D" + (row - 1));
            excel.setBackgroundColor("D" + row, Color.LightCyan);
            excel.copy("D" + row, "E" + row + ":AG" + row);

            row++;
            row++;

            excel.WriteCell(row, 2, "Mindanao");
            excel.WriteCell(row, 3, "PSA");
            excel.WriteCell(row, 4, Summary(mindanaoPSASummary).Replace(",", ",D"));
            excel.setBackgroundColor("D" + row, Color.Gainsboro);
            excel.copy("D" + row, "E" + row + ":AG" + row);

            row++;

            excel.WriteCell(row, 2, "Mindanao");
            excel.WriteCell(row, 3, "DEMAND");
            excel.WriteCell(row, 4, Summary(mindanaoDemandSummary).Replace(",", ",D"));
            excel.setBackgroundColor("D" + row, Color.LightCyan);
            excel.copy("D" + row, "E" + row + ":AG" + row);

            row++;

            excel.WriteCell(row, 2, "Mindanao");
            excel.WriteCell(row, 3, "RESERVE/DEFICIT");
            excel.WriteCell(row, 4, "=D" + (row - 2) + "-D" + (row - 1));
            excel.setBackgroundColor("D" + row, Color.LightCyan);

            excel.Format("A3:AG" + row, "#,##0.00");

            excel.copy("D" + row, "E" + row + ":AG" + row);
            excel.Save("newExcel.xls");



            GC.Collect();
            Console.WriteLine("Save!");
        }
示例#3
0
        private void button7_Click(object sender, EventArgs e)
        {
            Demand             demand    = (Demand)propertyGrid.SelectedObject;
            NumberToLetterUtil converter = new NumberToLetterUtil();

            demand.PscEcsData.Clear();
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2008", Column = "J"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2009", Column = "K"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2010", Column = "L"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2011", Column = "M"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2012", Column = "N"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2013", Column = "O"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2014", Column = "P"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2015", Column = "Q"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2016", Column = "R"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2017", Column = "S"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2018", Column = "T"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2019", Column = "U"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2020", Column = "V"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2021", Column = "W"
            });
            demand.PscEcsData.Add(new PscEcsData()
            {
                Name = "2022", Column = "X"
            });
            NumberToLetterUtil numUtil = new NumberToLetterUtil();

            if (demand.RowSequenceType == RowSequenceType.Range)
            {
                try
                {
                    String firstLetter = demand.RowRangeFrom.ElementAt(0).ToString();

                    ExcelUtil excel = new ExcelUtil();

                    excel.Open(demand.Path + "/" + demand.FileName);
                    excel.Worksheet(demand.WorkSheet);

                    Object[,] obj = excel.ReadCellByRange(demand.RowRangeFrom + ":" + demand.RowRangeTo);
                    for (int row = 1; row <= obj.GetUpperBound(0); row++)
                    {
                        //for (int col = 1; col <= obj.GetUpperBound(1); col++) {
                        //    if (obj[row, col] == null) {
                        //        Console.WriteLine("NUl");
                        //        continue;
                        //    }

                        //    Console.WriteLine(obj[row, col].ToString());
                        //}
                        int numberGap = Int32.Parse(numUtil.getNumberByLetter(firstLetter));

                        //Area area = new Area(obj[row, Int32.Parse(numUtil.getNumberByLetter(demand.AreaColumn)) - numberGap + 1].ToString());
                        Area area = new Area("Luzon");
                        area = (Area)areaSessionData.createIfNotExist(area);

                        Regions region = new Regions(obj[row, Int32.Parse(numUtil.getNumberByLetter(demand.RegionColumn)) - numberGap + 1].ToString(), area.areaId);
                        region = (Regions)regionSessionData.createIfNotExist(region);

                        Cooperative cooperative = new Cooperative(obj[row, Int32.Parse(numUtil.getNumberByLetter(demand.CooperativeColumn)) - numberGap + 1].ToString(), "", region.regionId);
                        cooperative = (Cooperative)cooperativeSessionData.createIfNotExist(cooperative);


                        if (obj[row, Int32.Parse(numUtil.getNumberByLetter(demand.PlantColumn)) - numberGap + 1] == null)
                        {
                            continue;
                        }
                        Plant plant = new Plant(obj[row, Int32.Parse(numUtil.getNumberByLetter(demand.PlantColumn)) - numberGap + 1].ToString(), cooperative.cooperativeId);
                        plant = (Plant)plantSessionData.createIfNotExist(plant);
                        //plant = (Plant)plantSessionData.add(plant);

                        //if (plant == null) continue;

                        Console.WriteLine("Plant: " + plant.plantId);

                        DataType dataType = new DataType(obj[row, Int32.Parse(numUtil.getNumberByLetter(demand.PscEcsKeywordColumn)) - numberGap + 1].ToString());
                        dataType = (DataType)dataTypeSessionData.createIfNotExist(dataType);

                        DataValues dataValue = new DataValues(plant.plantId, dataType.dataTypeId);
                        dataValue = (DataValues)dataValuesSessionData.createIfNotExist(dataValue);

                        foreach (PscEcsData ecsData in demand.PscEcsData)
                        {
                            object dataObect = obj[row, Int32.Parse(numUtil.getNumberByLetter(ecsData.Column)) - numberGap + 1];
                            String data      = "0";

                            if (dataObect != null)
                            {
                                data = dataObect.ToString();
                            }

                            DataContent dataContent = new DataContent(ecsData.Name, data, dataValue.dataValuesId);
                            dataContentSessionData.add(dataContent);
                        }
                    }
                    excel.Close();
                }
                catch (WorksheetNotFoundException wnfe)
                {
                    MessageBox.Show(null, wnfe.Message, "Error Window", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                catch (RangeInvalidException rie)
                {
                    MessageBox.Show(null, rie.Message, "Error Window", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                catch (IndexOutOfRangeException iore) {
                    MessageBox.Show(null, "Index not in a range.", "Error Window", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else if (demand.RowSequenceType == RowSequenceType.Collection)
            {
                try
                {
                    excel = new ExcelUtil();

                    excel.AddWorkbook();
                    excel.Worksheet("Sheet1");

                    String cell = null;
                    String path = null;

                    foreach (String row in demand.RowCollection)
                    {
                        cell = demand.PlantColumnIndex + row;
                        path = @"='" + demand.Path + "\\[" + demand.FileName + "]" + demand.WorkSheet + "'!" + cell;
                        excel.WriteCell(1, 1, path);
                        String plantName = excel.ReadCell("A1").ToString();
                        Console.WriteLine(plantName);


                        int rowIndex = Int32.Parse(row) + 2;
                        for (int cntr = rowIndex; cntr < (rowIndex + 2); cntr++)
                        {
                            cell = demand.SupplyContractedKeywordColumn + cntr;
                            path = @"='" + demand.Path + "\\[" + demand.FileName + "]" + demand.WorkSheet + "'!" + cell;
                            excel.WriteCell(1, 1, path);
                            String data = excel.ReadCell("A1").ToString();

                            dataType = new DataType(data);
                            dataType = (DataType)dataTypeSessionData.createIfNotExist(dataType);
                            Console.WriteLine("data: " + dataType.dataTypeId);

                            Area area = new Area("Luzon");
                            area = (Area)areaSessionData.createIfNotExist(area);

                            Regions region = new Regions(demand.SupplyContractedRegion.ToString().Replace("_", " "), area.areaId);
                            region = (Regions)regionSessionData.createIfNotExist(region);

                            Cooperative cooperative = new Cooperative(demand.SupplyContractedCooperative, demand.SupplyContractedCooperativeAccronym, region.regionId);
                            cooperative = (Cooperative)cooperativeSessionData.createIfNotExist(cooperative);

                            Plant plant = new Plant(plantName, cooperative.cooperativeId);
                            plant = (Plant)plantSessionData.createIfNotExist(plant);
                            Console.WriteLine("Plant: " + plant.plantId);

                            //DataValues coopSearch = data
                            DataValues coopSearch = dataValuesSessionData.findDataValuesByPlantId(plant, dataType);
                            if (coopSearch != null)
                            {
                                dataContentSessionData.deleteByDataValueId(coopSearch.dataValuesId);
                                dataValue = coopSearch;
                            }
                            else
                            {
                                dataValue            = new DataValues();
                                dataValue.plantId    = plant.plantId;
                                dataValue.dataTypeId = dataType.dataTypeId;
                                dataValue            = (DataValues)dataValuesSessionData.add(dataValue);
                            }

                            foreach (DDPSupplyContractedData contractedData in demand.SupplyContractedData)
                            {
                                cell = contractedData.Column + cntr;
                                path = @"='" + demand.Path + "\\[" + demand.FileName + "]" + demand.WorkSheet + "'!" + cell;
                                excel.WriteCell(1, 1, path);
                                Console.WriteLine(contractedData.Name + " - " + excel.ReadCell(1, "A"));

                                dataContent              = new DataContent();
                                dataContent.header       = contractedData.Name;
                                dataContent.value        = excel.ReadCell("A1");
                                dataContent.dataValuesId = dataValue.dataValuesId;
                                dataContentSessionData.add(dataContent);
                            }
                        }
                    }

                    excel.Close();
                }
                catch (NullReferenceException nre)
                {
                    MessageBox.Show(null, nre.Message.ToString(), "Error Window", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }


            Console.WriteLine("Success!");
            Console.WriteLine(demand.Region);
        }
示例#4
0
        private void button2_Click(object sender, EventArgs e)
        {
            ExcelUtil excel = new ExcelUtil();

            //foreach(Area areas in areaSessionData.getAllRegionsByArea(Area.LUZON)){
            //    foreach (Regions region in areas.regions) {
            //       // Console.WriteLine(region.name);
            //    }
            //    //excel.WriteCell(1, rows++, region.name);
            //    //foreach (Regions region in areas.regions) {
            //    //    Console.WriteLine(region.name);
            //    //    excel.WriteCell(1,rows++, region.name);

            //    //}
            //}


            //int rows = 1;
            //int currentRow = 1;

            //foreach (Area area in areaSessionData.getAllAreas()) {
            //    Console.WriteLine(area.name);
            //    foreach (Regions region in area.regions) {
            //        Console.WriteLine(" +" + region.name);
            //        foreach (Cooperative coop in cooperativeDataSession.getCooperativeByRegion(region.regionId)) {
            //            Console.WriteLine("  +" + coop.name);
            //            foreach (Plant plant in plantDataSession.getAllPlantByCoop(coop.cooperativeId)) {
            //                Console.WriteLine("   +" + plant.name);
            //            }
            //        }
            //    }
            //}


            //foreach(Plant data in plantDataSession.getAllPlantData()){
            //    Console.WriteLine(data.name);

            //    excel.WriteCell(currentRow, 1, data.cooperative.region.area.name);
            //    excel.WriteCell(currentRow, 2, data.cooperative.region.name);
            //    excel.WriteCell(currentRow, 3, data.cooperative.name);
            //    ++currentRow;

            //    //currentRow++;
            //    excel.WriteCell(currentRow, 1, data.cooperative.region.area.name);
            //    excel.WriteCell(currentRow, 2, data.cooperative.region.name);
            //    excel.WriteCell(currentRow, 3, data.name);

            //    foreach (DataValues d in data.dataValues) {
            //        excel.WriteCell(currentRow, 4, d.d2008.ToString());
            //        excel.WriteCell(currentRow, 6, d.d2009.ToString());
            //        excel.WriteCell(currentRow, 8, d.d2010.ToString());
            //        excel.WriteCell(currentRow, 10, d.d2011.ToString());
            //        excel.WriteCell(currentRow, 12, d.d2012.ToString());
            //        excel.WriteCell(currentRow, 14, d.d2013.ToString());
            //        excel.WriteCell(currentRow, 16, d.d2014.ToString());
            //        excel.WriteCell(currentRow, 18, d.d2015.ToString());
            //        excel.WriteCell(currentRow, 20, d.d2016.ToString());
            //        excel.WriteCell(currentRow, 22, d.d2017.ToString());
            //        excel.WriteCell(currentRow, 24, d.d2018.ToString());
            //        excel.WriteCell(currentRow, 26, d.d2019.ToString());
            //        excel.WriteCell(currentRow, 28, d.d2020.ToString());
            //        excel.WriteCell(currentRow, 30, d.d2021.ToString());
            //        excel.WriteCell(currentRow, 32, d.d2022.ToString());
            //    }
            //    //currentRow = rows++;
            //    currentRow += 2;
            //}

            //excel.AddWorkbook();

            //excel.Worksheet("Sheet1");
            //excel.AddWorksheet("Sheet1");

            excel.AddWorkbook();
            excel.Worksheet("Sheet1");

            excel.WriteCell(1, 1, @"='E:\ECs (108)\1.  LUZON (50)\2013 DDP REGION 5 (11)\2013 ALECO DDP\[2013_aleco_ddp.xlsm]DDP-Demand'!$F$130");

            Console.WriteLine(excel.ReadCell(1, "A"));
            //excel.Save("test2.xlsx");
            excel.Close();
            Console.WriteLine("Success!");
        }