BACK | MQL Functions | MentDB Weak |
admin
excelx load "excelId" "/Users/jimmitry/Desktop/test.xlsx";
mentdb
1
admin
excelx load empty "excelId";
mentdb
1
admin
excelx show
mentdb
["excelId"]
admin
excelx save "excelId" "/Users/jimmitry/Desktop/test.xlsx";
mentdb
1
admin
excelx exist "excelId"
mentdb
1
admin
excelx sheet add "excelId" "sheet2";
mentdb
1
admin
excelx sheet delete "excelId" "sheet2";
mentdb
1
admin
excelx sheet max_row "excelId" "sheet2"
mentdb
432
admin
excelx sheet show "excelId"
mentdb
["sheet2"]
admin
excelx cell get "excelId" "sheet1" 1 1
mentdb
25
admin
excelx cell eval "excelId" "sheet1" 1 1
mentdb
25
admin
excelx cell ref "Z3";
mentdb
{"col": 25,"row": 2}
admin
excelx cell set "excelId" "sheet1" 1 1 "value" STR|NUM|BOOL|DATETIME|FORMULA|BLANK;
mentdb
1
admin
excelx close_all; excelx load empty "excelId"; excelx sheet add "excelId" "sheet1"; excelx cell set "excelId" "sheet1" 1 1 "str" STR; excelx cell set "excelId" "sheet1" 1 2 ".3478" NUM; excelx cell set "excelId" "sheet1" 1 3 true BOOL; excelx cell set "excelId" "sheet1" 1 4 (date systimestamp;) DATETIME; excelx cell set "excelId" "sheet1" 1 5 "C2+1" FORMULA; excelx cell set "excelId" "sheet1" 1 6 "" BLANK; excelx save "excelId" "/Users/jimmitry/Desktop/test.xlsx";
mentdb
1
admin
json load "style" "{}"; json iobject "style" / "HorizontalAlignment" "CENTER" STR; json iobject "style" / "HorizontalAlignment" "CENTER_SELECTION" STR; json iobject "style" / "HorizontalAlignment" "DISTRIBUTED" STR; json iobject "style" / "HorizontalAlignment" "FILL" STR; json iobject "style" / "HorizontalAlignment" "GENERAL" STR; json iobject "style" / "HorizontalAlignment" "JUSTIFY" STR; json iobject "style" / "HorizontalAlignment" "LEFT" STR; json iobject "style" / "HorizontalAlignment" "RIGHT" STR; json iobject "style" / "VerticalAlignment" "BOTTOM" STR; json iobject "style" / "VerticalAlignment" "TOP" STR; json iobject "style" / "VerticalAlignment" "DISTRIBUTED" STR; json iobject "style" / "VerticalAlignment" "JUSTIFY" STR; json iobject "style" / "VerticalAlignment" "CENTER" STR; json iobject "style" / "BorderBottom" "DASH_DOT" STR; json iobject "style" / "BorderBottom" "DASH_DOT_DOT" STR; json iobject "style" / "BorderBottom" "DASHED" STR; json iobject "style" / "BorderBottom" "DOTTED" STR; json iobject "style" / "BorderBottom" "DOUBLE" STR; json iobject "style" / "BorderBottom" "HAIR" STR; json iobject "style" / "BorderBottom" "MEDIUM" STR; json iobject "style" / "BorderBottom" "MEDIUM_DASH_DOT" STR; json iobject "style" / "BorderBottom" "MEDIUM_DASH_DOT_DOT" STR; json iobject "style" / "BorderBottom" "MEDIUM_DASHED" STR; json iobject "style" / "BorderBottom" "NONE" STR; json iobject "style" / "BorderBottom" "SLANTED_DASH_DOT" STR; json iobject "style" / "BorderBottom" "THICK" STR; json iobject "style" / "BorderBottom" "THIN" STR; json iobject "style" / "BorderTop" "DASH_DOT" STR; json iobject "style" / "BorderTop" "DASH_DOT_DOT" STR; json iobject "style" / "BorderTop" "DASHED" STR; json iobject "style" / "BorderTop" "DOTTED" STR; json iobject "style" / "BorderTop" "DOUBLE" STR; json iobject "style" / "BorderTop" "HAIR" STR; json iobject "style" / "BorderTop" "MEDIUM" STR; json iobject "style" / "BorderTop" "MEDIUM_DASH_DOT" STR; json iobject "style" / "BorderTop" "MEDIUM_DASH_DOT_DOT" STR; json iobject "style" / "BorderTop" "MEDIUM_DASHED" STR; json iobject "style" / "BorderTop" "NONE" STR; json iobject "style" / "BorderTop" "SLANTED_DASH_DOT" STR; json iobject "style" / "BorderTop" "THICK" STR; json iobject "style" / "BorderTop" "THIN" STR; json iobject "style" / "BorderLeft" "DASH_DOT" STR; json iobject "style" / "BorderLeft" "DASH_DOT_DOT" STR; json iobject "style" / "BorderLeft" "DASHED" STR; json iobject "style" / "BorderLeft" "DOTTED" STR; json iobject "style" / "BorderLeft" "DOUBLE" STR; json iobject "style" / "BorderLeft" "HAIR" STR; json iobject "style" / "BorderLeft" "MEDIUM" STR; json iobject "style" / "BorderLeft" "MEDIUM_DASH_DOT" STR; json iobject "style" / "BorderLeft" "MEDIUM_DASH_DOT_DOT" STR; json iobject "style" / "BorderLeft" "MEDIUM_DASHED" STR; json iobject "style" / "BorderLeft" "NONE" STR; json iobject "style" / "BorderLeft" "SLANTED_DASH_DOT" STR; json iobject "style" / "BorderLeft" "THICK" STR; json iobject "style" / "BorderLeft" "THIN" STR; json iobject "style" / "BorderRight" "DASH_DOT" STR; json iobject "style" / "BorderRight" "DASH_DOT_DOT" STR; json iobject "style" / "BorderRight" "DASHED" STR; json iobject "style" / "BorderRight" "DOTTED" STR; json iobject "style" / "BorderRight" "DOUBLE" STR; json iobject "style" / "BorderRight" "HAIR" STR; json iobject "style" / "BorderRight" "MEDIUM" STR; json iobject "style" / "BorderRight" "MEDIUM_DASH_DOT" STR; json iobject "style" / "BorderRight" "MEDIUM_DASH_DOT_DOT" STR; json iobject "style" / "BorderRight" "MEDIUM_DASHED" STR; json iobject "style" / "BorderRight" "NONE" STR; json iobject "style" / "BorderRight" "SLANTED_DASH_DOT" STR; json iobject "style" / "BorderRight" "THICK" STR; json iobject "style" / "BorderRight" "THIN" STR; json iobject "style" / "BottomBorderColor" "0,0,0" STR; json iobject "style" / "LeftBorderColor" "0,0,0" STR; json iobject "style" / "RightBorderColor" "0,0,0" STR; json iobject "style" / "TopBorderColor" "0,0,0" STR; json iobject "style" / "Hidden" false STR; json iobject "style" / "Locked" false STR; json iobject "style" / "QuotePrefixed" false STR; json iobject "style" / "ShrinkToFit" false STR; json iobject "style" / "WrapText" false STR; json iobject "style" / "Font" "{}" OBJ; json iobject "style" /Font "fontName" "Arial" STR; json iobject "style" /Font "size" 16 STR; json iobject "style" /Font "color" "255,0,0" STR; json iobject "style" /Font "bold" true STR; json iobject "style" /Font "italic" true STR; json iobject "style" / "Rotation" 90 STR; json iobject "style" / "FillPattern" "solid_foreground" STR; json iobject "style" / "FillPattern" "alt_bars" STR; json iobject "style" / "FillPattern" "big_spots" STR; json iobject "style" / "FillPattern" "bricks" STR; json iobject "style" / "FillPattern" "diamonds" STR; json iobject "style" / "FillPattern" "fine_dots" STR; json iobject "style" / "FillPattern" "least_dots" STR; json iobject "style" / "FillPattern" "less_dots" STR; json iobject "style" / "FillPattern" "no_fill" STR; json iobject "style" / "FillPattern" "sparse_dots" STR; json iobject "style" / "FillPattern" "squares" STR; json iobject "style" / "FillPattern" "thick_backward_diag" STR; json iobject "style" / "FillPattern" "thick_forward_diag" STR; json iobject "style" / "FillPattern" "thick_horz_bands" STR; json iobject "style" / "FillPattern" "thick_vert_bands" STR; json iobject "style" / "FillPattern" "thin_backward_diag" STR; json iobject "style" / "FillPattern" "thin_forward_diag" STR; json iobject "style" / "FillPattern" "thin_horz_bands" STR; json iobject "style" / "FillPattern" "thin_vert_bands" STR; json iobject "style" / "FillForegroundColor" "AQUA" STR; json iobject "style" / "FillForegroundColor" "AUTOMATIC" STR; json iobject "style" / "FillForegroundColor" "BLACK" STR; json iobject "style" / "FillForegroundColor" "BLUE" STR; json iobject "style" / "FillForegroundColor" "BLUE_GREY" STR; json iobject "style" / "FillForegroundColor" "BRIGHT_GREEN" STR; json iobject "style" / "FillForegroundColor" "BROWN" STR; json iobject "style" / "FillForegroundColor" "CORAL" STR; json iobject "style" / "FillForegroundColor" "CORNFLOWER_BLUE" STR; json iobject "style" / "FillForegroundColor" "DARK_BLUE" STR; json iobject "style" / "FillForegroundColor" "DARK_GREEN" STR; json iobject "style" / "FillForegroundColor" "DARK_RED" STR; json iobject "style" / "FillForegroundColor" "DARK_TEAL" STR; json iobject "style" / "FillForegroundColor" "DARK_YELLOW" STR; json iobject "style" / "FillForegroundColor" "GOLD" STR; json iobject "style" / "FillForegroundColor" "GREEN" STR; json iobject "style" / "FillForegroundColor" "GREY_25_PERCENT" STR; json iobject "style" / "FillForegroundColor" "GREY_40_PERCENT" STR; json iobject "style" / "FillForegroundColor" "GREY_50_PERCENT" STR; json iobject "style" / "FillForegroundColor" "GREY_80_PERCENT" STR; json iobject "style" / "FillForegroundColor" "INDIGO" STR; json iobject "style" / "FillForegroundColor" "LAVENDER" STR; json iobject "style" / "FillForegroundColor" "LEMON_CHIFFON" STR; json iobject "style" / "FillForegroundColor" "LIGHT_BLUE" STR; json iobject "style" / "FillForegroundColor" "LIGHT_CORNFLOWER_BLUE" STR; json iobject "style" / "FillForegroundColor" "LIGHT_GREEN" STR; json iobject "style" / "FillForegroundColor" "LIGHT_ORANGE" STR; json iobject "style" / "FillForegroundColor" "LIGHT_TURQUOISE" STR; json iobject "style" / "FillForegroundColor" "LIGHT_YELLOW" STR; json iobject "style" / "FillForegroundColor" "LIME" STR; json iobject "style" / "FillForegroundColor" "MAROON" STR; json iobject "style" / "FillForegroundColor" "OLIVE_GREEN" STR; json iobject "style" / "FillForegroundColor" "ORANGE" STR; json iobject "style" / "FillForegroundColor" "ORCHID" STR; json iobject "style" / "FillForegroundColor" "PALE_BLUE" STR; json iobject "style" / "FillForegroundColor" "PINK" STR; json iobject "style" / "FillForegroundColor" "PLUM" STR; json iobject "style" / "FillForegroundColor" "RED" STR; json iobject "style" / "FillForegroundColor" "ROSE" STR; json iobject "style" / "FillForegroundColor" "ROYAL_BLUE" STR; json iobject "style" / "FillForegroundColor" "SEA_GREEN" STR; json iobject "style" / "FillForegroundColor" "SKY_BLUE" STR; json iobject "style" / "FillForegroundColor" "TAN" STR; json iobject "style" / "FillForegroundColor" "TEAL" STR; json iobject "style" / "FillForegroundColor" "TURQUOISE" STR; json iobject "style" / "FillForegroundColor" "VIOLET" STR; json iobject "style" / "FillForegroundColor" "WHITE" STR; json iobject "style" / "FillForegroundColor" "YELLOW" STR; json iobject "style" / "FillBackgroundColor" "AQUA" STR; json iobject "style" / "FillBackgroundColor" "AUTOMATIC" STR; json iobject "style" / "FillBackgroundColor" "BLACK" STR; json iobject "style" / "FillBackgroundColor" "BLUE" STR; json iobject "style" / "FillBackgroundColor" "BLUE_GREY" STR; json iobject "style" / "FillBackgroundColor" "BRIGHT_GREEN" STR; json iobject "style" / "FillBackgroundColor" "BROWN" STR; json iobject "style" / "FillBackgroundColor" "CORAL" STR; json iobject "style" / "FillBackgroundColor" "CORNFLOWER_BLUE" STR; json iobject "style" / "FillBackgroundColor" "DARK_BLUE" STR; json iobject "style" / "FillBackgroundColor" "DARK_GREEN" STR; json iobject "style" / "FillBackgroundColor" "DARK_RED" STR; json iobject "style" / "FillBackgroundColor" "DARK_TEAL" STR; json iobject "style" / "FillBackgroundColor" "DARK_YELLOW" STR; json iobject "style" / "FillBackgroundColor" "GOLD" STR; json iobject "style" / "FillBackgroundColor" "GREEN" STR; json iobject "style" / "FillBackgroundColor" "GREY_25_PERCENT" STR; json iobject "style" / "FillBackgroundColor" "GREY_40_PERCENT" STR; json iobject "style" / "FillBackgroundColor" "GREY_50_PERCENT" STR; json iobject "style" / "FillBackgroundColor" "GREY_80_PERCENT" STR; json iobject "style" / "FillBackgroundColor" "INDIGO" STR; json iobject "style" / "FillBackgroundColor" "LAVENDER" STR; json iobject "style" / "FillBackgroundColor" "LEMON_CHIFFON" STR; json iobject "style" / "FillBackgroundColor" "LIGHT_BLUE" STR; json iobject "style" / "FillBackgroundColor" "LIGHT_CORNFLOWER_BLUE" STR; json iobject "style" / "FillBackgroundColor" "LIGHT_GREEN" STR; json iobject "style" / "FillBackgroundColor" "LIGHT_ORANGE" STR; json iobject "style" / "FillBackgroundColor" "LIGHT_TURQUOISE" STR; json iobject "style" / "FillBackgroundColor" "LIGHT_YELLOW" STR; json iobject "style" / "FillBackgroundColor" "LIME" STR; json iobject "style" / "FillBackgroundColor" "MAROON" STR; json iobject "style" / "FillBackgroundColor" "OLIVE_GREEN" STR; json iobject "style" / "FillBackgroundColor" "ORANGE" STR; json iobject "style" / "FillBackgroundColor" "ORCHID" STR; json iobject "style" / "FillBackgroundColor" "PALE_BLUE" STR; json iobject "style" / "FillBackgroundColor" "PINK" STR; json iobject "style" / "FillBackgroundColor" "PLUM" STR; json iobject "style" / "FillBackgroundColor" "RED" STR; json iobject "style" / "FillBackgroundColor" "ROSE" STR; json iobject "style" / "FillBackgroundColor" "ROYAL_BLUE" STR; json iobject "style" / "FillBackgroundColor" "SEA_GREEN" STR; json iobject "style" / "FillBackgroundColor" "SKY_BLUE" STR; json iobject "style" / "FillBackgroundColor" "TAN" STR; json iobject "style" / "FillBackgroundColor" "TEAL" STR; json iobject "style" / "FillBackgroundColor" "TURQUOISE" STR; json iobject "style" / "FillBackgroundColor" "VIOLET" STR; json iobject "style" / "FillBackgroundColor" "WHITE" STR; json iobject "style" / "FillBackgroundColor" "YELLOW" STR; excelx cell format "excelId" "sheet1" 1 1 "@" (json doc "style")
mentdb
1
admin
excelx close "excelId";
mentdb
1
admin
excelx close_all;
mentdb
1