VB.net spreadsheet Output tools

[Rob]

I've got many accounting oriented customers who just love spreadsheets...

Using a vb.net front end and an sql server back end, what tools, or
components, would you suggest to generate "Formatted" spreadsheets.

Note, that I am not talking about simple extracts to Excel, rather full-on
spreadsheets with formulas, proper column widths etc....

I've done some stuff using MS Access (VBA), but is there something better
that works well in a dot net evironment ?

Thanks !

 

[ge0193387]

I've got many accounting oriented customers who just love spreadsheets...

Using a vb.net front end and an sql server back end, what tools, or
components, would you suggest to generate "Formatted" spreadsheets.

Note, that I am not talking about simple extracts to Excel, rather full-on
spreadsheets with formulas, proper column widths etc....

I've done some stuff using MS Access (VBA), but is there something better
that works well in a dot net evironment ?

Thanks !

You can use the MS Office Excel Interop.
You will be able to do formatted spreadsheets but have fun tooling
away within that object model.

If you don't know about the Excel Interop just add a reference to
Microsoft Office # (9.0, 10.0, 11.0...).

 

[Tom Shelton]

I've got many accounting oriented customers who just love spreadsheets...

Using a vb.net front end and an sql server back end, what tools, or
components, would you suggest to generate "Formatted" spreadsheets.

Note, that I am not talking about simple extracts to Excel, rather full-on
spreadsheets with formulas, proper column widths etc....

I've done some stuff using MS Access (VBA), but is there something better
that works well in a dot net evironment ?

Thanks !

It's been a while, but I have used FarPoint spread for this sort of
thing in the past....

 

[jay parzych]

CarlosAg Excel Xml Writer Library:

http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx

 

[williamsonhouse]

Hi Rob,

As Tom mentioned (thanks Tom!), that's exactly what our product is...a
fully featured spreadsheet component (over 300 built-in functions,
etc) with an Excel look and feel.

Here's the product page for the Windows Forms version:
http://www.fpoint.com/netproducts/spreadwin/spreadwin.aspx

And here's the page for the ASP.NET version:
http://www.fpoint.com/netproducts/spreadweb/spread.aspx

Both have product tours and you can download a 30-day eval to make
sure it does what you need. Also, please be sure to make use of our
public forums at http://www.clubfarpoint.com/Forums/forums/default.aspx.

Please let me know if you have any questions. Thanks!

- Donald
FarPoint Technologies, Inc.