Set Column Width

The following example shows you how to use Column class to set same width for first three columns.
import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Column;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;
import com.independentsoft.office.spreadsheet.styles.CellFormat;

public class Example {

    public static void main(String[] args)
    {
        try
        {
        	Workbook book = new Workbook();
            Worksheet sheet1 = new Worksheet();

            Cell a1 = new Cell(9.99);
            Cell a2 = new Cell(99.99);
            Cell a3 = new Cell(999.99);
            Cell a4 = new Cell(9999.99);
            Cell a5 = new Cell(99999.99);
            Cell a6 = new Cell(999999.99);
            Cell a7 = new Cell(9999999.99);
            Cell a8 = new Cell(99999999.99);
            Cell a9 = new Cell(999999999.99);
            Cell a10 = new Cell(9999999999.99);
            Cell a11 = new Cell(99999999999.99);
            Cell a12 = new Cell(999999999999.99);
            Cell a13 = new Cell(9999999999999.99);

            CellFormat format1 = new CellFormat();
            format1.setNumberFormatID(2); //builtin number format 0.00

            a1.setFormat(format1);
            a2.setFormat(format1);
            a3.setFormat(format1);
            a4.setFormat(format1);
            a5.setFormat(format1);
            a6.setFormat(format1);
            a7.setFormat(format1);
            a8.setFormat(format1);
            a9.setFormat(format1);
            a10.setFormat(format1);
            a11.setFormat(format1);
            a12.setFormat(format1);
            a13.setFormat(format1);

            sheet1.set("A1", a1);
            sheet1.set("A2", a2);
            sheet1.set("A3", a3);
            sheet1.set("A4", a4);
            sheet1.set("A5", a5);
            sheet1.set("A6", a6);
            sheet1.set("A7", a7);
            sheet1.set("A8", a8);
            sheet1.set("A9", a9);
            sheet1.set("A10", a10);
            sheet1.set("A11", a11);
            sheet1.set("A12", a12);
            sheet1.set("A13", a13);

            sheet1.set("B1", a1);
            sheet1.set("B2", a2);
            sheet1.set("B3", a3);
            sheet1.set("B4", a4);
            sheet1.set("B5", a5);
            sheet1.set("B6", a6);
            sheet1.set("B7", a7);
            sheet1.set("B8", a8);
            sheet1.set("B9", a9);
            sheet1.set("B10", a10);
            sheet1.set("B11", a11);
            sheet1.set("B12", a12);
            sheet1.set("B13", a13);

            sheet1.set("C1", a1);
            sheet1.set("C2", a2);
            sheet1.set("C3", a3);
            sheet1.set("C4", a4);
            sheet1.set("C5", a5);
            sheet1.set("C6", a6);
            sheet1.set("C7", a7);
            sheet1.set("C8", a8);
            sheet1.set("C9", a9);
            sheet1.set("C10", a10);
            sheet1.set("C11", a11);
            sheet1.set("C12", a12);
            sheet1.set("C13", a13);

            Column columnInfo = new Column();
            columnInfo.setFirstColumn(1); //from column A
            columnInfo.setLastColumn(3); //to column C
            columnInfo.setWidth(17);

            sheet1.getColumns().add(columnInfo);

            book.getSheets().add(sheet1);
            
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}
Independentsoft - any library, any programming language

JSpreadsheet > Tutorial > Set Column Width

Need help? Ask our developers:
