Common functions (3)

1. Get the sheet name in excl
Sysexcelworkbooks workbooks = application. workbooks ();
Sysexcelworkbook workbook;
Sysexcelworksheets worksheets;
Sysexcelworksheet worksheet;
Workbook = workbooks. Item (1 );
Worksheets = Workbook. worksheets ();
Worksheet = worksheets. itemfromnum (1 );

2. Remove the hidden quote formula from Excel
Substitute (C4, char (9 ),)

3. Excel
= Text (C4, 0) and then copy and paste it with a numeric value
At this moment, the exciting little green arrow has appeared.

4. Random Number acquisition
Randomgenerate = new randomgenerate ();
Print randomgenerate. randomint (1000,9999 );
Pause;

5. Get the integer, not rounded
Rounddowndec (1.25, 0)

6. Obtain the Inventory Unit
Inventtablemodule: Find (inventtable. Itemid, moduleinventpurchsales: invent, true). unitid;

7. quantity of materials
While select inventsum where inventsum. Itemid = inventtable. Itemid
Join inventdim
Where (inventdim. inventdimid = inventsum. inventdimid )&&
(Inventdim. inventlocationid = "dip warehouse "){
Qty + = inventsum. physicalinvent ();
}
Info (int2str (qty ));