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