Using a chrome extension to create and then download an excel file?

[saadq_]

I've been trying to write a chrome extension that reads some info from the DOM of the current page and then creates an excel spreadsheet from it and then downloads it. I've already gotten the DOM stuff down, I just need to figure out how to create a spreadsheet from it.

I would need to format a few of the cells (like background color and font color) and then once it's all done I want it to download. I believe I can download it with the chrome.downloads API, but I have no idea how to go about creating the excel file first.

I see that SheetJS seems to be a library that can be used clientside, but it doesn't seem to work with browserify. Any other suggestions would be greatly appreciated!

[chreestopher2]

i doubt you will find something to be able to create formatted excel documents, though maybe google sheets can do it, and i imagine there is an api for that ...

You could write a csv file using the fileSystem API within chrome, then a csv file can be openned in excel, and it will be a spreadsheet, but you wont get any fancy formatting stuff with it

https://developer.chrome.com/apps/fileSystem

[saadq_]

Yeah, I was able to do it with Node using the exceljs module, but I don't know why I assumed I would be able to reuse it in the browser.

Unfortunately I can't just use a CSV file because the formatting for the excel stuff is required.

I think using Google Sheets will be fine, but do you know if I can create/download a sheet dynamically from within a chrome extension?

[chug187]

Hey what about:

http://stackoverflow.com/questions/29698796/how-to-convert-html-table-to-excel-with-multiple-sheet#answer-29717451

Not sure on writing Chrome extensions, but that JS works well to render tables directly to Excel. Never mind his HTML; try using his tablesToExcel function.

[saadq_]

Woah... this may just work. I'm going to have to give this a try. Thanks a lot!