PC Review


Reply
Thread Tools Rate Thread

Datagrid to excel

 
 
AVL
Guest
Posts: n/a
 
      26th Feb 2008
Hi,
I;ve a requirement wherein the need to export the data from grid to excel file
using .net 1.1..

While I do the export to file, sfew columns in teh excel file should be
locked,
in the sense..use shouldn't be able to edit the values in those columns...

is this possible thru C#? any samples
 
Reply With Quote
 
 
 
 
sloan
Guest
Posts: n/a
 
      26th Feb 2008
You can get simple excel exporting with a few lines of code.

Google it ...

HOWEVER

Based on your need to have some rows locked.....you've just walked over to
the otherside.. From easy to alot harder.

I would look at
http://www.aspnetpro.com/Productrevi...200311so_p.asp

aspose.excel

good luck

.............

If your $$$ is more valuable than your time....then you can also do this.
(lots and lots of hours)

Create a basic, but complete example of your table data, and locked row.
Save as Xml (in Excel XP or later)
Open it up and notepad.

Learn how to code up xml based excel......using lots and lots of namespaces
and such.




"AVL" <(E-Mail Removed)> wrote in message
news:E2AF0841-61A8-4E33-8C28-(E-Mail Removed)...
> Hi,
> I;ve a requirement wherein the need to export the data from grid to excel
> file
> using .net 1.1..
>
> While I do the export to file, sfew columns in teh excel file should be
> locked,
> in the sense..use shouldn't be able to edit the values in those columns...
>
> is this possible thru C#? any samples



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add a Dropdown list to a datagrid at runtime (dynamic) without using template columns in ASP.NET and still have the ability to us the datagrid Update event. Daniel Roth Microsoft Dot NET Framework 0 5th Apr 2005 04:54 AM
click on datagrid item, display new datagrid based on that click =?Utf-8?B?TmljaG9sYXNwMjc=?= Microsoft ADO .NET 1 22nd Oct 2004 08:40 PM
RE: Datagrid: how cut short display of a long description in a datagrid column =?Utf-8?B?U3VyZXNo?= Microsoft ASP .NET 0 2nd Mar 2004 09:31 PM
datagrid in datagrid BK Kim Microsoft ASP .NET 1 2nd Mar 2004 07:34 AM
Call Datagrid Command column outside datagrid Dave Microsoft ASP .NET 0 20th Nov 2003 12:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:41 PM.