Aspose.Cells 设置行高和列宽（单位为磅、英寸、像素）

男娘i 2023-10-05 16:37 50阅读 0赞

### 1 设置行高 ###

#### 1.1 设置行高时单位为磅 ####

SetRowHeight(int column, double width)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //第一行的行高为10磅
    cells.SetRowHeight(0,10);

#### 1.2 设置行高时单位为英寸 ####

SetRowHeightInch(int row, double inches)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //第一行的行高为10英寸
    cells.SetRowHeightInch(0,10);

#### 1.3 设置行高时单位为像素 ####

SetRowHeightPixel(int row, int pixels)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //第一行的行高为10像素
    cells.SetRowHeightPixel(0,10);

### 2 设置列宽 ###

### 2.1 设置列宽时单位为磅 ###

SetColumnWidth(int column, double width)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //第一行的列宽为10磅
    cells.SetColumnWidth(0,10);

#### 2.2 设置列宽时单位为英寸 ####

SetColumnWidthInch(int column, double inches)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //第一行的列宽为10英寸
    cells.SetColumnWidthInch(0,10);

#### 2.3 设置列宽时单位为像素 ####

SetColumnWidthPixel(int column, int pixel)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //第一行的列宽为10像素
    cells.SetColumnWidthPixel(0,10);