从我的表格表格数据导出数据到excel. [英] export data into excel from my form table data.

问题描述

我的表单中有数据.数据包含行和列格式.

当我单击按钮时，我只想将数据从表单表数据导出到excel.

Hi,

I have data in my form. the data contains row and column format.

when i click the button, just i want to export data into excel from my form table data.

How to do that...?

推荐答案

Google是您的朋友:很好，经常拜访他.与在这里发布问题相比，他可以更快地回答问题.

一个快速的Google 使用您的主题行作为搜索词 给了我很多点击量.

包括此站点上的文章:使用VB.Net导出到Excel [

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...

A quick google using your subject line as the search term gave me loads of hits.

Including an article on this very site: Export to Excel using VB.Net[^]

尝试下面的代码

Hi try below code

public static void DownloadExcel(string xlFilePath, string fileName)
{
if (System.IO.File.Exists(xlFilePath))
            {
                Page currentPage = HttpContext.Current.CurrentHandler as Page;
                currentPage.Response.Clear();
                currentPage.Response.Charset = "";
                currentPage.Response.ContentType = "sample.xls";
                currentPage.Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
                byte[] DBuffer;
                using (FileStream objFileStream = new FileStream(xlFilePath, FileMode.Open, FileAccess.Read))
                {
                    DBuffer = new byte[(int)objFileStream.Length];
                    int index = 0;
                    int maxCount = 32767;
                    int remCount = DBuffer.Length;
                    while (index < DBuffer.Length)
                    {
                        if (maxCount > remCount)
                            maxCount = remCount;
                        objFileStream.Read(DBuffer,index,maxCount);
                        index = index + maxCount;
                        remCount = remCount - maxCount;
                    }
                }
                currentPage.Response.Buffer = true;
                currentPage.Response.BinaryWrite(DBuffer);
                currentPage.Response.End();
            }
        }
}

这篇关于从我的表格表格数据导出数据到excel.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！