This project has moved and is read-only. For the latest updates, please go here.

How can I adjust the width of columns by pixel?

Jul 16, 2015 at 9:27 AM
Here is my code when I do this:
WorkSheet.Column(1).Width = pixel / 8;

When the pixel is 72 here, then this "WorkSheet.Column(1)" in the outcoming excel file is 72 pixels wide. But I have no idea what this proportion, which is 8 here, stands for. Although 8 works well in my computer, it seems that this proportion varies among different machines.