Ejemplo n.º 1
0
        public static void ExportGrid(DataGridView pGrid, string pFileNamePrefix)
        {
            object[]    vHeader = new object[pGrid.ColumnCount];
            string[]    vFormat = new string[pGrid.ColumnCount];
            ExlHAlign[] vHAlign = new ExlHAlign[pGrid.ColumnCount];
            object[,] vData = new object[pGrid.RowCount, pGrid.ColumnCount];
            int vColIndex = -1;

            ///
            for (int c = 0; c <= pGrid.ColumnCount - 1; c++)
            {
                if (pGrid.Columns[c].Visible == true && pGrid.Columns[c].Name != "FILLER")
                {
                    vColIndex++;
                    ///
                    vHeader[vColIndex] = pGrid.Columns[c].HeaderText;
                    ///
                    vFormat[vColIndex] = pGrid.Columns[c].DefaultCellStyle.Format;
                    ///
                    switch (pGrid.Columns[c].DefaultCellStyle.Alignment)
                    {
                    default:
                    case DataGridViewContentAlignment.TopLeft:
                    case DataGridViewContentAlignment.BottomLeft:
                    case DataGridViewContentAlignment.MiddleLeft:
                        vHAlign[vColIndex] = ExlHAlign.xlHAlignLeft;
                        break;

                    case DataGridViewContentAlignment.TopRight:
                    case DataGridViewContentAlignment.BottomRight:
                    case DataGridViewContentAlignment.MiddleRight:
                        vHAlign[vColIndex] = ExlHAlign.xlHAlignRight;
                        break;

                    case DataGridViewContentAlignment.TopCenter:
                    case DataGridViewContentAlignment.BottomCenter:
                    case DataGridViewContentAlignment.MiddleCenter:
                        vHAlign[vColIndex] = ExlHAlign.xlHAlignCenter;
                        break;
                    }
                    ///
                    for (int r = 0; r <= pGrid.RowCount - 1; r++)
                    {
                        vData[r, vColIndex] = pGrid[c, r].FormattedValue;
                    }
                }
            }
            ///
            Array.Resize <object>(ref vHeader, (vColIndex + 1));
            Array.Resize <string>(ref vFormat, (vColIndex + 1));
            Array.Resize <ExlHAlign>(ref vHAlign, (vColIndex + 1));
            ///
            ExlUtil.Export(vHeader, vFormat, vHAlign, vData, pFileNamePrefix);
        }
Ejemplo n.º 2
0
 public void ExportGrid(string pFileNamePrefix)
 {
     ExlUtil.ExportGrid(this, pFileNamePrefix);
 }