when we are generating a report in excel from. Net we have to put the names of the columns and would be too Tedis enter the locations of the columns one by one, ie hacierndo a list of columns
column (1) =
"A"
098.
column (2) =
"B"
099.
column (3) =
"C"
100.
column (4) =
"D"
101.
column (5) =
"E"
102.
column (6) =
"F"
103.
column (7) =
"G"
why I leave here this code: where the chain vector contains the names of the columns that are going to admit, but as locations realize the operation with a cycle of size name to be placed
For i = 1 To cadena.Length - 1
Then If n = 90 n = 65
m = 64
If End If m> 0 Then
m + = 1
xlApp.Range (Chr (n) & Chr (m) & "7"). Value = string (i). ToString () Else
n + = 1
xlApp.Range (Chr (n) & "7"). Value = string (i). ToString () End If
Next
0 comments:
Post a Comment