コード例 #1
0
        private void DoExport(string saveFileName, string rootName, string elemName, Action <Row[]> buildContent, bool hasKey)
        {
            if (File.Exists(saveFileName))
            {
                saveFileName = saveFileName.Replace(".xlsx", "_2.xlsx");
            }

            Console.WriteLine("Export Excel {0}", saveFileName);

            selectedColor = 0;
            columnWidthAndStyle.Clear();
            SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(saveFileName, SpreadsheetDocumentType.Workbook);

            // Add a WorkbookPart to the document.
            WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();

            spreadsheetDocument.ChangeIdOfPart(workbookpart, "rIdbk0");
            workbookpart.Workbook = new Workbook();

            AppendStylePart(spreadsheetDocument);

            // Add a WorksheetPart to the WorkbookPart.
            WorksheetPart worksheetPart = workbookpart.AddNewPart <WorksheetPart>("rIdsht0");

            worksheetPart.Worksheet = new Worksheet();

            AppendSheetViews(worksheetPart, hasKey);

            Columns columns = new Columns();

            worksheetPart.Worksheet.AppendChild(columns);

            Row[] rows = AppendDefaultRows(worksheetPart, workbookpart, string.IsNullOrEmpty(elemName) ? rootName : rootName + "/" + elemName);
            buildContent(rows);

            AppendColumns(columns, hasKey);

            workbookpart.Workbook.Save();

            // Close the document.
            spreadsheetDocument.Close();

            RepackFile(saveFileName);
        }
コード例 #2
0
        public void ExportEnums()
        {
            string folder       = Path.GetFullPath(PathManager.Instance.ExternalExcelExampleFolder);
            string saveFileName = Path.Combine(folder, "enum.xlsx");

            if (File.Exists(saveFileName))
            {
                File.Delete(saveFileName);
            }

            SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(saveFileName, SpreadsheetDocumentType.Workbook);

            // Add a WorkbookPart to the document.
            WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();

            spreadsheetDocument.ChangeIdOfPart(workbookpart, "rIdbk0");
            workbookpart.Workbook = new Workbook();

            AppendStylePart(spreadsheetDocument);

            // Add a WorksheetPart to the WorkbookPart.
            WorksheetPart worksheetPart = workbookpart.AddNewPart <WorksheetPart>("rIdsht0");

            worksheetPart.Worksheet = new Worksheet();

            Columns columns = new Columns();

            columns.AppendChild(new Column()
            {
                Min   = 1,
                Max   = 1,
                Width = 20,
            });
            columns.AppendChild(new Column()
            {
                Min   = 2,
                Max   = 2,
                Width = 10,
            });
            columns.AppendChild(new Column()
            {
                Min   = 3,
                Max   = 3,
                Width = 20,
            });
            columns.AppendChild(new Column()
            {
                Min   = 4,
                Max   = 4,
                Width = 20,
            });
            worksheetPart.Worksheet.AppendChild(columns);

            SheetData sheetData = AppendSheet(worksheetPart, workbookpart);

            int maxlen = 0;

            foreach (var type in enums)
            {
                var nocommentAttribute = TypeUtil.GetCustomAttribute <NoCommentAttribute>(type, false);
                if (nocommentAttribute != null)
                {
                    continue;
                }

                UInt32Value style = 5;
                Row         row   = sheetData.AppendChild(new Row()
                {
                    CustomFormat = true, StyleIndex = style
                });
                row.AppendChild(CreateCell(type.Name, style, ref maxlen));

                string[] names = Enum.GetNames(type);
                foreach (var name in names)
                {
                    if (row == null)
                    {
                        row = sheetData.AppendChild(new Row());
                        row.AppendChild(CreateCell("", null, ref maxlen));
                    }
                    var value = Enum.Parse(type, name);
                    row.AppendChild(CreateCell(TypeUtil.GetEnumComment(type, value as Enum), style, ref maxlen));
                    row.AppendChild(CreateCell(name, style, ref maxlen));
                    row.AppendChild(CreateCell((int)value, style, ref maxlen));
                    row   = null;
                    style = null;
                }
            }

            workbookpart.Workbook.Save();

            // Close the document.
            spreadsheetDocument.Close();

            RepackFile(saveFileName);
        }