If you can afford it, use
http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx>Hi,
>
>I need to analyze some data in an Excel worksheet and then modify some of the existing cells, and then also add new rows of data to the Excel worksheet.
>
>Historically, I've been using VFP and COM to do this task. But now I'm looking to upgrade my process to .NET. (Either C# or VB in VS2010).
>
>Is COM the recommended way to do this from .NET? Or does .NET have better ways to manipulate Excel?
>
>And... does anyone have links to any sample code that might get me going in the right direction?
>
>Thanks,
>Guy
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com