I know you can rotate text in an Excel cell, but how do you set vertical orientation? See below.
within MS Excel you do this using the Format Cells dialog:
Hello Steve,
You can set the rotation of the cell content in degrees, using IWorksheetCellFormat ‘rotation property.
Keep in mind cell text rotation, in degrees; 0 – 90 is up 0 – 90 degrees, 91 – 180 is down 1 – 90 degrees, and 255 is vertical.
So you should set it to 255 for vertical content.
Regards,