/// <summary> /// /// </summary> private void ExportHeader() { // column headtext // int headerRow = this._currentRow; foreach (DataGridViewColumn dgvcol in _dgv.Columns) { int headerCol = dgvcol.DisplayIndex + 1; string headerValue = dgvcol.HeaderText; XlsFile.SetCellValue(headerRow, headerCol, headerValue); } }
private void setExcelColumnValues(FlexCel.XlsAdapter.XlsFile xls, int rowStart, int column, String[] arr) { for (int i = 0; i < arr.Length; i++) { xls.SetCellValue(rowStart + i, column, arr[i]); } }