Excel Report using ASP.NET

**Mark Rae** · Mar 30 '07, 07:45 AM

Re: Excel Report using ASP.NET

"Rajesh" <rajesh1808@gma il.comwrote in message
news:1175238232 .030657.117630@ y80g2000hsf.goo glegroups.com.. .

Please help me to do an EXCEL report generation using ASP.NET.
I am building an website. This should work in all machine.
I need do load the data from SQL tables to excel sheet and user can
modify the data in the excel sheet. Then i need to get the data from
modified excel sheet and generate the graphical Chart.
>
But the machine need not installed MS EXCEL application. At the same
time the automated excel sheet should work in any machine that do not
have specific component installed and also Microsoft Excel.

Two ways:

1) Use the XML file format:

http://www.microsoft.com/downloads/details.aspx?familyid=fe118952-3547-420a-a412-00a2662442d9&displaylang=en

This is completely free, but most definitely not for the faint-hearted...

2) Use Aspose:

404 Page not found

http://www.aspose.com/Products/Aspose.Cells/Default.aspx

File Format SDKs for .NET, Java, PHP, JavaScript, SharePoint, Android, Reporting Services and JasperReports for web, desktop, and mobile platforms.

This is not free, but is extremely simple to use

Don't even think about server-side Office automation - there's a good chance
it won't work, and Microsoft don't support it:

Error - Office.com

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

**Alexey Smirnov** · Mar 30 '07, 09:05 AM

Re: Excel Report using ASP.NET

On Mar 30, 9:03 am, "Rajesh" <rajesh1...@gma il.comwrote:

I need do load the data from SQL tables to excel sheet and user can
modify the data in the excel sheet.
...
excel sheet should work in any machine that do not
have specific component installed and also Microsoft Excel.

You want to open a file on the client in the application that is not
installed. It's not possible.

I would consider another way. Why do you need to load anything on a
client? Your goal is to make a chart, based on an user input. Therefor
I would create an editable datagrid, bind data to a datagrid, collect
an input and generate a chart. No Excel.

**Rajesh** · Mar 30 '07, 09:15 AM

Re: Excel Report using ASP.NET

On Mar 30, 1:58 pm, "Alexey Smirnov" <alexey.smir... @gmail.comwrote :

On Mar 30, 9:03 am, "Rajesh" <rajesh1...@gma il.comwrote:
>

I need do load the data from SQL tables toexcelsheet and user can
modify the data in theexcelsheet.
...
excelsheet should work in any machine that do not
have specific component installed and also MicrosoftExcel.

>
You want to open a file on the client in the application that is not
installed. It's not possible.
>
I would consider another way. Why do you need to load anything on a
client? Your goal is to make a chart, based on an user input. Therefor
I would create an editable datagrid, bind data to a datagrid, collect
an input and generate a chart. NoExcel.

Hi Smirnov,

thanks for ypur reply.

Can you tell me how to do that.

My requirement is: I need to load the table data to editable sheet and
get the modified data to create a Graphical chart.

is it possible to do without using the excel sheet. If then please let
me know how to do that.

regards,
Rajesh

**Alexey Smirnov** · Mar 30 '07, 09:25 AM

Re: Excel Report using ASP.NET

On Mar 30, 11:09 am, "Rajesh" <rajesh1...@gma il.comwrote:

On Mar 30, 1:58 pm, "Alexey Smirnov" <alexey.smir... @gmail.comwrote :
>

On Mar 30, 9:03 am, "Rajesh" <rajesh1...@gma il.comwrote:

>

I need do load the data from SQL tables toexcelsheet and user can
modify the data in theexcelsheet.
...
>excelsheet should work in any machine that do not
have specific component installed and also MicrosoftExcel.

>

You want to open a file on the client in the application that is not
installed. It's not possible.

>

I would consider another way. Why do you need to load anything on a
client? Your goal is to make a chart, based on an user input. Therefor
I would create an editable datagrid, bind data to a datagrid, collect
an input and generate a chart. NoExcel.

>
Hi Smirnov,
>
thanks for ypur reply.
>
Can you tell me how to do that.
>
My requirement is: I need to load the table data to editable sheet and
get the modified data to create a Graphical chart.
>
is it possible to do without using the excel sheet. If then please let
me know how to do that.
>
regards,
Rajesh

Check the Quick Start samples:

http://samples.gotdotnet.com/quickstart/aspplus/samples/webforms/ctrlref/webctrl/datagrid/doc_datagrid.aspx

#1 Edit per row

http://samples.gotdotnet.com/quickstart/aspplus/samples/webforms/ctrlref/webctrl/datagrid/VB/datagrid6.aspx

#2 Edit all rows

http://samples.gotdotnet.com/quickstart/aspplus/samples/webforms/ctrlref/webctrl/datagrid/VB/datagrid13.aspx

More about datagrid

editable datagrid asp.net - Google Search

http://www.google.com/search?hl=en&q=editable+datagrid+asp.net

More about charting

chart asp.net - Google Search

http://www.google.com/search?hl=en&q=chart+asp.net

**Steve C. Orr [MCSD, MVP, CSM, ASP Insider]** · Mar 30 '07, 08:25 PM

Re: Excel Report using ASP.NET

You could open an existing Excel file and modify it as an ADO.NET data
source:

http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/thread/f716314d90e974e5/571439ff12d7473d%23571439ff12d7473d

Or here are some other ways to create Excel output:

HALOJP: Situs Slot Online Terbaik Resmi Gacor Depo 10K Gampang Maxwin

http://SteveOrr.net/articles/ExcelExport.aspx