Read (Parse) Excel File (XLS and XLSX) from local Folder (Directory) using JavaScript

Question

I am using below articleRead Parse Excel File XLS and XLSX using JavaScriptIn this article Excel file is asking for upload then its reading content from excelBut in my project I have created folder ExcelFiles at root excel file always be kept inside ExcelFiles folder From that path I have to read all the contents availableIs it feasible If yes kindly show me example or reference

dharmendr · Accepted Answer

Hi SumeetRefer below codeHTMLlthtml xmlns34httpwwww3org1999xhtml34gtltheadgt    lttitlegtlttitlegtltheadgtltbodygt    ltinput type34button34 id34upload34 value34Display34 onclick34Display34 gt    lthr gt    ltdiv id34dvExcel34gtltdivgt    ltscript type34textjavascript34 src34httpscdnjscloudflarecomajaxlibsxlsx0135xlsxfullminjs34gtltscriptgt    ltscript type34textjavascript34 src34httpscdnjscloudflarecomajaxlibsxlsx0135jszipjs34gtltscriptgt    ltscript type34textjavascript34gt        function Display             var xhr  new XMLHttpRequest            xhropen34GET34 34ExcelFilesSamplexlsx34 true            xhrresponseType  34blob34            xhronload  function e                 var file  thisresponse                var reader  new FileReader

dharmendr · Answer

Referhttpsstackoverflowcomquestions10752055crossoriginrequestsareonlysupportedforhttperrorwhenloadingalocal

Read (Parse) Excel File (XLS and XLSX) from local Folder (Directory) using JavaScript

Read (Parse) Excel File (XLS and XLSX) using JavaScript

Company

Explore

Follow us

Contact Us