Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Get a reference to Excel spreadsheet?

Thread Tools

Get a reference to Excel spreadsheet?

Posts: n/a
I have an app that uses the DataDynamics spreadbuilder. It basically
creates an Excel spreadsheet and populates it with a dataset by looping
through the set. Everything works great except that the spreadbuilder
doesn't support formulas. I add formulas through the setvalue method but it
just puts a string of the formula in the cell. I have to manually go to the
cell and click the fx button with the formula cell selected. Is there some
c# code that I can get a reference to the open workbook/worksheet and pass a
cell reference so I can make sure and set it as a formula. Any ideas? I
don't want to have to redo the project using just excel. Any help is always

Thanks In Advance,

Reply With Quote

Thread Tools

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
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
using Microsoft Excel image for Export to Excel button =?Utf-8?B?U3JpZGhhcg==?= ASP .Net 0 12-09-2005 08:58 PM
exporting an excel file from database; making changes to excel file and updating the database by importing it back Luis Esteban Valencia ASP .Net 1 01-12-2005 12:28 AM
Excel _WorkBook vs. Excel.Workbook =?Utf-8?B?SmltIEhlYXZleQ==?= ASP .Net 1 09-29-2004 03:48 PM