473,326 Members | 2,136 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Create Excel file using asp.net

I want to create an excel file for report in asp.net 2.0 ...
without having office installed on the server.

Rahul
Apr 11 '07 #1
4 24076
"Rahul" <ra*******@hotmail.comwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
>I want to create an excel file for report in asp.net 2.0 ...
No problem.
without having office installed on the server.
Hurrah! Glad to hear it!

Basically, you have three choices:

1) HTML
Create an HTML document and save it with a .xls extension - Excel will open
it and treat it like a native Excel file. This method is very simple and, of
course, free - however, it won't allow you to have more than one worksheet
in the Excel workbook...

2) Use the (relatively) new XML file format
http://www.microsoft.com/downloads/d...displaylang=en
http://www.microsoft.com/downloads/d...displaylang=en
This is also free, and incredibly powerful, but not for the faint-hearted...

3) Use Aspose
http://www.aspose.com/Products/Aspos...s/Default.aspx
This is not free, but is extremely simple to use.
Apr 11 '07 #2
The fastest way is to create a html file containing a table and renaming it
to .xls
We use this for large files. The html is created using a webcontrol which
we've written on which we call the render function using a htmltextwriter
that wraps a stringwriter.

If you want more of the excel functionallity you'd have to get some excel
output component.

hope this helps!
/mortb

"Rahul" <ra*******@hotmail.comwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
>I want to create an excel file for report in asp.net 2.0 ...
without having office installed on the server.

Rahul

Apr 11 '07 #3
Hello Rahul,

See this http://chicago.sourceforge.net/devel/docs/excel/

---
WBR, Michael Nemtsev [.NET/C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

RI want to create an excel file for report in asp.net 2.0 ... without
Rhaving office installed on the server.
R>
RRahul
R>
Apr 11 '07 #4
You could open an existing Excel file and modify it as an ADO.NET data
source:
http://groups.google.com/group/micro...1439ff12d7473d

Or here are some other ways to create Excel output:
http://SteveOrr.net/articles/ExcelExport.aspx

Here's a free control that can help with Excel output (and Word, PowerPoint,
and WordPerfect output):
http://SteveOrr.net/articles/ExportPanel.aspx

And here are a couple good 3rd party products that can make your chores
easy:
http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
"Rahul" <ra*******@hotmail.comwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
>I want to create an excel file for report in asp.net 2.0 ...
without having office installed on the server.

Rahul
Apr 11 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: | last post by:
Greets, How does one connect to a local excel file using data wizard is it possible? I'm trying to connect to an excel file and populate a dataset and combo box with the data from excel TIA
4
by: Reny J Joseph Thuthikattu | last post by:
Hi, Can any one guide me to read an excel file using vb.net? Reagrds Reny --- Outgoing mail is certified Virus Free.
5
by: Narendar123P | last post by:
Hi all, I am trying to plot a graph in excel file using C#.Net. I am using the name space excel . If my graph has one series(2 columns), i am able to draw the graph. if my graph has two series(4...
0
by: newUser1234 | last post by:
I'm trying to read and write from an excel file using this method..My application can read the excel file without problems but doesn't write anything to the file i want it to write. I've also tried...
1
hidash
by: hidash | last post by:
hi everyone, i need some help in opening excel and word file using poi filesystem. i have created a new word and excel file using poi. but i am struggling to open the existing file using poi. pls...
1
by: SagarDoke | last post by:
I have a txt file. I want to add the data from that file into the excel file using java. That data is delimited by spaces as follows: 1 Sagar Doke Address Roll No. City 2 ABC ...
1
by: veer | last post by:
Hi i made a programe in which i want to create and write in excel file using streamreader and streamwriter it works fine when writing a single value but when i use a loop to write multiple values...
2
by: veer | last post by:
Hi i want to open excel file using vb.net . The file is passsword protected and i know the password when i used to open the file with out password it works fine and open but when the file with...
1
by: baburmm | last post by:
Hi all, Can any one tell me, Export datas to a Excel file using query without openrowset method is there any other methods are posible for creating an Excel file to export it Thanks,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.