search

AlaSQL / alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.
http://alasql.org
MIT License
7.03k stars 656 forks source link

Feature Request: Export data to an existing Excel file #948

Open cscan opened 7 years ago

cscan commented 7 years ago

It is nice if alasql could export the data to an existing Excel file which already created before. It is good if you have an Excel which contains many formatting and macro scripts.

mathiasrw commented 7 years ago

Any inputs on how to update an excel file would be much appreciated.

I have a feeling the "correct" way to do the excel magic you are looking for would be to have data in separated files, and one excel with macros that reads data from the files

cscan commented 7 years ago

Thanks for your response. Let me describe more details of our environment. In our environment, we have many formatted Excels with charts inside. Now we are using Java POI to open the existing Excel and put the raw data in a tabsheet. When the end user open that Excel file, all the formatted reports and charts are correctly shown in other tabsheets.

Though the POI can resolve our problem. But I like alasql syntax more. If alasql can export to an existing Excel, it is perfect for us. Thanks.

mathiasrw commented 7 years ago

Sounds like what you really need is a SQL db with excel fetching data live

cscan commented 7 years ago

Our data comes from database, we extract part of data and put in various Excel template using Java POI now. Extraction data using alasql is no problem, thanks for your great tool. What I want is output the results to Excel template which already exists and formatted.

Suncatcher commented 6 years ago

Would like this feature too.