ðSheetJS JSã§Excel VBAãããã
SheetJSã³ãã¥ããã£çã¯ãã»ãŒãã¹ãŠã®è€éãªã¹ãã¬ããã·ãŒãããæçšãªããŒã¿ãæœåºããã¬ã¬ã·ãŒãœãããŠã§ã¢ã§ãææ°ãœãããŠã§ã¢ã§ãåæ§ã«åäœããæ°ããã¹ãã¬ããã·ãŒããçæããããã®ãå®æŠãã¹ãæžã¿ã®ãªãŒãã³ãœãŒã¹ãœãªã¥ãŒã·ã§ã³ãæäŸããŸãã
SheetJS Proã¯ãããŒã¿åŠçãè¶ ãããœãªã¥ãŒã·ã§ã³ãæäŸããŸãïŒ è€éãªãã³ãã¬ãŒããç°¡åã«ç·šéããããã¹ã¿ã€ãªã³ã°ã§ããªãã®å ãªããã«ãœãåŒãåºããããç»å/ã°ã©ã/ããããããŒãã«ã§ã«ã¹ã¿ã ã·ãŒããäœæããããæ°åŒãè©äŸ¡ããèšç®ãWebã¢ããªã±ãŒã·ã§ã³ã«ç§»æ€ããããäžè¬çãªã¹ãã¬ããã·ãŒãã¿ã¹ã¯ãèªååãããããã®ä»å€ãã®ããšãã§ããŸãïŒ
Webãã©ãŠã¶ããExcelãã¡ã€ã«ãçæããŠããŠã³ããŒããããæ©èœãå¯èœã«ãªãã®ã¯ãäž»ã«ä»¥äžã®ãããªæè¡çèæ¯ãšé²æ©ãããããã§ãïŒ
JavaScriptã®é²å: ãŠã§ãã¢ããªã±ãŒã·ã§ã³ã®ããã³ããšã³ãã§åäœããJavaScriptã¯ãæéãšãšãã«å€§ããé²åããŸãããç¹ã«ES6ïŒECMAScript 2015ïŒä»¥éã®ä»æ§ã§ã¯ããããã¹ïŒéåæåŠçïŒãã¢ããŒé¢æ°ããã³ãã¬ãŒããªãã©ã«ãªã©ã®åŒ·åãªæ©èœãè¿œå ãããããè€éãªåŠçãã·ã³ãã«ã«èšè¿°ã§ããããã«ãªããŸãããããã«ããããã©ãŠã¶äžã§é«åºŠãªãã¡ã€ã«åŠçãããŒã¿æäœãå¯èœã«ãªã£ãŠããŸãã
HTML5ãšWeb APIã®æ¡åŒµ: HTML5ã®å°å ¥ãšãšãã«ããã¡ã€ã«APIãBlobïŒBinary Large ObjectïŒAPIãªã©ããã©ãŠã¶ã§çŽæ¥ãã¡ã€ã«ãæ±ãããã®APIãæ¡å ãããŸããããããã®APIã䜿çšããããšã§ããã©ãŠã¶äžã§ãã¡ã€ã«ãçæãããŠãŒã¶ãŒã«ããŠã³ããŒããããããšãã§ããããã«ãªããŸããç¹ã«ãBlobãªããžã§ã¯ãã䜿ã£ãŠãã€ããªããŒã¿ãæ±ããURL.createObjectURL()ã¡ãœããã§ãã®ããŒã¿ãžã®ãªã³ã¯ãçæãã<a>ã¿ã°ã®hrefå±æ§ã«èšå®ããããšã§ããŠã³ããŒããªã³ã¯ãäœæã§ããŸãã
å€éšã©ã€ãã©ãªã®éçº: SheetJSãExcelJSã®ãããªå€éšã©ã€ãã©ãªãéçºãããããšã§ãéçºè ã¯ãããã®ã©ã€ãã©ãªãå©çšããããšã«ãããExcelãã¡ã€ã«ã®èªã¿æžããç°¡åã«å®è£ ã§ããããã«ãªããŸããããããã®ã©ã€ãã©ãªã¯ãExcelãã¡ã€ã«ã®æ§é ãç解ããJavaScriptãªããžã§ã¯ããšããŠæ±ãããšãå¯èœã«ããŸããããã«ããããã®ã©ã€ãã©ãªã¯CDNãéããŠç°¡åã«å©çšã§ããè¿ éã«æ©èœãå®è£ ã§ããå©ç¹ããããŸãã
ãã©ãŠã¶ã®æ§èœåäž: è¿å¹Žã®ãã©ãŠã¶ã¯å€§å¹ ã«æ§èœãåäžããŠããã以åã¯ãµãŒããŒãµã€ãã§ããå¯èœã§ã¯ãªãã£ãåŠçãã¯ã©ã€ã¢ã³ããµã€ãã§å®è¡ã§ããããã«ãªããŸããããã®æ§èœåäžã«ãããè€éãªããŒã¿åŠçããã¡ã€ã«æäœããã©ãŠã¶å ã§ã¹ã ãŒãºã«è¡ããããã«ãªããŸããã
ãé¡ãèŽããŸã