S
stizalke
Guest
Hi. Its me again. I have convert from text file format to excel format. The separation is based on "|" pipeline delimiters.
So, some of the columns are not very consistent. For example, for column L, | Extended |
The column is not consistent when, in Monday, the column will be,
Monday - | Extended |
Tuesday- | Extended|
Wednesday - |Extended|
My question is, is there any possible solutions for this sensitive case for columns?
This is my code currently,
fld = CType(pvt.PivotFields(" Extended"), PivotField)
fld.Orientation = XlPivotFieldOrientation.xlDataField
fld.Function = XlConsolidationFunction.xlSum
I have to edit the "space" every time problem occurred. Please Help me,
Thank you, Regards
Continue reading...
So, some of the columns are not very consistent. For example, for column L, | Extended |
The column is not consistent when, in Monday, the column will be,
Monday - | Extended |
Tuesday- | Extended|
Wednesday - |Extended|
My question is, is there any possible solutions for this sensitive case for columns?
This is my code currently,
fld = CType(pvt.PivotFields(" Extended"), PivotField)
fld.Orientation = XlPivotFieldOrientation.xlDataField
fld.Function = XlConsolidationFunction.xlSum
I have to edit the "space" every time problem occurred. Please Help me,
Thank you, Regards
Continue reading...