Comments (4)
That uses the html5 FileReader API: http://www.w3.org/TR/FileAPI/#FileReader-interface -- the processing occurs in your browser (the file is not sent anywhere)
The relevant code is located at: https://github.com/Niggler/js-xlsx/blob/gh-pages/index.html#L85-L100
function handleDrop(e) {
e.stopPropagation();
e.preventDefault();
var files = e.dataTransfer.files;
var i,f;
for (i = 0, f = files[i]; i != files.length; ++i) {
var reader = new FileReader();
var name = f.name;
reader.onload = function(e) {
var data = e.target.result; // <-- 'data' contains the sheet data
var xlsx = XLSX.read(data, {type: 'binary'}); // <--'xlsx' is an object that holds the relevant data
process_xlsx(xlsx);
};
reader.readAsBinaryString(f);
}
}
drop.addEventListener('drop', handleDrop, false);
To see how to work with those, look at the definitions of process_xlsx
and to_csv
and to_json
from sheetjs.
Thanks for your update..
My Question is how to get the file after drop, i need to insert the same file in my document object.
Could you please help me how to get the file after drop the file.
Once i get the file i will save into document object.
Thanks,
Vinay
from sheetjs.
Thanks for your update..
My Question is how to get the file after drop, i need to insert the same file in my document object.
Could you please help me how to get the file after drop the file.
Once i get the file i will save into document object.
Thanks,
Vinay
Many thanks and have a nice day.
Best regards,
Vinay Kumar Chada
ACCENTURE. India
Mobile +91 9538995147
P Printing e-mails kills trees.
From: Niggler [[email protected]]
Sent: 11 April 2013 19:19:33
To: Niggler/js-xlsx
Cc: Kumar Chada, Vinay
Subject: Re: [js-xlsx] Handle to XLSX file dragged and dropped (#21)
That uses the html5 FileReader API: http://www.w3.org/TR/FileAPI/#FileReader-interface -- the processing occurs in your browser (the file is not sent anywhere)
The relevant code is located at: https://github.com/Niggler/js-xlsx/blob/gh-pages/index.html#L85-L100
function handleDrop(e) {
e.stopPropagation();
e.preventDefault();
var files = e.dataTransfer.files;
var i,f;
for (i = 0, f = files[i]; i != files.length; ++i) {
var reader = new FileReader();
var name = f.name;
reader.onload = function(e) {
var data = e.target.result; // <-- 'data' contains the sheet data
var xlsx = XLSX.read(data, {type: 'binary'}); // <--'xlsx' is an object that holds the relevant data
process_xlsx(xlsx);
};
reader.readAsBinaryString(f);
}
}
drop.addEventListener('drop', handleDrop, false);
To see how to work with those, look at the definitions of process_xlsx and to_csv and to_json
—
Reply to this email directly or view it on GitHubhttps://github.com//issues/21#issuecomment-16235394.
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited.
Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
from sheetjs.
@vinaychada Look at the code sample from my response. The original data is available in the reader.onload callback (this line: var data = e.target.result; // <-- 'data' contains the sheet data
) and the parsed sheet data is available from XLSX.readFile (this line: var xlsx = XLSX.read(data, {type: 'binary'}); // <--'xlsx' is an object that holds the relevant data
from sheetjs.
Related Issues (20)
- Gettting an Array, but of scrambled data 😰 HOT 2
- sheet_to_json from remote file not working HOT 2
- Unable to set name for worksheet separately from workbook HOT 3
- xlsx CP932 Incorrect output HOT 3
- Error appears in bower js-xlsx#~0.11.5 HOT 4
- sheet_to_json: inconsistent blank cell parsing HOT 2
- format entire column HOT 2
- reading text in shapes HOT 1
- Rearranging the XLSX.write order HOT 1
- Add VBA script to file I am creating from scratch HOT 2
- Wrong filename when download file HOT 1
- How to Define name for a range ? HOT 1
- Need to Prevent formatting of dates while reading a csv
- No option to change delimiter when writing CSV HOT 1
- Export to excel- Hyperlink doesn't work on documentation page HOT 1
- reading and writing the excel with Symbols,photos, in different tabs.
- QUOTE not defined HOT 9
- [Security] Prototype Pollution in sheetJS HOT 27
- Archive this GitHub Project HOT 3
- Thanks!
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sheetjs.