コード例 #1
0
ファイル: ExcelToHtmlConverter.cs プロジェクト: ctddjyds/npoi
        protected void ProcessColumnHeaders(HSSFSheet sheet, int maxSheetColumns,
            XmlElement table)
        {
            XmlElement tableHeader = htmlDocumentFacade.CreateTableHeader();
            table.AppendChild(tableHeader);

            XmlElement tr = htmlDocumentFacade.CreateTableRow();

            if (OutputRowNumbers)
            {
                // empty row at left-top corner
                tr.AppendChild(htmlDocumentFacade.CreateTableHeaderCell());
            }

            for (int c = 0; c < maxSheetColumns; c++)
            {
                if (!OutputHiddenColumns && sheet.IsColumnHidden(c))
                    continue;

                XmlElement th = htmlDocumentFacade.CreateTableHeaderCell();
                string text = GetColumnName(c);
                th.AppendChild(htmlDocumentFacade.CreateText(text));
                tr.AppendChild(th);
            }
            tableHeader.AppendChild(tr);
        }
コード例 #2
0
ファイル: ExcelToHtmlConverter.cs プロジェクト: ctddjyds/npoi
        /**
     * Creates COLGROUP element with width specified for all columns. (Except
     * first if <tt>{@link #isOutputRowNumbers()}==true</tt>)
     */
        protected void ProcessColumnWidths(HSSFSheet sheet, int maxSheetColumns,
                XmlElement table)
        {
            // draw COLS after we know max column number
            XmlElement columnGroup = htmlDocumentFacade.CreateTableColumnGroup();
            if (OutputRowNumbers)
            {
                columnGroup.AppendChild(htmlDocumentFacade.CreateTableColumn());
            }
            for (int c = 0; c < maxSheetColumns; c++)
            {
                if (!OutputHiddenColumns && sheet.IsColumnHidden(c))
                    continue;

                XmlElement col = htmlDocumentFacade.CreateTableColumn();
                col.SetAttribute("width", GetColumnWidth(sheet, c).ToString());
                columnGroup.AppendChild(col);
            }
            table.AppendChild(columnGroup);
        }