I am using a .NET WinForm app to control the Excel programmtically.
The data will be generated as XML and imported into Excel. So every
time, I need to do a refresh. Once I refresh the data using menu Data
--> Refresh Data, the formatting made explicitly will be gone.

I have two formatting problems.

1. After I dropping a field in the Column Fields area, there are
multiple columns in the Data Item area (the main area for the numeric
data). By default there is no vertical lines between these data
columsn. How to add vertical lines in this area?

2. After dropping a field into the Row Fields area, the row data will
be aligned in the center. But since it is text, I want to align it to
the left. How to do that?

It seems that Excel has its default formatting (such as vertical lines
and alignment) for the PivotTable. Is there a way to change that?

Thanks!