コード例 #1
0
        static void Test(string path)
        {
            ExcelDocument   one = new ExcelDocument();
            List <Document> res = one.Get(path);

            foreach (Document doc in res)
            {
                Console.WriteLine("Company: {0}.\n\tDocument: {1}", doc.Company, doc.Name);
                foreach (Position pos in doc.positions)
                {
                    Console.WriteLine("\t\tPosition: {0}; Level: {1}", pos.Name, pos.Level);
                }
            }
        }
コード例 #2
0
        static void Test_1()
        {
            string        path          = @"C:\Users\Miras Talaspayev\Downloads\Telegram Desktop\Test_OpenXml.xlsx";
            List <string> company_names = new List <string>();

            int[] company_index = new int[5] {
                2, 1, 0, 4, 3
            };

            using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(path, false))
            {
                WorkbookPart wbPart = spreadsheetDocument.WorkbookPart;
                Sheets       sheets = wbPart.Workbook.Sheets; // It is necessary only for getting names of company.
                foreach (Sheet sheet in sheets)
                {
                    company_names.Add(sheet.Name);
                }

                int comp = 0;
                foreach (WorksheetPart worksheetPart in wbPart.WorksheetParts)
                {
                    Console.WriteLine("Sheet: {0}. ", company_names[company_index[comp]]);
                    SheetData     sheetData = worksheetPart.Worksheet.Elements <SheetData>().First();
                    int           i         = 0;
                    List <string> Positions = new List <string>();

                    foreach (Row rows in sheetData.Elements <Row>())
                    {
                        if (i == 0)
                        {
                            i++;
                            continue;
                        }
                        if (i == 1)
                        {
                            foreach (Cell cell in rows.Elements <Cell>())
                            {
                                Positions.Add(ExcelDocument.CellString(cell, wbPart));
                            }
                            i++;
                            continue;
                        }
                        int    j    = 0;
                        string docs = null;

                        foreach (Cell cell in rows.Elements <Cell>())
                        {
                            if (j == 0)
                            {
                                docs = (ExcelDocument.CellString(cell, wbPart));
                                break;
                            }
                        }
                        Console.WriteLine("\t" + docs);
                        foreach (Cell cell in rows.Elements <Cell>())
                        {
                            if (ExcelDocument.CellString(cell, wbPart) == "+")
                            {
                                Console.WriteLine("\t\t" + Positions[j] + " " + cell.CellReference);
                            }
                            j++;
                        }
                        i++;
                    }
                    Console.WriteLine();
                    comp++;
                }
            }
        }