All Questions
7
questions
2
votes
1
answer
286
views
Parsing information from Excel files
I have to parse information from several Excel files (.xls, .xlsx). The structure of the files is nearly identical except for the columns order. In this case it is ...
2
votes
0
answers
69
views
Updating Excel sheet with information from a DataTable
Basically, I'm trying to update an excel sheet using a DataTable (The columns structure between the two are not the same) with respect to the following rules:
...
0
votes
1
answer
139
views
PCR analysis on data imported from Excel
I'm writing a program that is going to analyse some data imported from an Excel spreadsheet. It is currently running quite slow (couple seconds on an average machine) and I was wondering whether it ...
2
votes
0
answers
48
views
Creating an Excel sheet and appending namings for a matrix
I'm working on some VB.Net code to generate data sheets for giving user rights on a per folder level. I came up with this code but it's very slow and I feel like it could be improved.
...
7
votes
2
answers
2k
views
Tuning Excel calculation engine which uses MS Excel interop
I am currently building an Excel calculation engine. Its purpose is basically to wrap the calculation logic of an Excel workbook in order to use the logic from a C# library.
...
7
votes
2
answers
815
views
String tokenizer via UDF
I am trying to implement strings tokenizer in Excel via UDF using C# and Excel-Dna. Personally I found the mIRC's function $gettok pretty useful due to the lack of ...
4
votes
3
answers
5k
views
Getting a value from an Excel sheet column
The code below gets value from a column in an Excel sheet. The values I get are B1, B2, B3, B4...., B100, ...Bn. All I need to do is strip out the char 'B' and convert the numeric string to integer ...