Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
| 150513 | Jan 9,2020 12:02 PM UTC | Feb 12,2020 02:17 AM UTC | Vue | 2 |
|
Tags: Spreadsheet |
|
public IActionResult Open(IFormCollection openRequest)
{
OpenRequest open = new OpenRequest();
MemoryStream memoryStream = new MemoryStream();
openRequest.Files[0].CopyTo(memoryStream); // Excel file is converted into Memory Stream
IFormFile formFile = new FormFile(memoryStream, 0, memoryStream.Length, "", openRequest.Files[0].FileName); // converting MemoryStream to IFormFile
open.File = formFile;
return Content(Workbook.Open(open));
} |
|
<template>
<ejs-spreadsheet ref="spreadsheetRef" openUrl="http://localhost:55367/Home/Open" saveUrl="http://localhost:55367/Home/Save" :created="onCreated"></ejs-spreadsheet>
</template>
<script>
import Vue from 'vue';
import { SpreadsheetPlugin } from '@syncfusion/ej2-vue-spreadsheet';
Vue.use(SpreadsheetPlugin);
export default {
methods: {
onCreated: function() {
var request = new XMLHttpRequest();
request.responseType = "blob";
request.onload = () => {
var file = new File([request.response], "Sample1.xlsx");
this.$refs.spreadsheetRef.open({ file: file });
}
request.open("GET", "http://localhost:55367/" + "Sample1.xlsx");
request.send();
}
}
}
</script> |
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
