示例#1
0
        private static void AddTable(ExcelDoc d, string name, double[] columnsSize, string[] header, string[,] content)
        {
            if (columnsSize == null || header == null || content == null || columnsSize.Length != header.Length || columnsSize.Length != content.GetLength(1))
            {
                throw new Exception("Входные параметры имели не верный формат");
            }
            if (columnsSize.Length == 0)
            {
                return;
            }

            ExcelSheet s = d.AddSheet(name);

            s.CreateColumns(columnsSize);
            for (int c = 0; c < columnsSize.Length; c++)
            {
                if (!string.IsNullOrEmpty(header[c]) && header[c][0] == '=')
                {
                    s.SetCellFormulaValue(0, c, header[c], false, ValueTypes.String, CellStyles.BoldBorderCenter);
                }
                else
                {
                    s.SetCellStringValue(0, c, header[c], ValueTypes.String, CellStyles.BoldBorderCenter);
                }
            }
            for (int r = 0; r < content.GetLength(0); r++)
            {
                for (int c = 0; c < content.GetLength(1); c++)
                {
                    if (!string.IsNullOrEmpty(content[r, c]) && content[r, c][0] == '=')
                    {
                        s.SetCellFormulaValue(r + 1, c, content[r, c], false, ValueTypes.String, CellStyles.NormalBorderLeft);
                    }
                    else
                    {
                        s.SetCellStringValue(r + 1, c, content[r, c], ValueTypes.String, CellStyles.NormalBorderLeft);
                    }
                }
            }
            d.Save();
            d.Close();
        }
示例#2
0
 internal void Dispose()
 {
     Parent = null;
 }
示例#3
0
 internal SheetCells(ExcelSheet parent)
 {
     Parent = parent;
 }