Tuesday, January 8, 2019

Creating Excel Template from Product Master

class ASAPG_ProductMaster_ImportTemplate extends RunBase
{

}
------------
public static void main(Args _args)
{
    SysExcelApplication excel;
    SysExcelWorkbooks   workbooks;
    SysExcelWorkbook    workbook;
    SysExcelWorksheets  worksheets;
    SysExcelWorksheet   worksheet;
    SysExcelCells       cells;

    //color and font
    SysExcelStyles      styles;
    SysExcelStyle       style;
    SysExcelFont        font;
    /// end

    COMVariantType      type;
    int                 row, column;
    Set                 set = new set(Types::Int64);
    SysExcelCell        cell;
    container           con;
    str                 delimiter="\\";
    Map                 map = new  Map(Types::String,Types::Integer);


    if (Box::yesNo("Do you want to create Product master template" ,DialogButton::Yes) == DialogButton::Yes)
    {
        excel       = SysExcelApplication::construct();
        workbooks   = excel.workbooks();
        workbook    = workbooks.add();

        styles      = workbook.styles();
        style       = styles.add("Header");
        font        = style.font();
        font.bold(true);
        font.color(255);

        worksheets  = workbook.worksheets();
        worksheet   = worksheets.itemFromNum(1);
        cells       = worksheet.cells();
        cells.range('A:A').numberFormat('@');
        row=1;

        cell = cells.item(row,1);cell.value("ITEMID");
        cell = cells.item(row,2);cell.value("STOCKNUMBER");
        cell = cells.item(row,3);cell.value("PARTNUMBER");
        cell = cells.item(row,4);cell.value("CARTONQTY");
        cell = cells.item(row,5);cell.value("BOXQTY");
        cell = cells.item(row,6);cell.value("CARTYPE");
        cell = cells.item(row,7);cell.value("BRAND");
        cell = cells.item(row,8);cell.value("ITEMTYPE");
        cell = cells.item(row,9);cell.value("HSCODE");
        cell = cells.item(row,10);cell.value("VEHICLETYPE");
        cell = cells.item(row,11);cell.value("ORIGIN");
        cell = cells.item(row,12);cell.value("REFERENCE");
        cell = cells.item(row,13);cell.value("MODELNUMBER");
        cell = cells.item(row,14);cell.value("NETWEIGHT");
        cell = cells.item(row,15);cell.value("TARAWEIGHT");


        excel.visible(true);
    }
}



No comments:

Post a Comment