在html表中读取Excel工作表数据 [英] Read excel sheet data in html table

问题描述

朋友，
我正在开发MVC框架，请打开office.org Excel工作表.我想在html表中显示Excel工作表的数据.

这段代码是要导出数据，但我想在视图的html表中显示相同的数据，即在.aspx页面中
任何MVC专家都可以告诉我代码.我是MVC的新手.
请帮我急.

Hi Friends,
I am working on MVC framework, open office.org excel sheet. I want to display the data of excel sheet in html table.

This code is to export the data, but i want to display the same data in html table in view i.e in .aspx page
Can any MVC experts tell me code. I am very new to MVC.
please help me its urgent.

[controller class]
 [AcceptVerbs(HttpVerbs.Post)]
        public ActionResult ExcelPackageCreate(string id)
        {
            try
            {
                
                FileInfo template = new FileInfo(Server.MapPath(@"\Content\ExcelPackageTemplate.xlsx"));

                FileInfo newFile = new FileInfo(Server.MapPath(@"\Content\ExcelPackageNewFile.xlsx"));

                // Using the template to create the newFile...
                using(ExcelPackage excelPackage = new ExcelPackage(newFile, template))
                {
                    // Getting the complete workbook...
                    ExcelWorkbook myWorkbook = excelPackage.Workbook;

                    // Getting the worksheet by its name...
                    ExcelWorksheet myWorksheet = myWorkbook.Worksheets["Sheet1"];
                   
                    // Setting the value 77 at row 5 column 1...
                    myWorksheet.Cell(5, 1).Value = 77.ToString();
                    
                    // Saving the change...
                    excelPackage.Save();
                }

                TempData["Message"] = "Excel report created successfully!";

                return RedirectToAction("ExcelPackage");
            }
            catch(Exception ex)
            {
                TempData["Message"] = "Oops! Something went wrong.";

                return RedirectToAction("ExcelPackage");
            }
        }

谢谢
问候
Madhu

Thanks
Regards
Madhu

推荐答案

Madu，您好，

从您的代码.您将重定向到操作"ExcelPackage".在此操作中，您可以将ur值保留为viewhtml或tempdata中的"htmlstring".可以在您的视图中访问此值.

例如:
在控制器中

tblStr =< table>< tr>< td>" +您的值" +</td></tr></table>"

ViewData("dvExcelData")==新的HtmlString(tblStr)
或
TempData("dvExcelData")==新的HtmlString(tblStr)


在视野中

< div id =''div''><％:TempData("dvExcelData")％></div>

注意:-Viewdata仅将数据存储在单个请求中

Hi Madu,

from your code . you redirect to the action "ExcelPackage".In this action you can keep ur value in a viewdata or tempdata as "htmlstring".this value can be access in your view.

eg:
In Controller

tblStr="<table><tr><td> " + "Your Value" + " </td></tr></table>"

ViewData("dvExcelData") == new HtmlString(tblStr)
Or
TempData("dvExcelData") == new HtmlString(tblStr)


In View

<div id=''div'' ><%:TempData("dvExcelData") %></div>

Note:- Viewdata only stores data in a single request

这篇关于在html表中读取Excel工作表数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！