将aspx / vb .net导出到多标签Excel？ [英] Export aspx/vb .net to multi-tabbed Excel?

问题描述

我一直在搜索各地，对vb .net / aspx来说有点新鲜，但不能

似乎找到了有用的东西。具体来说，我需要将一个数据集从bb .net编写的webapp导出到带有多个

选项卡的新excel电子表格中（每个选项卡将包含数据集中的不同行） ）。有没有人

有我可能会看到的任何示例代码或示例？


tia，

Bill

I have been searching everywhere AND am a bit new to vb .net/aspx, but can''t
seem to find anything that works. Specifically, I need to export a dataset
from a webapp written in vb .net to a new excel spreadsheet with multiple
tabs (each tab would contain different rows from the dataset). Does anyone
have any sample code or examples I might look at?

tia,
Bill

推荐答案

比尔，


这很简单，


你可以把你的数据在datagrid中然后将其导出到excel。看到。不确定

你的意思是tab（你的术语令人困惑）

http://www.c-sharpcorner.com/UploadF...idToExcel.aspx

祝你好运


" bill" < bi ** @nospam.comwrote in message

news：kx ************* @ newsfe06.lga ...

Bill,

This is easy,

You can put your data in datagrid then export it to excel. See. Not sure
what you mean by tab ( your terminology is confusing )

http://www.c-sharpcorner.com/UploadF...idToExcel.aspx
Good luck

"bill" <bi**@nospam.comwrote in message
news:kx*************@newsfe06.lga...

>我一直在搜索各地，对vb .net / aspx来说有点新鲜，但
似乎找不到任何有用的东西。具体来说，我需要将用vb .net编写的webapp导出一个
数据集到一个带有多个选项卡的新excel电子表格（每个选项卡将包含数据集中的不同行）。
是否有人我可以查看任何示例代码或示例吗？


tia，

Bill

>I have been searching everywhere AND am a bit new to vb .net/aspx, but
can''t seem to find anything that works. Specifically, I need to export a
dataset from a webapp written in vb .net to a new excel spreadsheet with
multiple tabs (each tab would contain different rows from the dataset).
Does anyone have any sample code or examples I might look at?

tia,
Bill

感谢您的快速回复!!


这种方法就是我目前正在做的只是为了快速而又脏兮兮的
出口。不幸的是，客户端需要

工作簿中的多个工作表来保存数据（我正在使用的方法以及

中概述的方法，您的链接会创建一个单独的工作簿表格....


比尔


LVP < lv ********** @ hotmail.comwrote in message

news：e9 ************** @ TK2MSFTNGP03.phx.gbl ...

Thanks for the quick reply!!

That method is how I am currently doing it just for a quick-and-dirty
export. Unfortunately, the client needs multiple worksheets within the
workbook to hold data (the method I am using and that which is outlined in
your link creates a single workbook with a single sheet)....

Bill

"LVP" <lv**********@hotmail.comwrote in message
news:e9**************@TK2MSFTNGP03.phx.gbl...

Bill，


这很简单，


你可以将您的数据放入datagrid然后将其导出到excel。看到。不确定

你的意思是tab（你的术语令人困惑）

http://www.c-sharpcorner.com/UploadF...idToExcel.aspx


祝你好运


" bill" < bi ** @nospam.comwrote in message

news：kx ************* @ newsfe06.lga ...

Bill,

This is easy,

You can put your data in datagrid then export it to excel. See. Not sure
what you mean by tab ( your terminology is confusing )

http://www.c-sharpcorner.com/UploadF...idToExcel.aspx
Good luck

"bill" <bi**@nospam.comwrote in message
news:kx*************@newsfe06.lga...

>>我一直在搜索各地，对vb .net / aspx来说有点新鲜，但
似乎找不到任何有用的东西。具体来说，我需要将用vb .net编写的webapp导出一个
数据集到一个带有多个选项卡的新excel电子表格（每个选项卡将包含数据集中的不同行）。
是否有人我可以查看任何示例代码或示例吗？

tia，
Bill

>>I have been searching everywhere AND am a bit new to vb .net/aspx, but
can''t seem to find anything that works. Specifically, I need to export a
dataset from a webapp written in vb .net to a new excel spreadsheet with
multiple tabs (each tab would contain different rows from the dataset).
Does anyone have any sample code or examples I might look at?

tia,
Bill

比尔，


这里有一个链接： http://support.microsoft.com/kb/306023

使用Office API


" bill" < bi ** @ nospam.comwrote in message

news：zA ************ @ newsfe06.lga ...

Bill,

here is a link for you: http://support.microsoft.com/kb/306023
Use Office API


"bill" <bi**@nospam.comwrote in message
news:zA************@newsfe06.lga...

感谢您的快速回复！


这种方法就是我目前正在做的只是为了快速而又脏兮兮的$ / b $ b出口。不幸的是，客户端需要

工作簿中的多个工作表来保存数据（我正在使用的方法以及

中概述的方法，您的链接会创建一个单独的工作簿表格....


比尔


LVP < lv ********** @ hotmail.comwrote in message

news：e9 ************** @ TK2MSFTNGP03.phx.gbl ...

Thanks for the quick reply!!

That method is how I am currently doing it just for a quick-and-dirty
export. Unfortunately, the client needs multiple worksheets within the
workbook to hold data (the method I am using and that which is outlined in
your link creates a single workbook with a single sheet)....

Bill

"LVP" <lv**********@hotmail.comwrote in message
news:e9**************@TK2MSFTNGP03.phx.gbl...

> Bill，

这很简单，

您可以将数据放入datagrid然后将其导出为ex​​cel。看到。不确定
你的意思是什么（你的术语令人困惑）

http://www.c-sharpcorner.com/UploadF...idToExcel.aspx

祝你好运

账单 < bi ** @ nospam.com写了留言
新闻：kx ************* @ newsfe06.lga ...

>Bill,

This is easy,

You can put your data in datagrid then export it to excel. See. Not sure
what you mean by tab ( your terminology is confusing )

http://www.c-sharpcorner.com/UploadF...idToExcel.aspx
Good luck

"bill" <bi**@nospam.comwrote in message
news:kx*************@newsfe06.lga...

>>>我一直在搜索各地，对vb .net / aspx有点新，但
似乎找不到任何有用的东西。具体来说，我需要将用vb .net编写的webapp导出一个
数据集到一个带有多个选项卡的新excel电子表格（每个选项卡将包含数据集中的不同行）。
是否有人我可以查看任何示例代码或示例吗？

tia，
Bill

>>>I have been searching everywhere AND am a bit new to vb .net/aspx, but
can''t seem to find anything that works. Specifically, I need to export a
dataset from a webapp written in vb .net to a new excel spreadsheet with
multiple tabs (each tab would contain different rows from the dataset).
Does anyone have any sample code or examples I might look at?

tia,
Bill

这篇关于将aspx / vb .net导出到多标签Excel？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！