How to export html value(not table) to a csv file with jquery?

Question

I have a page user can dynamic add or edit html value like below, and I need to save it to database, I found a way- php read csv file and then update to database, but now my problem is

<div class="list">
    <div class="number">1</div>
    <div class="text">a</div>
    <div class="text">a</div>
</div>
<div class="list">
    <div class="number">1</div>
    <div class="text">a</div>
    <div class="text">a</div>
</div>
..

if you mean the number and letters in the divs, you need .text() — Patrick Evans
– Patrick Evans, Commented Jul 17, 2013 at 21:03

dandavis · Accepted Answer · 2013-07-17 21:17:12Z

4

if you don't have comma-containing strings:

var csv = jQuery(".list").map(function(a,i){
  return $.trim($(this).text()).split(/\s*\n\s*/).join(",");
}).toArray().join("\r\n");

alert(csv);

you can use my downloader at http://danml.com/js/download.js to download the csv variable like:

 download(csv, "tabledata.csv", "text/csv");

edited Jul 17, 2013 at 21:17

answered Jul 17, 2013 at 21:04

dandavis

16.8k5 gold badges43 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

vibskov Over a year ago

I use download.js but get console.log INVALID_CHARACTER_ERR: DOM Exception 5: An invalid or illegal character was specified, such as in an XML name. is it because I have chinese in html value ? how to fix it?

vibskov Over a year ago

even if take off chinese character test it still get nterpreted as Document but transferred with MIME type text/csv and

Unsafe JavaScript attempt to access frame with URL data:text/csv;base64,MywwLDIsMA0KMSwwLDEsMQ0KMCwwLDAsMA0KNiwwLDQsMA0KNCwwLDMsMA== from frame with URL about:blank. Domains, protocols and ports must match.

dandavis Over a year ago

yes, chinese can break the atob() routine. i can likely fix that part, but which browser is giving you trouble?

vibskov Over a year ago

Thanks so much! and the browser is safari 5, and so cool I test in firefox it works export a file to desktop. except chinese character can't be read in file. but after user click save I need to export the file in server folder then php open it. How to save the file to to server path??

dandavis Over a year ago

ahh. i don't have any magic to make it save on the server, JS can only control the client machine. you will need to ask again with a php tag for info on that. I did update the script to support chinese, but Safari5 is an older browser that won't support these type of downloads. I've tested it in IE10, Chrome, and Firefox. Sorry about the confusion and good luck!

Collectives™ on Stack Overflow

How to export html value(not table) to a csv file with jquery?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related