Spreadsheet component with VBA support

Posted by Renaud Bompuis on Stack Overflow See other posts from Stack Overflow or by Renaud Bompuis
Published on 2010-05-19T03:32:36Z Indexed on 2010/05/19 3:40 UTC
Read the original article Hit count: 271

Filed under:

spreadsheet

|

spreadsheetgear

|

vba

|

excel

|

.NET

I am looking for a .Net spreadsheet component that could also execute the VBA contained in Excel files.

I found Spreadsheet Gears to be very nice for manipulating and allowing the user to edit Excel files, but on spreadsheets that use VBA for calculations, well, these don't work.

So, apart from Excel itself, are there any other components that can execute VBA?

Related posts about spreadsheet

Error while reading from spreadsheet in Ruby

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting following error while reading from a spreadsheet file. I have searched alot on Google. I have seen posts with similar problems but no reply to the problems. Does anyone know how to resolve this error? C:/Ruby/lib/ruby/gems/1.8/gems/ruby-ole-1.2.8.2/lib/ole/storage/file_system.rb:125:in… >>> More
Copy and paste the data one Excel spreadsheet to another spreadsheet based on column name

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to copy and paste the data from one Excel spreadsheet to another based on column name. For example, one shreadsheet has columns named like Asset, Asset owner. Another spreadsheet has column named like Application, Application Owner. Now I want "Asset" column data to copy and paste into the… >>> More
search & replace on 3000 row, 25 column spreadsheet

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm attempting to clean up data in this (old) spreadsheet and need to remove things like single and double quotes, HTML tags and so on. Trouble is, it's a 3000 row file with 25 columns and every spreadsheet app I've tried (NeoOffice, MS Excel, Apple Numbers) chokes on it. Hard. Any ideas on how else… >>> More
Translate report data export from RUEI into HTML for import into OpenOffice Calc Spreadsheets

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A common question of users is, How to import the data from the automated data export of Real User Experience Insight (RUEI) into tools for archiving, dashboarding or combination with other sets of data.XML is well-suited for such a translation via the companion Extensible Stylesheet Language Transformations… >>> More
What is spreadsheet useful for?

as seen on Programmers - Search for 'Programmers'
I have been in computer business for 15 years in various roles (sysadmin, developer, researcher), and I have never encountered someone using excel for something more advanced than for formatting tables, or as an ad-hoc database that could have been maintained in a text-file. I had to do heavy data-processing… >>> More

Developer IT

Spreadsheet component with VBA support - Developer IT

Spreadsheet component with VBA support

spreadsheet

spreadsheetgear

vba

excel

.NET

Related posts about spreadsheet

Error while reading from spreadsheet in Ruby

Copy and paste the data one Excel spreadsheet to another spreadsheet based on column name

search & replace on 3000 row, 25 column spreadsheet

Translate report data export from RUEI into HTML for import into OpenOffice Calc Spreadsheets

What is spreadsheet useful for?

Related posts about spreadsheetgear

Adding filter to Excel sheet columns using SpreadsheetGear?

How can I modify SpreadSheetGear's PrintPreview window (.NET)?

Data validation in excel cell using SpreadSheetGear.

Hiding cell Contains in MS Excel using SpreadSheetGear?

Hidind cell Contains in MS Excel using SpreadSheetGear?

Categories cloud