neoExcel Sample App
neoExcel
SinLios
1.0
neoExcel Sample App
HTC Evo 3D
False
960
540
False
False
False
False
WebApp
False
C:\Users\User\Documents\VisualNeoWeb\Libraries\img\default-icon.png
en
standalone
Offline page
#000000
/
[AndroidOS,iOS,WindowsPhoneOS]
normal
True
True
False
True
True
False
False
True
False
False
SetFocusGlowColor "#df7326"
0px
110px
400px
370px
svgBlob2
deform
400px
210px
435px
45px
[weights]
56.3,78.3,112.4,87.6,59.7
400px
310px
435px
45px
[heights]
1.58,1.73,1.80,1.65,1.64
670px
385px
165px
50px
Generate Excel File
.Separate each value in a different Array element
StrParse "[weights]" "," [weightArray]
StrParse "[heights]" "," [heightArray]
.Total number of elements
SetVar [totalData] [weightArray.length]
SetVar [totalData] [totalData]-1
.Strings to numbers
Loop 0 [totalData] [n]
ToNumber [weightArray([n])] [weightArray([n])]
ToNumber [heightArray([n])] [heightArray([n])]
EndLoop
.New document
neoExcelCreate "doc1"
neoExcelAddSheet "doc1" "sheet1" "BMI Calculator"
.Title
neoExcelSetCellText "doc1" "sheet1" 2 2 "BMI Calculator"
neoExcelSetCellStyle "doc1" "sheet1" 2 2 true false false "center" 0 "" ""
..........................................
neoExcelMergeCells "doc1" "sheet1" "B2" "J2"
..........problem.................
neoExcelMergeCells "doc1" "sheet1" "L2" "O2"
.Headers
neoExcelSetCellText "doc1" "sheet1" 4 2 "Weight"
neoExcelSetCellText "doc1" "sheet1" 4 3 "Height"
neoExcelSetCellText "doc1" "sheet1" 4 4 "BMI"
neoExcelSetCellStyle "doc1" "sheet1" 4 2 false false false "" 0 "" "#d9e1f2"
neoExcelSetCellStyle "doc1" "sheet1" 4 3 false false false "" 0 "" "#d9e1f2"
neoExcelSetCellStyle "doc1" "sheet1" 4 4 false false false "" 0 "" "#e2efda"
.Data to sheet
neoExcelArrayToCol "doc1" "sheet1" 5 2 [weightArray]
neoExcelArrayToCol "doc1" "sheet1" 5 3 [heightArray]
.BMI calc
SetVar [finalPosition] [totalData]+5
neoExcelSharedFormula "doc1" "sheet1" "D5" "D[finalPosition]" "ROUND(B5/(C5^2),2)"
neoExcelSave "doc1" "bmi.xlsx"
400px
180px
435px
30px
Enter comma separated weights (Kg.)
400px
280px
435px
30px
Enter comma separated heights (m.)
0px
0px
960px
80px
25px
25px
910px
75px
neoExcel Sample App
26px
75px
890px
75px
svgDivider2
deform
44px
464px
890px
75px
svgDivider2
deform
107px
215px
210px
130px
This sample app will generate a <strong>Microsoft Excel </strong>file from the entered data.<br><br>It will add a column to calculate <strong>BMI</strong> (<em>Body Mass Index</em>)<br><br>
0px
0px
960px
540px
False
custom