creating a class .. and in main () using dialog window to ask yes or no
-------------------------------------------------------
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);
}
}
----------------------------------------
This is all about Microsoft Dynamics AX(formerly known as Axapta). This site contains some Microsoft Dynamics AX X++ Codes for use in your day to day use as well future changes.
Subscribe to:
Post Comments (Atom)
Labels
#veryusefulcode
(1)
AIF
(8)
AOT Maps
(1)
Args
(1)
Ax 2009 Reports
(2)
AX 2012 navigation
(1)
Ax 2012 Interview Questions
(1)
AX 7
(2)
AX Architecture
(1)
Ax Backup
(1)
AX Workflow
(2)
AX2012
(1)
AX2012 R2
(1)
Ax2012R3
(1)
AX2012R3 Dynamics Connector Step by Step Installation and Configuration
(1)
AX2012R3 EP Step by Step Installation and Configuration EP R3
(1)
AX2012R3 HelpServer Step by Step Installation and Configuration
(1)
AX2012R3 Rapid Start Connector Step by Step Installation and Configuration
(1)
AX2012R3 Report Server and Analysis Server Step by Step Installation and Configuration
(1)
AX7
(1)
Best practices
(1)
Blocking user to enter
(1)
Collection Classes
(1)
Container
(1)
D365FO
(3)
Data Migration Frame Work ax 2012R3
(1)
Deleting duplicate Record from Table – Ax2012
(1)
Delivery due date notification workflow in Ax 2012
(1)
Development Steps EP
(1)
Dimensions
(1)
DIXF
(1)
DMF in Ax 2012 R3
(1)
Dynamics Ax 2012 Interview Questions
(1)
DYNAMICS AX 2012 INTERVIEW QUESTIONS PART 2
(1)
DYNAMICS AX 7
(1)
EDT relation Migration Tool
(1)
EP AX 2012
(1)
Ep Lookup
(1)
Error
(1)
Event Handler
(1)
F5
(1)
File Handling
(4)
Filter on AX2012 Listpage
(1)
filtering
(2)
financial dimensions in AX 2012
(3)
form
(1)
images
(1)
Installation and Configration
(4)
Installation and Configuration
(11)
Installation of Management Reporter 2012 for AX 2012
(1)
Interaction class in ax 2012
(1)
Interview Question
(1)
Interview Questions For Ax 2012
(1)
Invent DIm
(1)
Jobs
(2)
license
(1)
List page and form menuitem enable code
(1)
Methods
(1)
microsoft Dynamics AX 365FO
(1)
Number Sequence Generation – AX 2012
(5)
Number Sequence2012
(1)
OLTP-OLAP
(1)
Passing Args
(1)
Passing form caller and menu item caller in ax 2012
(1)
Passing Multiple Records Args
(1)
Posting in Ax 2012
(1)
POSTING PURCHASE ORDER
(1)
Query
(1)
Query Filter Form
(2)
Query Ranges in X++
(1)
Question and Answer
(1)
Report
(1)
Reports Controller class
(1)
RLS in ax 2009
(1)
SALES ORDER IMPORT/EXPORT FRAMEWORK BY DMF
(1)
Security
(1)
security roles
(1)
Security Sysqueryrangeutil
(1)
Sharepoint 2016
(1)
SQL SERVER
(1)
SSRS
(2)
SSRS Reports Controller class
(2)
Table collections & Virtual company
(1)
Time
(1)
TIPS AND TRICKS
(1)
Web service AIF
(3)
Web Services on IIS (AIF) Step by Step Installation and Configuration
(1)
workflow ax2012
(1)
Workflow installation
(1)
Workflow Method
(3)
X++
(1)
I will recommend anyone looking for Business loan to mr benjamin who helped me with Four Million USD loan to startup my business and it's was fast When obtaining a loan from them it was surprising at how easy they were to work with.The process was fast and secure. It was definitely a positive experience.Avoid scammers on here and contact mr benjamin On. 247officedept@gmail.com . WhatsApp...+ 19893943740. if you looking for business loan.
ReplyDelete