Esempio n. 1
0
        // TODO: Move to OOXML
        public static void Export(this IEnumerable data, Stream stream, List<ExportColumnModel> colModel)
        {
            var workbook = new HSSFWorkbook();

            ////create a entry of DocumentSummaryInformation
            var dsi = PropertySetFactory.CreateDocumentSummaryInformation();
            dsi.Company = "Higgs RIA Framework";
            workbook.DocumentSummaryInformation = dsi;

            ////create a entry of SummaryInformation
            var si = PropertySetFactory.CreateSummaryInformation();
            si.Subject = "JqGrid Export Data";
            workbook.SummaryInformation = si;

            var sheet = workbook.CreateSheet("Export-Data");
            var count = 1;

            var firstRow = sheet.CreateRow(0);
            for(var i = 0;i < colModel.Count;i++)
            {
                firstRow
                    .CreateCell(i)
                    .SetCellValue(colModel[i].Title);
            }

            sheet.CreateFreezePane(0, 1);

            Dictionary<string, PropertyInfo> properties = null;
            foreach (var item in data)
            {
                if (properties == null)
                {
                    properties = item.GetType()
                                     .GetProperties()
                                     .ToDictionary(pi => pi.Name);
                }

                var row = sheet.CreateRow(count++);

                for (var i = 0; i < colModel.Count; i++)
                {
                    var cell = row.CreateCell(i);

                    if(!properties.ContainsKey(colModel[i].Name)) continue;
                    var cellValue = properties[colModel[i].Name].GetValue(item, null);

                    workbook.SetCellValue(cell, cellValue);
                }
            }

            for (var i = 0; i < colModel.Count; i++)
            {
                sheet.AutoSizeColumn(i);
            }

            workbook.Write(stream);
        }
Esempio n. 2
0
        public static void Export(this DataTable data, Stream stream)
        {
            var workbook = new HSSFWorkbook();

            ////create a entry of DocumentSummaryInformation
            var dsi = PropertySetFactory.CreateDocumentSummaryInformation();
            dsi.Company = "Higgs RIA Framework";
            workbook.DocumentSummaryInformation = dsi;

            ////create a entry of SummaryInformation
            var si = PropertySetFactory.CreateSummaryInformation();
            si.Subject = "JqGrid Export Data";
            workbook.SummaryInformation = si;

            var sheet = workbook.CreateSheet("Export-Data");
            var count = 1;

            var firstRow = sheet.CreateRow(0);
            for (var i = 0; i < data.Columns.Count; i++)
            {
                firstRow
                    .CreateCell(i)
                    .SetCellValue(data.Columns[i].ColumnName);
            }

            sheet.CreateFreezePane(0, 1);

            foreach (DataRow r in data.Rows)
            {
                var row = sheet.CreateRow(count++);

                for (var i = 0; i < data.Columns.Count; i++)
                {
                    var cell = row.CreateCell(i);
                    var cellValue = r[i];

                    workbook.SetCellValue(cell, cellValue);
                }
            }

            for (var i = 0; i < data.Columns.Count; i++)
            {
                sheet.AutoSizeColumn(i);
            }

            workbook.Write(stream);
        }