How-to

All Posts
News
How-to
AJXF

Sep 8
1 min

Import a text file into Excel

Did you try to import a text file into Excel before? Sound simple but there's much more to it than just copy and paste. In this how-to tu...

47 viewsWrite a comment

Convert Excel Workbook to REST API (Web service)

Raymond Tam

Sep 4
1 min

Convert Excel Workbook to REST API (Web service)

Have you ever wanted to turn your Excel spreadsheets into a web service or REST API? AlchemyJ allows you to turn excel to API easily. The...

129 views1 comment

Raymond Tam

May 21
4 min

Data Validation and Record Merging

We cannot ensure that everyone will submit data according to the requirement we've set and sometimes we are not sure if the records were ...

19 viewsWrite a comment

Perform CRUD Operation on Excel - Part 2 of 2

Raymond Tam

May 5
5 min

Perform CRUD Operation on Excel - Part 2 of 2

We will work on updating and deleting records in the database today with AlchemyJ. If you notice the pattern on both reading records and ...

19 viewsWrite a comment

Perform CRUD Operation on Excel - Part 1 of 2

Raymond Tam

May 3
6 min

Perform CRUD Operation on Excel - Part 1 of 2

This tutorial will show you how easy it is to perform CRUD operation to the database using AlchemyJ Our last post on executing SQL comman...

54 viewsWrite a comment

Raymond Tam

Apr 30
3 min

Execute SQL Statement in Excel

In this tutorial, we will execute the SQL Statement in Excel using AlchemyJ. Before we begin, ensure you have your database installed. Fo...

27 viewsWrite a comment

Generate OpenAPI (Swagger) Specification Automatically with AlchemyJ

Raymond Tam

Apr 29
4 min

Generate OpenAPI (Swagger) Specification Automatically with AlchemyJ

In this tutorial, I'm going to show you how you can enable OpenAPI (Swagger) from API generated by AJ For this tutorial, we are going to ...

24 viewsWrite a comment

How to write your first API with AlchemyJ

Raymond Tam

Apr 16
3 min

How to write your first API with AlchemyJ

This tutorial is going to start you off on how to use AlchemyJ as a tool to build your business model and turn it into API afterward. In ...

57 viewsWrite a comment

{"items":["5f5099dcab0c3d0018f56118","5ea136796ba5360017e86a11","5ec5e7b5b8c2000017958d14","5eafba91810e9d009b724d74","5eafa88350988a00c796106a","5eaa60047bec1400176a9346","5ea92df51414500017da48e9","5e95557d46058a001717f653"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"fill","cubeRatio":1.3333333333333333,"isVertical":true,"gallerySize":940,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":16,"galleryMargin":0,"floatingImages":0,"chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":1,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCubeRatio":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":1,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":1,"mobilePanorama":false,"placeGroupsLtr":false,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"useCustomButton":false,"bottomInfoHeight":0,"titlePlacement":"SHOW_ON_THE_RIGHT","galleryHorizontalAlign":"center","galleryTextAlign":"center","galleryVerticalAlign":"center","scrollSnap":false,"itemClick":"expand","fullscreen":true,"allowSocial":true,"allowDownload":false,"allowTitle":true,"allowDescription":false,"loveButton":true,"loveCounter":false,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","scrollDirection":0,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowTitleExpand":true,"allowDescriptionExpand":true,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","calculateTextBoxHeightMode":"AUTOMATIC","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":0,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"textsVerticalPadding":0,"textsHorizontalPadding":-30,"titleDescriptionSpace":6,"customButtonText":"","customButtonBorderWidth":1,"customButtonBorderRadius":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":1,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"gallerySizeType":"px","gallerySizePx":940,"itemBorderColor":{"themeName":"color_12","value":"rgba(204,204,204,1)"},"galleryLayout":2,"modifiedGallerySize":true,"selectedLayout":"2|bottom|1|fill|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":false,"externalInfoHeight":0,"externalInfoWidth":0.5},"container":{"width":940,"galleryWidth":972,"galleryHeight":1440,"scrollBase":0,"height":null}}