Skip to content

[js] 第99天 不用第三方库，说说纯js怎么实现读取和导出excel？ #977

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
haizhilin2013 opened this issue Jul 23, 2019 · 4 comments
Open

[js] 第99天 不用第三方库，说说纯js怎么实现读取和导出excel？ #977

haizhilin2013 opened this issue Jul 23, 2019 · 4 comments
Labels
js JavaScript

Comments

@haizhilin2013
Copy link
Collaborator

第99天 不用第三方库，说说纯js怎么实现读取和导出excel？
@haizhilin2013 haizhilin2013 added the js JavaScript label Jul 23, 2019
@xxf1996
Copy link

xxf1996 commented Jul 24, 2019

目前只知道将后端给的二进制数据包装成Blob对象，然后进行导出；

const blob = new Blob([res], { type: 'application/msexcel;charset=UTF-8' })
const url = URL.createObjectURL(blob)
const a = document.createElement('a')
a.href = url
a.click()

@liaofangyuan
Copy link 

 let blob = new Blob([res.data],{type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});
            let a = document.createElement('a')
            a.download = 'XXX.xlsx'
            a.href =URL.createObjectURL(blob) 
            document.body.appendChild(a)
            a.click()

@EragonBubble
Copy link

提醒一下 Blob的浏览器支持 IE10+

@haizhilin2013 haizhilin2013 mentioned this issue Feb 20, 2021
Open
@xiaoqiangz
Copy link

目前只知道将后端给的二进制数据包装成Blob对象，然后进行导出；

const blob = new Blob([res], { type: 'application/msexcel;charset=UTF-8' })
const url = URL.createObjectURL(blob)
const a = document.createElement('a')
a.href = url
a.click()

m

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
js JavaScript
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@haizhilin2013 @xiaoqiangz @xxf1996 @EragonBubble @liaofangyuan