DotNetNewsgroup.com  
web access to complete list of Microsoft.NET newsgroups
   home   |   control panel login   |   archive  |  
 
  carried group
academic
adonet
aspnet
aspnet.announcements
aspnet.buildingcontrols
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
assignment_manager
datatools
dotnet.distributed_apps
dotnet.general
dotnet.myservices
dotnet.nternationalization
dotnet.scripting
dotnet.security
dotnet.vjsharp
dotnet.vsa
dotnet.xml
dotnetfaqs
framework
framework.clr
framework.compactframework
framework.component_services
framework.controls
framework.databinding
framework.drawing
framework.enhancements
framework.interop
framework.odbcnet
framework.performance
framework.remoting
framework.sdk
framework.setup
framework.webservices
framework.windowsforms
framework.wmi
frwk.windowsforms.designtime
lang.csharp
lang.jscript
lang.vb
lang.vb.controls
lang.vb.data
lang.vb.upgrade
lang.vc
lang.vc.libraries
  
 
start date: Mon, 16 Jul 2007 12:59:26 -0700,    posted on: microsoft.public.dotnet.framework.interop        back       

Thread Index
  1    mookid


How to access the contents of data cells in Excel   
I have made a toolbar plugin for Excel using C#.NET interop.

As far as I can tell, the only way to read/write the contents of cells
is something like this:

    Range r = Excel._Application.Cells.Cells[row, col] as Range;
    string text = r.FormulaLocal as string;

i.e. by extracting a Range, which contains only one cell, and then
using the properties on that Range object to set/get the data.

This way seems to be horribly slow however, so I'm wondering if anyone
can tell me how to do it faster?

Thanks in advance.

Best regards,
Mogens
Date:Mon, 16 Jul 2007 12:59:26 -0700   Author:  

Google
 
Web dotnetnewsgroup.com


COPYRIGHT ?2005, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE  |   Contact us